labsql fetch data so slow...

[aris]

I use access to store the data and labsql to fetch the data,the data is about 18,000 rows,it takes more than 20s to load the data to labview table,but by access it only take less than 2s to load the data.How can I fetch the data more quickly,my program is as below.


fetch data1.jpg:
http://forums.ni.com/attachments/ni/170/337406/1/fetch data1.jpg

[Benoit]

Can you give the same details about your sub VI SQL execute.vi?
The problem is in the fetch data I'm sure.
If you use the fetch data In the VI palet tools, it's not the good one for a fetch all. Look in the example of labview. their is one that fetch all data much faster.
 
B.

[smercurio_fc]

Benoit, those VIs are part of <a href="http://jeffreytravis.com/lost/labsql.html" target="_blank">LabSQL</a>. To poster: When you say "but by access it only take less than 2s to load the data" are you referring to looking at the data in Access itself? If so, this is comparing apples to oranges, and is meaningless. LabSQL uses ADO, and Acces is a file-based "database" (I use the term loosely since it's Access). So, it's not too surprising that it may be slow. Keep in mind that there are other factors involved, such as hard disk speed, and memory. 18000 rows is a fair bit. When I tried to get 18000 rows from SQL Server it took about 7 seconds.