Re: help dbload or LOAD which is faster?

Billy Wheeler (billy.wheeler@pixie.co.za) wrote: : At 01:09 AM 3/13/96 -0500, Blubottle wrote: : >I'm going to be load a large amount of data to either Informix SE or : >Online 7.1. I'm concerned about the run time. Is the dbload utility : >faster or slower than SQL LOAD or doesn't it matter. Indexes, if any, : >won't be built until after the load. : Heeheeheehee! Oh, look, he's fallen in the water! I like this game! Ooh, : sausinges! : [Several Prozac later] : If your database is logged, dbload will be faster because you can commit : every N records. If not, SQL LOAD will be faster (allegedly), but it will : fall over on every bad record. FWIW, I always use dbload (unless it's a : trivial amount of data) : HTH. : Hasta la vista! : -- : billy.wheeler@pixie.co.za According the course I took a weeks ago in Informix, the download utility that downloads uploads binary data goes faster. But you can not use the downloaded binary data for data interchange between different version. And also ( if you are using 7.x ), you may increase your speed by turning off the logging and bring it back after. This should save you more than 40% of upload time. Hope this help. Alan. -8<--siumk@hkstar.com-->8- ^ ^ o o > ---- <