Re: [Monetdb-developers] TPC-H benchmark about MonetDB

2010-07-15 Thread Fabian Groffen
On 16-07-2010 10:44:40 +0800, kun ren wrote: > I have try the redirecting  ,but it also have more time,and contain the > write file time.I just only want to know the time of actual execution > time.what do i do? In the latest version of the current development sources of MonetDB, mclient prints ex

Re: [Monetdb-developers] TPC-H benchmark about MonetDB

2010-07-15 Thread kun ren
I have try the redirecting ,but it also have more time,and contain the write file time.I just only want to know the time of actual execution time.what do i do? In monetdb homepape,i see your benchmarks,and I want to know how did you test the time? 在 2010年7月15日 下午9:30,kun ren 写道: > Thank you,Stef

[Monetdb-developers] RDF data management in MonetDB/SQL

2010-07-15 Thread wangx
Hi MonetDB developers, I have a question about RDF data management in MonetDB/SQL. The comment of sql.rdfshred says "shredding an RDF data file from location results in 7 new tables (6 permutations of SPO and a mapping) ... We can then query with SQL queries the RDF triple store by quering tab

Re: [Monetdb-developers] TPC-H Query-14

2010-07-15 Thread Fabian Groffen
On 15-07-2010 19:27:55 +0200, Stefan Manegold wrote: > > Why do I get an Exception when I got a result? Indeed, that violates the protocol. > "overflow" in decimal representation of intermediate result --- a known > issue with TPCH Q14 with SF >=10 when using decimals in your schema > (using floa

Re: [Monetdb-developers] TPC-H Query-14

2010-07-15 Thread Stefan Manegold
On Thu, Jul 15, 2010 at 07:03:51PM +0200, Romulo Goncalves wrote: > Hello, > > I am running TPC-H in the default version, updated 1 minute ago. > Compilation in Debug mode and I am running in my Desktop at CWI. > > I loaded TPC-H SF-10 without constraints. > > [gonca...@alviss queries]$ mclient

[Monetdb-developers] TPC-H Query-14

2010-07-15 Thread Romulo Goncalves
Hello, I am running TPC-H in the default version, updated 1 minute ago. Compilation in Debug mode and I am running in my Desktop at CWI. I loaded TPC-H SF-10 without constraints. [gonca...@alviss queries]$ mclient -lsql < 14.sql MAPI = mone...@localhost:55000 QUERY = select ERROR = !SQLExceptio

[Monetdb-developers] bug #2341 [was: MonetDB scalability]

2010-07-15 Thread Mark Bucciarelli
[Moving thread from -users to -dev.] On Thu, Jul 8, 2010 at 6:28 PM, Niels Nes wrote: > On Thu, Jul 08, 2010 at 03:05:35PM -0400, Mark Bucciarelli wrote: >> >> Dropping a column corrupts DB (#2341). >> Same as above. > > Both were fixed some time ago and tests were added by sjoerd. > These run fi

Re: [Monetdb-developers] TPC-H benchmark about MonetDB

2010-07-15 Thread kun ren
Thank you,Stefan Manegold.I will try. I want to go to CWI to study database .CWI is a very excellent research institutions. Best regards! 2010/7/15 Stefan Manegold > On Thu, Jul 15, 2010 at 04:45:25PM +0800, kun ren wrote: > > Dear everyone, > >Recently,i am testing the performance of Monet

Re: [Monetdb-developers] TPC-H benchmark about MonetDB

2010-07-15 Thread Stefan Manegold
On Thu, Jul 15, 2010 at 04:45:25PM +0800, kun ren wrote: > Dear everyone, >Recently,i am testing the performance of MonetDB. But I want to know the > time of execution one sql. I type \t on CLI. and then it returns a > execution time. But I found that the time include the print resultset time.

[Monetdb-developers] TPC-H benchmark about MonetDB

2010-07-15 Thread kun ren
Dear everyone, Recently,i am testing the performance of MonetDB. But I want to know the time of execution one sql. I type \t on CLI. and then it returns a execution time. But I found that the time include the print resultset time.I just only want to know the time of execution ,not include the p