Databasa Connectivity Toolset Reading Performance

[OldSmobile]

Hi.
I'm using DCT to read two tables from access db, each containing about
3000 records with about 20 fields.
The reading time, using standard systems, like in examples, like
Connect to DB, Get Table, close connection is more than 5 minutes wit
100% processor time.
After this Huge time amount, it is necessary reprocess the array to
convert it in appropriate LabView data type.
Anyone has some Ideas to survive?

Note: writing is Quicker: more than 100 records per second.

Thanks in advance, OldSmobile

[LBoltzmann]

The following link discusses the read performance of the Database Connectivity in detail and ways to optimize.

http://ae.natinst.com/operations/ae/public.nsf/fca7838c4500dc10862567a100753500/862567530005f0a186256a33006b917a?OpenDocument

[OldSmobile]

On Fri, 25 Jan 2002 09:50:06 -0800 (PST), Jeff M. wrote:


>http://ae.natinst.com/operations/ae/public.nsf/fca7838c4500dc10862567a100753500/862567530005f0a186256a33006b917a?OpenDocument

Thank you!
Unfortunately at present that link seems not been working... I'll try
later, or if you can give me some indication on how to re-find it i'll
not stress you for this 🙂

OldSmobile

[LBoltzmann]

I'm sorry I gave you an internal web link.

Search the Knowledgebase on www.ni.com for KB 28IDHE52.

[OldSmobile]

On Fri, 25 Jan 2002 11:24:47 -0800 (PST), Jeff M. wrote:

>I'm sorry I gave you an internal web link.
>
>Search the Knowledgebase on www.ni.com for KB 28IDHE52.

You are really kind!
I found the solution to slow data reading.
Now I have just to convert from string to the appropriate data type...
but I have a VI that will do it for me! :-))
Thank you again.
OldsSmobile.