Re: Fast Database access required

From: James Jenkins (James_at_REMOVETHIS1STtamarsolutions.co.uk)
Date: 10/25/04


Date: Mon, 25 Oct 2004 20:46:25 +0100


"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:O$KptxquEHA.2724@TK2MSFTNGP12.phx.gbl...
>
> "James Jenkins" <James@REMOVETHIS1STtamarsolutions.co.uk> wrote in message
> news:%23Yq6g0puEHA.2196@TK2MSFTNGP14.phx.gbl...
>> Hi - I have a very large database (65535 entries)
>
> 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
>>
>
> Can you just load the data into a DataSet and use it in memory. That's
> fast.
>
> David
>

I'll do that but wont that hoglots of memory ?