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