Hi, Thanks for using MonetDB/SQL. I'm not too familiar with visual basic, but I assume your "(columnnames)" and "(values)" are filled in with actual values by your application. Hence, looking at what you give us, I suspect that you didn't switch off auto-commmit mode. Doing so will improve performance (sometimes dramatically). An even higher speed can be achieved when using an COPY INTO construct, but this is harder to deal with from an application environment like you seem to be in. Regards On 26-10-2006 09:26:15 +0200, baane@web.de wrote:
Hi,
I am using Microsoft ActiveX Dataobject (ADO) to write my records to the MonetDB database. I am inserting records row by row (running it out of VB environment):
set cnnMONETDB = new ADODB.Connection
for i = 0 to rownum
createsql = "INSERT INTO tablename (columnnames) VALUES (values);"
cnnMONETDB.Execute createsql
next i
It takes me about 5min to insert 100000 rows into the database, which is too slow for my purpose. Is there any way to speed this up? I was reading that monetdb can update 100000r records per second. i must be doing something wrong then :(
Thanks and regards