Insert 2D array into database

[totally_wired]

I am trying to insert a 2D array of data into a MySQL database after a trial is run. I have read that LabVIEW's Database Insert VI does not support any more than the insertion of 1D arrays at a time. While it might be possible for me to insert the values all individually using a for loop to format the values before entering them, this is far from ideal since there will be 600+ rows of data coming from each trial. I would rather get on to the next run rather than wait for a minute and a half while the Insert VI does its job. Any ideas on how to quickly insert large 2D arrays into the database?

I would post an example of my code, but it's such a mess right now I am embarrassed to show it . Thanks!

[smercurio_fc]

MySQL support an INSERT statement that inserts multiple rows, as noted here. However, since the Database Insert VI doesn't support this you will need to code this up yourself. I'm guessing you're using the Database Connectivity Toolkit. I don't have the Database Connectivity Toolkit, but ff there's a VI in there that will let you create your own INSERT statement then you could do it. There may be one that allows you to specify a command. In that case, the command would be the INSERT statement. I know you can create your own command with LabSQL.

[mikeporter]

What form do you want the 2D array to be in, a number of separate records, or a single BLOB containing the entire array in binary?

Mike...

[mikeporter]

A follow up on my earlier post...  Check out this thread for a discussion of the issues related to connecting to a database - also a set of good ADO-based drivers.

Mike...

[totally_wired]

Thanks Mike, those VIs look pretty good. I will give them a shot. To answer your previous question, I want each row of the 2D array to be entered as a separate entry into the table. Any tips on how to do this with your VIs? Thanks.

[totally_wired]

Just to clarify, I know I can format the values into a text file then dump that into the database, but I am trying to simplify the process so that I won't have to backtrack and micromanage my code so much if I ever have to modify the database. I was doing this before, and it worked great, but the setup process of making sure the text formatted itself correctly was so cumbersome that I am looking for other methods.

[mikeporter]

The easiest thing to do would be to index through the array inserting each row as a separate BLOB in binary form. This is easy to do, takes up the least amount of storage space, preserves all the data's numeric precision and is easy to read from other applications or programming languages...

Mike...