Re[2]: how to speed up SE and DS

Andre Sorry I got your reply only after I sent in a reply to your previous post. Since you dont have indexes, please ignore my previous post. Is it possible that the priority of your engine (oninit) process is degrading with time? If the hardware supports it, you can set NOAGE to prevent priority ageing. HP-UX also has an O/S command called rtprio - I dont know what it is on Linux. If you could perhaps look at an onstat -p before your program and when it degrades, it could point to other resource bottlenecks. HTH Sujit ______________________________ Reply Separator _________________________________ Subject: Re: how to speed up SE and DS Author: andre.koppel@t-online.de (Andre Koppel) at internet Date: 12/11/1998 11:17 PM > 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. The prepare part itself is not very time-consuming (I have checked this), it's the insert itself. > 2) If possible, DISABLE or DROP the indexes before the INSERT loop and > ENABLE or reCREATE the indexes after the loop. I have done this, there is only the serial column. -- Andre Koppel Software TCP/IP for QNX 2.x GPIB for QNX4.x at http://www.akso.de and http://www.swd.de