Thread: Store array in database


Permlink Replies: 1 - Pages: 1 - Last Post: Jul 10, 2012 3:08 PM Last Post By: gojoh
ajka

Posts: 1
Registered: 06/25/12
Store array in database
Posted: Jun 25, 2012 4:32 AM
Click to report abuse...   Click to reply to this thread Reply
Attachment vee.PNG (99.9 KB)
Hi,

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.
Regards,
Justyna

***
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
gojoh


Posts: 64
Registered: 08/07/09
Re: Store array in database
Posted: Jul 10, 2012 3:08 PM   in response to: ajka in response to: ajka
Click to report abuse...   Click to reply to this thread Reply
Not sure what is going on in the minimized objects but shouldnt the 'Make the changes stick' object be outside of the loop?

Point your RSS reader here for a feed of the latest messages in all forums