Link to home
Start Free TrialLog in
Avatar of hls1
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.
Avatar of ben_afferson
ben_afferson

Yeap, I’m interested too. I use tables to store preferences in most of my projects. RAM forever! :)
ASKER CERTIFIED SOLUTION
Avatar of eagle20001
eagle20001

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
AFAIK many DMS optimize most popular queries.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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... ^_^