Thanks for the answer. I have tried to switch off autocommit within ADO but it gives me an error message when i try to commit a command. Can it be that it does not support it through ADO? regards *Von:* monetdb-users@lists.sourceforge.net *Gesendet:* 26.10.06 09:31:09 *An:* monetdb-users@lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO 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

------------------------------------------------------------------------- Using Tomcat but need to do more? Need to support web services, security? Get stuff done quickly with pre-integrated technology to make your job easier Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen! *http://smartsurfer.web.de/?mc=100071&distributionid=000000000066* [http://smartsurfer.web.de/?mc=100071&distributionid=000000000066]