I am using a loop to insert around 300 records into a database table. The sql insert statement is not complex.
insert into records (custid, formname, formID) values (1,"form",2) Where custid is updated in each loop. I am wrapping the whole loop in a transaction and committing after the loop is complete. Problem is it seems to be slow. It takes around 3 seconds to add the records. Not that long but when you are staring at an hourglass it seems to take longer than expected. Is there anything I can do to speed the process. ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys-and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Firebird-net-provider mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
