Better way to load data to table

Started by Wenjin Zhengover 25 years ago1 messages
#1Wenjin Zheng
wenjin.zheng@lsbc.com

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