AnsweredAssumed Answered

Store array in database

Question asked by ajka on Jun 25, 2012
Latest reply on Jul 10, 2012 by gojoh

I'm completely new to the Vee software. What I'm trying to do at the moment is:
- store data from the testing instrument to an array
- store all the information in the database.

The first part doesn't cause any problems, it works fast and I'm quite happy with it. It slows down dramatically in the second part though. At the moment my program loops through the rows (it's 9 columns by 200 entries, on average), gets each value from the column by using getValues() and then feeds them in to the database.

The computer I'm working on is quite old and slow, but it takes up to 50 seconds to process 200 entries...! Should I use a different data type than an array, or maybe there is a more efficient way of mapping a 2-d array to a database?

I hope I can get some help here. 

I just attached a picture with the part of the program in which I'm adding stuff to the database. If you spot anything that I could improve, I'd be very grateful!

Edited by: ajka on Jun 25, 2012 6:29 AM