Fast Database access required

  • Thread starter Thread starter James Jenkins
  • Start date Start date
J

James Jenkins

Hi - I have a very large database (65535 entries) and need to call this
database as often as every 100ms - Oledb and Access use WAY tomuch CPU and I
needsomeadviceon how toimplement a VERY fast data access system - is it
quicker to use a text file? - or isit better to use xml?- any help much
appreciated

#JJ
 
James Jenkins said:
Hi - I have a very large database (65535 entries)
Click to expand...

No, you have a very small database.
and need to call this database as often as every 100ms - Oledb and Access
use WAY tomuch CPU and I needsomeadviceon how toimplement a VERY fast data
access system - is it quicker to use a text file? - or isit better to use
xml?- any help much appreciated
Click to expand...

Can you just load the data into a DataSet and use it in memory. That's
fast.

David
 
David Browne said:
No, you have a very small database.


Can you just load the data into a DataSet and use it in memory. That's
fast.

David
Click to expand...

I'll do that but wont that hoglots of memory ?
 
David Browne said:
Yes it will. How much, and wether it is too much, you can test.

David
Click to expand...

Thanks - I think that I could cope with the mem usage over cpu usage - I
believe the Dataset is probable best option - thanks for your help
 
Back
Top