Data Retrieval speed from DIAdem Database using Data Finder Toolkit in LabVIEW

[Alagar Anand]

I have developed a LabVIEW code using NI Data Finder toolkit for extracting the data from the DIAdem. I have formed queries for extraction the data. But the data retrieval takes more time for extracting the data.

I have attached my LabVIEW code image along with this post. In that i have circled the VI "Results to Waveform", which is Data Finder toolkit VI which takes more time for extraction. From my Testing, query formation is taking only few millisecond to execute, but "Results to Waveform.vi" takes around 35 seconds. Also i want to execute similar kind of search for 5 times. Altogether it will taken around 1.5 mins to 2 mins for execution.

Is there any other alternative way of doing this search? Kindly help me in sorting this out.

Thanks,

Alagar 

[Alagar Anand]

please find the attached image of the LabVIEW code. I have added some documentation to the VI.

Thanks,

Alagar

[Brad_Turpin]

Hi Alagar,

You say that the "Results to Waveform.vi" takes "more" time, but what are you comparing this to?  More than what?  More than loading the contents of the same file with the TDMS VIs or with the Storage VIs?  What file format are you loading data from after querying-- TDMS files, ASCII files, binary files?

What information do you want to retrieve?  Do you really need ALL the values of ALL the channels in each data file?  Are you interested only in the channel values, or all you interested in scalar properties stored along with the data?  If you want only some of the channels loaded or if you want only scalar properties loaded, there are indeed faster ways of doing this.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Alagar Anand]

Hi Brad Turpin,

I am trying to retrieve the data from the TDMS Files. I want to extract the all the channel data from each Channel Group(here it is files).

The array which i am trying to extarct will be of size 31 X 20.

I have done same kind of analysis in DIAdem Interface, but it has taken only few seconds to done the processing. But now in LabVIEW it is taking more time to extract the data.

Thanks,

Alagar

[EvaW · Accepted solution]

Hi Alagar,

if you want to extract all the channel data from each channel group you could use channel group as result object type for the Execute Query.vi instead of channel.

When loading the channels via its channel groups the contained channels are treated as unit and the loading process should be faster. Hope that helps.

Regards,
Eva

[Brad_Turpin]

Hi Alagar,

That sounds REALLY slow.  Are you able to post one of these TDMS files or email it to me at brad.turpin@ni.com?  Either something is wrond with those TDMS files or you're using a really slow computer.

Brad Turpin

DIAdem Product Support Engineer
National Instruments

[Alagar Anand]

Hi Eva,

Like you said, with having selected the output files as channel Group, it ran very faster with in a few seconds. My problem got solved. Thanks....

Hi Brad Turpin,

Thanks for ur help, and my problem got solved with Eva suggestion.

Thanks,

Alagar