Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-10 Thread Tim Chou
Hi adrian, Thanks for your help. I think I know why the performance is not good. I misunderstand the document. So in my test, there are thinking time and keying time for each transaction. When I remove the thinking time and keying time, the performance become 1500 new order txns/mins. Your perfo

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-09 Thread Adrian Klaver
On 11/08/2015 07:40 PM, Tim Chou wrote: Hi Adrian, Thank you all the time. I also realized that DBT2 has some bugs. Actually, I have sent an email to DBT2's mailing list. However, no one responded me. The latency of a txn is not high in my test. But the number of txns processed in one minute are

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-08 Thread Adrian Klaver
On 11/08/2015 07:40 PM, Tim Chou wrote: Hi Adrian, Thank you all the time. I also realized that DBT2 has some bugs. Actually, I have sent an email to DBT2's mailing list. However, no one responded me. The latency of a txn is not high in my test. But the number of txns processed in one minute are

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-08 Thread Tim Chou
Hi Adrian, Thank you all the time. I also realized that DBT2 has some bugs. Actually, I have sent an email to DBT2's mailing list. However, no one responded me. The latency of a txn is not high in my test. But the number of txns processed in one minute are not high. Thank you. Best. Tim 2015-11

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-08 Thread Adrian Klaver
On 11/08/2015 04:50 PM, Tim Chou wrote: Really CCing list this time. Hi Adrian, Thank you for your reply. I use git to clone the repository (git clone http://git.code.sf.net/p/osdldbt/dbt2 osdldbt-dbt2). DBT2's website I used is http://sourceforge.net/p/osdldbt/dbt2/ci/master/tree I said my p

Re: [GENERAL] Error when test on DBT2 Postgresql

2015-11-08 Thread Adrian Klaver
On 11/07/2015 11:27 PM, Tim Chou wrote: Hi All, When I test the DBT2 with a large number of connections, I always get the error: Error in read.table(file = file, header = header, sep = sep, quote = quote, : no lines available in input Calls: read.csv -> read.table I have tracked the file a

[GENERAL] Error when test on DBT2 Postgresql

2015-11-07 Thread Tim Chou
Hi All, When I test the DBT2 with a large number of connections, I always get the error: Error in read.table(file = file, header = header, sep = sep, quote = quote, : no lines available in input Calls: read.csv -> read.table I have tracked the file and see the reason is there are no "TERMINAT