Re: how to speed up SE and DS

> 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