hls1
asked on
Frequently queried table
Hi all. I have several SQL tables queried frequently. Can I do anything to store them in memory, not on my hard disk? This slows me down greatly.
Yeap, I’m interested too. I use tables to store preferences in most of my projects. RAM forever! :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AFAIK many DMS optimize most popular queries.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
AbsDB does it better, I’ve checked. More than +150% in performance.
How do I implement In-memory table?
https://www.experts-exchange.com/questions/20068246/How-do-I-implement-In-memory-table.html?query=memory+tables&searchType=topic
Search on the Delphi Super Page (http://delphi.icm.edu.pl/ or the mirror http://sunsite.informatik.rwth-aachen.de/delphi/) for the Memory table component. I believe there's a MemoryTable component there. I just can't find it now... (But I'll keep on looking...)
There's a way to implement your own version, btw, but it requires the BDE and knowledge of the BDE API. Or you start at the lowest point: TDataset and create your own TDataset-compatible component. Both are harder than just finding this existing component... ^_^
https://www.experts-exchange.com/questions/20068246/How-do-I-implement-In-memory-table.html?query=memory+tables&searchType=topic
Search on the Delphi Super Page (http://delphi.icm.edu.pl/ or the mirror http://sunsite.informatik.rwth-aachen.de/delphi/) for the Memory table component. I believe there's a MemoryTable component there. I just can't find it now... (But I'll keep on looking...)
There's a way to implement your own version, btw, but it requires the BDE and knowledge of the BDE API. Or you start at the lowest point: TDataset and create your own TDataset-compatible component. Both are harder than just finding this existing component... ^_^