Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 28 Mar 2024, 19:41

All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 26 Jul 2022, 09:30 
Offline

Joined: 31 Jan 2013, 13:05
Posts: 17
Hi. I tried a MemTableEh table, load from a query with more 100.000 records. Time of loading...very slow.
I displayed the data in a EhGrid
When i try to close the form...freeze....after 2 minutes!!! escape from FormClose and another surprise form->Free anothe 2 minutes!!!

Please explained...please solution to speed up a Memtable Close with a lot of data!


Top
 Profile  
 
PostPosted: 26 Jul 2022, 13:47 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

To understand the cause of the error, we need to simulate a similar situation on our computer.
Try to make a simple demo project with one grid and MemTableEh.

To get data for a Demo project, use the TMemTableEh.SaveToFile method in Your project to save the data to a file.
Then, in the Demo project, use the TMemTableEh.LoadFromFile method to load the data from the file.
Check that the problem is reproduced in the Demo project.
Send Demo project to support@ehlib.com

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 09 Sep 2022, 08:33 
Offline

Joined: 31 Jan 2013, 13:05
Posts: 17
blumache wrote:
Hi. I tried a MemTableEh table, load from a query with more 100.000 records. Time of loading...very slow.
I displayed the data in a EhGrid
When i try to close the form...freeze....after 2 minutes!!! escape from FormClose and another surprise form->Free anothe 2 minutes!!!
Please explained...please solution to speed up a Memtable Close with a lot of data!



The problems appear when i insert a line for footer grouping...grid.DataGrouping.Footers[0]. When i try to close the form...freeze....2 minutes!!!

Delete this grouping before close the form...0.3s

Solutions?

PS. All the functions in the grid word very slow at 100000+ records. Sort, Filtering...


Top
 Profile  
 
PostPosted: 09 Sep 2022, 08:49 
Offline

Joined: 31 Jan 2013, 13:05
Posts: 17
blumache wrote:
blumache wrote:
Hi. I tried a MemTableEh table, load from a query with more 100.000 records. Time of loading...very slow.
I displayed the data in a EhGrid
When i try to close the form...freeze....after 2 minutes!!! escape from FormClose and another surprise form->Free anothe 2 minutes!!!
Please explained...please solution to speed up a Memtable Close with a lot of data!



The problems appear when i insert a line for footer grouping...grid.DataGrouping.Footers[0]. When i try to close the form...freeze....2 minutes!!!

Delete this grouping before close the form...0.3s

Solutions?

PS1. All the functions in the grid word very slow at 100000+ records. Sort, Filtering...

PS2. I test your EHLIB 9.0.040 in RAD STUDIO C++. If a compile and execute my demo project, and execute from RADS, the form...freeze....after 2 minutes!!! (With the grouping delete before close). But if i exectute exe directly from Windows, this problem not appear! Close instantly...Ideas?


Top
 Profile  
 
PostPosted: 23 Sep 2022, 21:10 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Hello

In older versions of RAD Studio (Before RAD Studio XE), running the application in debug mode caused it to run very slow.
Especially the operations of creating and deleting objects.
In the latest versions of RAD Studio, this is no longer so noticeable.
But the end users of the application will not work with the application in debug mode. So this should not affect the productive operation of the application.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 12 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group