Thanks a lot for helping. I am unable to figure as to where does * <dbfarm>/<dbname>* directory reside within ubuntu 12.04. Can you please help me with this.
On Sun, Oct 13, 2013 at 6:06 PM, users-list-request@monetdb.org wrote:
Send users-list mailing list submissions to users-list@monetdb.org
To subscribe or unsubscribe via the World Wide Web, visit https://www.monetdb.org/mailman/listinfo/users-list or, via email, send a message with subject or body 'help' to users-list-request@monetdb.org
You can reach the person managing the list at users-list-owner@monetdb.org
When replying, please edit your Subject line so it is more specific than "Re: Contents of users-list digest..."
Today's Topics:
- Re: Query execution time (baraa Mohamad)
- Re: Query execution time (Martin Kersten)
- Re: How to transfer monetdb database to another machine (Martin Kersten)
- Re: Query execution time (Martin Kersten)
Message: 1 Date: Sun, 13 Oct 2013 12:31:35 +0200 From: baraa Mohamad bem85@hotmail.com To: Communication channel for MonetDB users users-list@monetdb.org Cc: Communication channel for MonetDB users users-list@monetdb.org Subject: Re: Query execution time Message-ID: BAY406-EAS1557A9804AABD08B94A7905A8190@phx.gbl Content-Type: text/plain; charset="utf-8"
That's great! Thank you very much for your appreciated help.
I just could't really understand the output of this command.
This is my output: Real: 1m23 User: 0m24s Sys: 0m2.3s
I'm a little bit confused because when I execute the same query directly without the time option i get 733,28ms.
So i couldn't know what is the real execution time.
Le 13 oct. 2013 ? 11:29, "Martin Kersten" Martin.Kersten@cwi.nl a
?crit :
How about (time mclient -d db <inputfile >/dev/null)
On 10/13/13 11:24 AM, baraa Mohamad wrote: Thank you for your answer. But in general I would like to know how to get the query exexution time without printing the results. It's for performance comparaison. I want to evaluate MonetDB for my research and i'm working with large tables.
Please any idea??
Greetings, Baraa
Le 13 oct. 2013 ? 11:02, "Martin Kersten" <Martin.Kersten@cwi.nl mailto:Martin.Kersten@cwi.nl> a ?crit :
Hi
On 10/13/13 10:55 AM, baraa Mohamad wrote:
> Hello dear MontDB users, > > I have a question please, I just need to get the query execution
time
> without showing the results of the query (for performance > comparaison) . > Something which corresponds to the "traceonly" in Oracle. that will
be
> greate if I can see the query plan but for the moment the most > important > for me is to get the query execution time. > > for example: I want to know the query exection time of this query > (select * from source where a>10) knowing that I have more than one
This is not the ind of query you fire when you expect a large outcome. Better use SELECT COUNT(*)....
> hundred million records which correspond to this predicate. > > Thank in advace for your appreciated help. > > Baraa
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list