Re: Group inserts/retrievals for performance ??

Posted in 1993

Alan Popiel — Fri, 27 Aug 93 15:47:44 MDT — source: Informix-list mailing list archive (1991-1998)

->From: chanm@hpsgm2.sgp.hp.com (Michael CHAN) ->Subject: Group inserts/retrievals for performance ?? ->Date: Fri, 27 Aug 1993 18:18:07 GMT ->Reply-To: chanm@hpsgm2.sgp.hp.com (Michael CHAN) ->Organization: HP Singapore Notes-Server -> -> Hello, -> -> We have information in Unix files that contain customer records. We like to -> transfer these records into the database, but cannot afford to transfer -> record by record (too slow for us). We like to transfer them chunk by chunk -> ( a chunk will be a number of records in the unix file) into the database. -> -> We heard of a thing called "group inserts", but don't know how/whether this is -> supported in Informix. -> -> How does the feature "quick loader" fits in here ? -> -> Also, is there an equivalent thing for "group retrievals" (after the records -> are inserted into Informix, retrieve them in bulk for processing). -> -> What is the performance improvement (in general) when using these as opposed -> to individual records insertion or retrieval ?? -> -> Any help is greatly appreciated. -> Michael C Look at your documentation for DBLOAD, which is Informix's bulk load utility, or "quick loader". This utility will probably do what you want for input. I am not familiar with the "group insert" terminology, so I can't help you with that one. Perhaps you mean how many inserts to COMMIT at one time? If that is what you mean, then DBLOAD has a parameter to adjust the number of row COMITted at one time. "Group retrieval" sounds like a CURSOR in 4GL or ESQL/C, or the standard mode of processing in ISQL. Otherwise, I am not sure what you mean by this. Regards, Alan +---------------------------+--------------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, Tech Ops | Voice: 303-977-9998 | | P.O. Box 179, M/S 5422 | My opinions may not reflect Martin policy. | | Denver, CO 80201-0179 USA | In fact, we often disagree. | +---------------------------+--------------------------------------------+