I’m having a record hesitation issue with a form in Servoy. My form has six tab’ed interfaces all connected to the main form through relationships on the primary key of ‘custid’. The solution seems to hesitate when I scroll through the record set using the controller. I’ve indexed all my foreign keys and related them to the main table on the SQL 2000 side, but it still appears to be slow. Below is a listing of my joined tables and the number of records in each table. My Servoy server is running under Windows 2003 and I have a dedicated SQL server. I’m using MS SQL as my repository and my DB. Any ideas on how I can get the solutions performance up?
CustomerTable (Main form) = 64626 records
CustomerBillingTable (tab) = 1322 records
CustomerEmployerInfoTable (tab) = 3063 records
CustomerHistoryCombineTable (tab) = 18090 records
CustomerMarketingTable (tab) = 1752 records
CustomerNotesTable (tab) = 22598 records
CustomerOrderDetailTable (tab) = 10484 records
Not using any calulations on this from and I don’t have an onload functions. I do have alot of records. I’m joining 5 forms to a main form with a record count of about 64,000. The other five froms have around 75,000 to 100,000 total records. What’s your high number of records?
I’m just the opposite. Does anyone else have any experience with a solution hitting a high record count DB with multiple joins. Also, what about moving my Servoy server to the DB server. I think it’s strong enough to handle both programs, but I’m not sure about the ramification of them coexisting on the same server? I use a single server solution in testing without a problem. Thanks as always.
gensolo:
I’m just the opposite. Does anyone else have any experience with a solution hitting a high record count DB with multiple joins. Also, what about moving my Servoy server to the DB server. I think it’s strong enough to handle both programs, but I’m not sure about the ramification of them coexisting on the same server? I use a single server solution in testing without a problem. Thanks as always.
Jim
Hi Jim,
No problem having Servoy Server and SQL Server on same box. Our app server is very lightweight.
The number of records doesn’t make any difference. The thing that can cause it to “hesitate” is your single primary key and then displaying 5 portals (or tabpanels with list view). We have to issue 5 queries and grab the related data and then draw it. Once you do it the first time, the data is cached, so it shouldn’t be an issue.
Bob thanks for the reply. I really appreciate the Servoy product and it’s easy of development and use. It’s been pretty smooth sailing with quick issue resolution so far and I’m sure this problem can be resolved as easily.
The current version of my solution is an exact copy of an existing filemaker interface. The startup form is my main screen and has five tab panels and two portals. Onload it seems to freeze for a few seconds then when you scroll through each set of data it pauses again for a few seconds. If you go to the Brochure form under the windows tab you’ll get the short version of the startup form with only one set of table data. The custometable2 form is the same basic information as the startup screen only the joined forms are on a multi tab, tab panel, not all called on the page at once. I’d like to know if the performance I’m getting from each of these different forms is to be expected from a solution of this design (the use of tabs and panels to display all info). Or, what I can do on the SQL and server side to ensure good connectivity (Currently I run Servoy Server on a dedicated Windows 2003 2.4 GHz, 1.5 GB ram and SQL server on a dedicated Windows 2003 3.0 GHz, 1.0 GB ram both servers run at 2 to 5% most of the time. All my tables have primary keys and indexes on the joining fields). Again, I appreciate any help and include the information below that will allow you to access my solution if you need too.