I´m using LabVIEW 8.0 and Database Connectivity Toolkit to store data from a 2D array in an Oracle Database.
This is the structure I programmed to store data :
1) DB Tools Open Connectivity
2) Within a while loop, in each iteration I index each of the XY values that I convert to Decimal String together with the number of iteration and a constant. Thus, I store four values. I concatenate these four values to get the SQL statement "insert into my_table (ID_TEST, KONSTANT,FORCE, STRAIN) values(" that I connect to the DB Tools Execute Query.vi and this to DB Tools Free Object.vi.
3) When all the array has been read, the while loop ends and finally (outside the while loop) I close the database with the DB Tools Close Connection.vi
With the above procedure I can store the data in the Oracle table without any problem. However, to store 2 000 points (four values, columns) it takes some 3 minutes.
Does anyone knows of a faster way to store the data in the Oracle table?
Thanks
Simbani