Clientside Locate, Indexes, Speed, Locate Options
Posted: Thu 21 Apr 2016 07:31
Hi,
we have some bigger Clientside DataSets, that hold cached informations, for example FieldStructures and so on. The DataSet can be lets say 20.000 Records.
The Problem is that the Locate Speed is very very slow and so we are looking for a way how to speed up this. It seems there is no option to use Local Indexes for speeding up Locate? Locate calls can be up to 3000 on a Form Creation and it takes nearly one second.
Out current solution is to use a TDictionary and Save the locate Keys and there corresponding RecNo. If the Key is Searched a 2nd one the TDictionary will give back the Recno and so its fast.
Perhaps there is another Solution how to speed up locate?
Daniel.
we have some bigger Clientside DataSets, that hold cached informations, for example FieldStructures and so on. The DataSet can be lets say 20.000 Records.
The Problem is that the Locate Speed is very very slow and so we are looking for a way how to speed up this. It seems there is no option to use Local Indexes for speeding up Locate? Locate calls can be up to 3000 on a Form Creation and it takes nearly one second.
Out current solution is to use a TDictionary and Save the locate Keys and there corresponding RecNo. If the Key is Searched a 2nd one the TDictionary will give back the Recno and so its fast.
Perhaps there is another Solution how to speed up locate?
Code: Select all
CacheGridFilter.Locate('il_group;il_item;gf_minr;gf_default;gf_deleted',
[ClassName, GridFilterSaveName(GridView), NULL, True, False])