Re: how to speed up SE and DS

Andre Two things immediately come to mind to speed up the inserts: 1) PREPARE your INSERT statement outside the while or for loop you are using to do the INSERT. Within the loop, EXECUTE the INSERT with the data. 2) If possible, DISABLE or DROP the indexes before the INSERT loop and ENABLE or reCREATE the indexes after the loop. HTH Sujit ______________________________ Reply Separator _________________________________ Subject: how to speed up SE and DS Author: andre.koppel@t-online.de (Andre Koppel) at internet Date: 12/11/1998 8:53 AM I have written an application, that manages a great INFORMIX-database with several tables. I am using SE on a LINUX PII/400 for development, the production-computer is a SUN Enterprise 450 with INFORMIX-DS installed. This is my first application written in ESQL/C. I have found, that inserting a row into a table, that contains more than 10000 rows is very slow (on both SE and DS). Are there any genreral hints or a FAQ how to speed up the insertion? Some usefull hints are very appreciated. Regards Andre