Thread: Better way to load data to table

Better way to load data to table

From
Wenjin Zheng
Date:
Hi;

I have a table that has four fields as float8[].  I have a serial new data
for each array.  Each time I have new data I have to update more than 6000
rows for all four field.  But using "update (ta ble)" to load in the new
data is just too slow.  Does anybody know a more efficient way to update
large data set in an array?

Thanks for help.

Wenjin Zheng, Ph.D.
Bioinformatic Analyst
Large Scale Biology, Corp.
Vacaville, CA 95688
wenjin.zheng@lsbc.com