[Monetdb-developers] monentdb autocommit

Sjoerd Mullender sjoerd at acm.org
Mon Sep 7 17:29:08 CEST 2009


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 at 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 at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers


-- 
Sjoerd Mullender

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 369 bytes
Desc: OpenPGP digital signature
URL: <http://www.monetdb.org/pipermail/developers-list/attachments/20090907/a9e2ef27/attachment.sig>


More information about the developers-list mailing list