The answer to your question is difficult to quantify. As noted by Fabian already, it depends on the application semantics and the bridge between application and server. The fastest way to load a table uses a COPY INTO scheme from SQL, preferrably without referential constraints and transaction logging. If you load tuples into a database one-by-one through a ODBC/JDBC bridge, the cost you will encounter is predominantly determined by the protocol and interprocess communication scheme. You may have a look at the C't magazine article of last year to have an impression how database systems work in this setting. http://www.heise.de/ct/inhverz/search.shtml?T=monetdb&Suchen=suchen baane@web.de wrote:

yes, ADO is an object model that connects through ODBC. Via ADO, autocommit is turned off by default and each SQL statement has to be embedded in following code:

ADOConnObj.BeginTrans

ADOConnObj.Execute sqlstatement

ADOConnObj.CommitTrans

can you tell me what programming platform is best supported by MonetDB in order to avoid these problems and be able to write data quick to the database.

Can you as well tell me how many records per second can be written into and read from MonetDB (if everything is done correctly;))

regards

------------------------------------------------------------------------ *Von:* monetdb-users@lists.sourceforge.net *Gesendet:* 26.1 0.06 10:41:04 *An:* monetdb-users@lists.sourceforge.net *Betreff:* Re: [MonetDB-users] writing to MonetDB via ADO

On 26-10-2006 10:37:37 +0200, Branislav Djokovic wrote:

...

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?

I am not aware that we have an ADO driver. Does it work through the ODBC driver? If so, I would expect auto-commit flagging to work. How did you switch auto-commit off? Maybe the ODBC driver doesn't support it (yet).

------------------------------------------------------------------------- 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

XXL-Speicher, PC-Virenschutz, Spartarife & mehr: Nur im WEB.DE Club! Jetzt gratis testen! *http://freemail.web.de/home/landingpad/?mc=021130*

------------------------------------------------------------------------

------------------------------------------------------------------------- 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