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.
hls1Asked:
Who is Participating?
 
eagle20001Commented:
The answer is simple – www.componentAce.com with their great product aka Absolute Database. The guys have developed something cool, I tell you. You’ll never regret that you work with it!
0
 
ben_affersonCommented:
Yeap, I’m interested too. I use tables to store preferences in most of my projects. RAM forever! :)
0
 
mrnov1Commented:
AFAIK many DMS optimize most popular queries.
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
shaneholmesCommented:
Borland has an example of implementing in-memory tables:

http://info.borland.com/devsupport/bde/delphifiles.html

In-Memory table example with source (Updated 02/17/98, Size 230,760 bytes)

In-Memory table example with source (Package Version) (Size 15,422 bytes)

In-Memory table example with source (Packaged EXE) (Size 22,528 bytes)
This examples takes a table, places all the information into an in-memory table, and then displays all the information in a string grid.

Hope this helps!

Shane
0
 
eagle20001Commented:
AbsDB does it better, I’ve checked. More than +150% in performance.
0
 
shaneholmesCommented:
How do I implement In-memory table?

http://www.experts-exchange.com/Programming/Programming_Languages/Delphi/Q_20068246.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... ^_^
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.