Fast Database access required

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

David
Mon Oct 25 11:05:17 CDT 2004


"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

James
Mon Oct 25 14:46:25 CDT 2004


"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 ?

David
Mon Oct 25 15:19:03 CDT 2004


"James Jenkins" <James@REMOVETHIS1STtamarsolutions.co.uk> wrote in message
news:uz2RHtsuEHA.2200@TK2MSFTNGP11.phx.gbl...
>
> "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 ?

Yes it will. How much, and wether it is too much, you can test.

David

James
Mon Oct 25 17:41:34 CDT 2004


"David Browne" <davidbaxterbrowne no potted meat@hotmail.com> wrote in
message news:%2325Fg$suEHA.940@TK2MSFTNGP14.phx.gbl...
>
> "James Jenkins" <James@REMOVETHIS1STtamarsolutions.co.uk> wrote in message
> news:uz2RHtsuEHA.2200@TK2MSFTNGP11.phx.gbl...
>>
>> "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 ?
>
> Yes it will. How much, and wether it is too much, you can test.
>
> David
>

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