Subject | TIBOQuery : Filtering records without refreshing |
---|---|
Author | scr0546 |
Post date | 2008-11-26T00:38:24Z |
Hello,
I'm working with TIBOQuery and want to filter the records locally at
clientside without refreshing the dataset from server.
When using the filter-property of the dataset the data are always
reloaded from server when the filter-condition changes.
How can I filter records at clientside with TIBOQuery?
The main performance-problem is when I set Filter:='' or
Filtered:=false, because all records will be refreshed.
For example:
1. FetchAll from server (about 30.000 customerrecords)
This happens at startup.
2. Filtering/Searching at clientside (like "name containing 'xyz'")
3. It's not important to refresh the dataset all the time when the
filtercondition changes or when I clear the filter to see all
records again.
Thanks for help
Joe
I'm working with TIBOQuery and want to filter the records locally at
clientside without refreshing the dataset from server.
When using the filter-property of the dataset the data are always
reloaded from server when the filter-condition changes.
How can I filter records at clientside with TIBOQuery?
The main performance-problem is when I set Filter:='' or
Filtered:=false, because all records will be refreshed.
For example:
1. FetchAll from server (about 30.000 customerrecords)
This happens at startup.
2. Filtering/Searching at clientside (like "name containing 'xyz'")
3. It's not important to refresh the dataset all the time when the
filtercondition changes or when I clear the filter to see all
records again.
Thanks for help
Joe