[Monetdb-developers] monentdb autocommit
Hi all, I use BenchmarkFactory and ODBC to test the monentdb performance. But it seems the default option of monentdb is autocommit, so some test scripts seems not work. How should i change the autocommit option (not only use "set autocommit 0" and just change it in the range of one transaction )? Does anyone know the details(that'are tools, scripts, monetdb enviroment) of TPC-H test in monentdb website? Many thanks~ Regards Yan
On Mon, Aug 31, 2009 at 09:59:10AM +0800, 颜勋 wrote:
Hi all,
Hello Yan,
I use BenchmarkFactory and ODBC to test the monentdb performance.
Thanks for using MonetDB. We are very insterested in the results of your test.
But it seems the default option of monentdb is autocommit, so some test scripts seems not work. How should i change the autocommit option (not only use "set autocommit 0" and just change it in the range of one transaction )?
autocommit will be automatically turned off, if you add the statement 'begin transaction' at the beginning of your transaction, then the transaction will only be committed if you explicitly use the 'commit' statement. Is this what you want? Regards, Jennie
Does anyone know the details(that'are tools, scripts, monetdb enviroment) of TPC-H test in monentdb website?
Many thanks~
Regards
Yan
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
Ying Zhang wrote:
On Mon, Aug 31, 2009 at 09:59:10AM +0800, 颜勋 wrote:
Hi all,
Hello Yan,
I use BenchmarkFactory and ODBC to test the monentdb performance.
Thanks for using MonetDB. We are very insterested in the results of your test.
But it seems the default option of monentdb is autocommit, so some test scripts seems not work. How should i change the autocommit option (not only use "set autocommit 0" and just change it in the range of one transaction )?
autocommit will be automatically turned off, if you add the statement 'begin transaction' at the beginning of your transaction, then the transaction will only be committed if you explicitly use the 'commit' statement. Is this what you want?
The ODBC way of doing this is to use SQLSetConnectAttr(dbc, SQL_ATTR_AUTOCOMMIT, SQL_AUTOCOMMIT_OFF, 0);
Regards,
Jennie
Does anyone know the details(that'are tools, scripts, monetdb enviroment) of TPC-H test in monentdb website?
Many thanks~
Regards
Yan
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Monetdb-developers mailing list Monetdb-developers@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-developers
-- Sjoerd Mullender
participants (3)
-
Sjoerd Mullender -
Ying Zhang -
颜勋