| EhLib.Com https://forum.ehlib.com/en/ |
|
| MemTableEh with huge date freeze at CLOSE https://forum.ehlib.com/en/viewtopic.php?f=5&t=1164 |
Page 1 of 1 |
| Author: | blumache [ 26 Jul 2022, 09:30 ] |
| Post subject: | MemTableEh with huge date freeze at CLOSE |
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! |
|
| Author: | EhLibSupport [ 26 Jul 2022, 13:47 ] |
| Post subject: | Re: MemTableEh with huge date freeze at CLOSE |
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 |
|
| Author: | blumache [ 09 Sep 2022, 08:33 ] |
| Post subject: | Re: MemTableEh with huge date freeze at CLOSE |
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... |
|
| Author: | blumache [ 09 Sep 2022, 08:49 ] |
| Post subject: | Re: MemTableEh with huge date freeze at CLOSE |
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? |
|
| Author: | EhLibSupport [ 23 Sep 2022, 21:10 ] |
| Post subject: | Re: MemTableEh with huge date freeze at CLOSE |
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. |
|
| Page 1 of 1 | All times are UTC |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|