Hi
All.
I have a wee project
that I am working on again after a few years of not developing it any futher,
and one of the things it does is get some info froma com or lpt port and
then gets some info then searchs a database for the refernece this number
means.
In one case it only
looks at one DB, and in another, in 2 databases -via a join.
Since the DBs are
only 33kb, 124kb and 98kb, I thought that I might load the data into memory
tables.(this is a DBISAM
DB BTW)
The problem is, I am not sure if I will be getting any
real benifit from this. The data can be looked up quite requently, i.e.
maybe up to 10 or even 20 times a min even more in some cases, but I figure that
this is what a mem table woudl be good for.
Am I right to use this approch? or sould I just leave
it accessing the DBs. on the HD?
Cheers,
Jeremy
Coulter
------------------------------------------------------------------------
All email scanned with Nortons Antivirus
2003
------------------------------------------------------------------------
