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 >> [email protected] >> 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 > [email protected] > https://lists.sourceforge.net/lists/listinfo/monetdb-developers -- Sjoerd Mullender
signature.asc
Description: OpenPGP digital signature
------------------------------------------------------------------------------ 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
