Speed problem when saving data to access using LabSQL

[Wakeguy]

I have an application that needs to save data to an access database. I'm using LabSQL by Jeffrey Travis and it works fine except that the data-saving process is rater slow. I'm saving one value at a time using SQL command INSERT INTO table(col1) VALUES('value'); when I have an array of 100 values that needs to be saved it takes about 20s and that is too long.
Any idea on how to speed up the saving process?

[Tony O.]

Hi,

Depending on how your program looks it might be possible to speed it up. Make sure that only the neccessary write to database is inside your loop and keep the initiate and close reference to the database outside. If you post your VI I might be able to check it for you.

Regards

Tony O.
Applications Engineer, National Instruments