Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 29 Mar 2024, 13:44

All times are UTC




Post new topic Reply to topic  [ 8 posts ] 
Author Message
 Post subject: OptimizeWidth is slow
PostPosted: 04 Aug 2021, 05:50 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Hi,
I use OptimizeAllColsWidth for 9700 Records.
The required time is about 11 seconds.
Is there a way to do it faster?


Top
 Profile  
 
PostPosted: 05 Aug 2021, 18:15 
Offline

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

We tested TDBGridEh.OptimizeAllColsWidth in <EhLib Demos>\MainDemo\Project1.dpr \ Working With Huge Data page (TfrWorkingWithHugeData Frame).
MemTableEh - 10000 Records x 18 Columns.
The OptimizeAllColsWidth operation takes less than a second.

The speed of the function can also be influenced by the TDataSet type or other environment.
To understand exactly the reason for the slow work, we need to reproduce as accurate as possible the environment of the DBGridEh, such as DateSet, no waiting for download from the server, etc.

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 07 Aug 2021, 06:42 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Hi,
I checked your sample with 3 different pcs, min time was about 23 Second for OptimizeAllColsWidth


Top
 Profile  
 
PostPosted: 07 Aug 2021, 09:51 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Function speed may vary depending on:
- EhLib version
- Windows version
- Delphi version
- Processor

I tested under:
- EhLib 10.1
- Windows 10
- Delphi XE 10.4
- Core i7-9700K

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 07 Aug 2021, 13:01 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
Can you send me the executable file of the program?


Top
 Profile  
 
PostPosted: 10 Aug 2021, 23:36 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Here is a link to the compiled file.

https://disk.yandex.ru/d/4DSIN5ZdMR57YA

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 13 Aug 2021, 06:20 
Offline

Joined: 31 Aug 2018, 19:06
Posts: 92
plz check Attachment


Attachments:
Sample1.png
Sample1.png [ 66.2 KiB | Viewed 991 times ]
Sample.png
Sample.png [ 8.55 KiB | Viewed 991 times ]
Top
 Profile  
 
PostPosted: 13 Aug 2021, 18:54 
Offline

Joined: 08 May 2014, 18:06
Posts: 660
Approximately 10,000 records per second.
In my opinion, a good result.

_________________
Best regards
EhLib Support Team


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

All times are UTC


Who is online

Users browsing this forum: No registered users and 14 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:  
cron
Powered by phpBB® Forum Software © phpBB Group