Read an array and save the data to a table

[Lina Manjarres]

I have a very large table to be updated from an array. The array takes 3 sec
to be filled from a Tlist GRID, but saving the data from the array to the
table takes 50 sec, which is too much. Is there a way to do this faster?

What I am doing is 2 loops to go throu the array, updating row by row in the
table.

I have tryed to make a temporary table, but I couldn't do it.

I also, save the data to a table instead the array, which takes longer to be
filled, but the update process is really fast.

If someone knows a better idea of working this speed problem, please let me
know!!

Thanks alot, Lina

 

[Alex Dybenko]

Hi,
perhaps you can first fill a temp table without indexes, just using addnew,
and then copy data to your table using insert or update query

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[Lina Manjarres]

Thanks a lot! It did work this way and saves me lots of time!!