Luis German Posted May 30, 2021 Share Posted May 30, 2021 I am using Unitimer that refresh data from a query on a Unidbgrid every 10 seconds. I notice that the refresh operation of the grid goes slow while i open more and more sessions. Loading simultaneolsy the data into another controls like memo or lookup combox, these controls show the data inmediatly. What to do in order to speed up the way Unidbgrid shows the information? Regards Luis Quote Link to comment Share on other sites More sharing options...
Sherzod Posted May 31, 2021 Share Posted May 31, 2021 4 hours ago, Luis German said: I am using Unitimer that refresh data from a query on a Unidbgrid every 10 seconds. I notice that the refresh operation of the grid goes slow while i open more and more sessions. Loading simultaneolsy the data into another controls like memo or lookup combox, these controls show the data inmediatly. Hello, In general, what request are you performing? How many records do you select? What is the query plan, optimized? Quote Link to comment Share on other sites More sharing options...
Abaksoft Posted May 31, 2021 Share Posted May 31, 2021 7 hours ago, Luis German said: I am using Unitimer that refresh data from a query on a Unidbgrid every 10 seconds. I notice that the refresh operation of the grid goes slow while i open more and more sessions. Loading simultaneolsy the data into another controls like memo or lookup combox, these controls show the data inmediatly. What to do in order to speed up the way Unidbgrid shows the information? Regards Luis Can you try : On your unitimer procedure : MyDataset.DisableControls MyDataset.Refresh MyDataset.EnableControls And on your UniDbgrid : FetchAll = False webOptions > paged = True 25 rows (with devart tools, it's immediatly). Quote Link to comment Share on other sites More sharing options...
Luis German Posted May 31, 2021 Author Share Posted May 31, 2021 18 hours ago, Sherzod said: Hello, In general, what request are you performing? How many records do you select? What is the query plan, optimized? Only max 20 records, No problem with the query, i am testing with a similar VCL applications and run optimized. Quote Link to comment Share on other sites More sharing options...
Luis German Posted May 31, 2021 Author Share Posted May 31, 2021 16 hours ago, Abaksoft said: Can you try : On your unitimer procedure : MyDataset.DisableControls MyDataset.Refresh MyDataset.EnableControls And on your UniDbgrid : FetchAll = False webOptions > paged = True 25 rows (with devart tools, it's immediatly). I changed the settings as you say with no new results. Have you tested with the same application opened 10 times?. Running it once there is no problem. Quote Link to comment Share on other sites More sharing options...
Sherzod Posted June 1, 2021 Share Posted June 1, 2021 On 5/31/2021 at 3:22 AM, Luis German said: I notice that the refresh operation of the grid goes slow while i open more and more sessions. How slow is it? Quote Link to comment Share on other sites More sharing options...
Luis German Posted June 5, 2021 Author Share Posted June 5, 2021 On 6/1/2021 at 12:18 AM, Sherzod said: How slow is it? I notice that the speed goes down when i run the process opening several times in the same browser. And the unitime does not generate the event in the time of frecuency specified. I am testing using an interval of 5 seconds. When the browser is loaded with 10 or more sessions, the grid refresh goes down and the interval time is generated after 5 seconds. Replace unidbgrid by unistringgrid component the unistringgrid refresh inmediatly Quote Link to comment Share on other sites More sharing options...
KingOrmon Posted April 25, 2023 Share Posted April 25, 2023 Hi, Any solution for this ? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.