Re: bulk load

Vic Goldberg wrote: > > Duc Nguyen wrote: > > > > We have Informix Online Dynamic Server V7.13.UC2 running > > on Solaris. Can I do a bulk load (a direct load in > > Oracle7) of an ascii file into Informix? It seems > With 7.13 you're somewhat in a bind. The fastest loads on 7.13 > (according to well, that's relative. it is more than doable, and the sql load statment as well as dbload will work just fine. it is the timing issue. on 7.1X, i used to load 10,000,000 rows and build 8 indexes, some with 5 composite columns, in about 8 hours or so. certainly not wonderful, but it was workable for us. > If you can upgrade to 7.2, you have access to the bulk loader. It'll i have heard wonders about the damn thing, but haven't had the pleasure as of yet...:-) mickm