Re: The PUT Command is better than EXECUTE Insert?
Posted in 1995
Edwin Babadaglian — — source: Informix-list mailing list archive (1991-1998)
In <266676110wnr@bash.demon.co.uk> Bashir Akram <bash@bash.demon.co.uk> writes: >When a program needs to do hundreds of inserts into a table, rather than >Executing an Insert Cursor, it is better to use PUT. >(from a performance point of view?) Using PUT may yield better results depending on the size of the rows. PUT places rows in a buffer for later insertion. At the point of a FLUSH, CLOSE, or full buffer, the rows are written as a block. The buffer size is fixed and system-dependent. The more rows that fit in the buffer, the better the performance. For example, if the block size is 1024 bytes and the row size is 64 bytes, 16 rows can be written to storage at at time. Edwin Babadaglian edwinb@panix.com