The VIs "DB Tools Fetch Recordset Data.vi" and "DB Tool Select Data.vi" of theDatabase Connectivity Toolset have the great disadvantage that they are very,very slow.National Instrument is aware of this problem and writes in the KnowledgeBasedocument ID 28IDHE52 with the title "Why Is the Database Toolset Slow inReturning Table Data?": (you can find this article under www.ni.com/support):If you still wish to return the entire contents from a large table at once,you can use the methods from the example named Read All Data from theLabVIEW > Examples > database > DatabaseEx.llb. The subVIs used in thisexample were written to use the least number of resources and return thedata as a 2D array of strings. Although it is very efficient, this method ofreading data is not used elsewhere in the Database Connectivity Toolset,because it has two limitations:1. The data returned in the Read All Data example is in the form of a 2D array of strings...2. The method used in the Read All Data example in unable to interpret NULL values. If any item in the returned recordset contains a NULL, an error is returned and no data is read.This is true, BUT only a slight modification of the "DB Tools Fetch TableData.vi" VI, that is used in the "Read All Data" example, make it possibleto avoid these limitations! After this modification this VI returns the same2D array of database variants as the "DB Tools Fetch Recordset Data.vi" and"DB Tool Select Data.vi", but is much, much faster!!Send me an email and I will email the modified version to everybody who isinterested directly.Robert

LabVIEW

make the DB Connectivity TS much faster!

Hallo Robert,
Thanks vor your Help. Could U send me your Fetch. version?

Message 11 of 16

(1,340 Views)

Thank you, Robert. I would like to have a copy as well.

-Joe

Message 12 of 16

(1,340 Views)

hmm, haven't received the files yet. Maybe I forgot attach my email, here it is: jyguo@roushind.com

Thanks again.

-Joe

Message 13 of 16

(1,340 Views)

Hi Robert,

Is it possible to have a copy of the modified version?

Thanks,

Nathalie

Mail : technique@medinorme.com

Message 14 of 16

(1,322 Views)

Hi Robert,

Could you send me a copy of this please

Best regards,

Mark

mark.morrissey@finisar.com

Message 15 of 16

(1,120 Views)

Hi Robert,

If you are still there can I get a copy as well?

Best regards

Jacob Svendsen

jsvendsen@grundfos.com

Message 16 of 16

(985 Views)

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product

How can we help?

Please enter your information below and we'll be intouch soon.

This field is required

Preferred communication method

Email Phone call

What do you need our team of experts to assist you with?

Request a quote Find the right product Place an order Get support on a product

LabVIEW

make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!

Re: make the DB Connectivity TS much faster!