Re: Help ! How to improve performance of a insert statement

> 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 ;)