Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Clem Akins — — source: Informix-list mailing list archive (1991-1998)
> What are the ways we can improve performance of an insert statement.
>Any pointers is appreciated.
Use an insert cursor.
RTFM Informix Guide to SQL: Syntax
RTFM Informix Guide to SQL: Tutorial
Insert many rows per transaction.
RTFM Informix Guide to SQL: Syntax
Drop the indexes that are updated upon insert.
(Three or four I/O's per index!)
RTFM Informix Performance Guide
Split wide tables.
RTFM Informix Performance Guide
Use fragmentation.
RTFM Informix Performance Guide
Are we seeing a pattern here? The docs provide a host of
ways to speed inserts, (this is just the tip of the iceberg!)
and the c.d.i. archives probably provide even more.
One thing you might not find in TFM include:
Hire an OLTP consultant.
______________________________________________________
Clem Akins (aka clema@informix.com)
Informix Software, Inc (Standard disclaimers apply)
International Technical Support
Last seen: In a Beijing "Ballad Bar" brinking beer ;)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.