Steve,

Does Informix have a BCP (bulk copy) utility? If so that will be the fastest way to get the data into the server. Convert your data to plain text files and then use BCP to load that file into a table. BCP works at thousands to 10s of thousands of rows per second depending on how wide the table is.

>I am using VFP views to convert data into an Informix database. The conversion is currently taking about 30 hours (mucho data) to upload. Can anyone tell me if I can expect a performance increase if I create a unique connection for each view (30) vrs all 30 views sharing a single connection?