Components for Delphi and C++ Builder.

Go to Russian forum
Go to EhLib.com
It is currently 29 Mar 2024, 12:53

All times are UTC




Post new topic Reply to topic  [ 5 posts ] 
Author Message
PostPosted: 17 Sep 2019, 02:57 
Offline

Joined: 19 Jan 2012, 20:54
Posts: 12
Hi,

Have it any way to speed up the search in memtableEh?
Can I build a Index?


Top
 Profile  
 
PostPosted: 20 Sep 2019, 01:29 
Offline

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

It depends on what methods you use.
The TMemTableEh.Locate method uses indexes if Options: TLocateOptions = [].

_________________
Best regards
EhLib Support Team


Top
 Profile  
 
PostPosted: 26 Sep 2019, 04:05 
Offline

Joined: 19 Jan 2012, 20:54
Posts: 12
Yes, I use TMemTableEh.Locate.
Should I build a index by code or it should be builded automatically with data append?


Top
 Profile  
 
PostPosted: 30 Sep 2019, 17:54 
Offline

Joined: 19 Jan 2012, 20:54
Posts: 12
1) Will Index use for Filter operation?
2) Will Index use for case when I'm looking through 3 fields like MemTable.Locate('x,y,z', ..., []) but only first 2 columns in Index (x, y) ?


Top
 Profile  
 
PostPosted: 30 Sep 2019, 22:57 
Offline

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

Use IndexDefs collection to create Index Definitions before you open MemTableEh.
The indexes will be created on DataSet.Open.


Quote:
1) Will Index use for Filter operation?

No.

Quote:
2) Will Index use for case when I'm looking through 3 fields like MemTable.Locate('x,y,z', ..., []) but only first 2 columns in Index (x, y) ?

No.
Only in simple cases when the fields in the list match completely.

_________________
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:  
cron
Powered by phpBB® Forum Software © phpBB Group