New subject: How to transfer monetdb database to another machine

13 Oct 2013


      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,  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:
1. Re: Query execution time (baraa Mohamad)
   2. Re: Query execution time (Martin Kersten)
   3. Re: How to transfer monetdb database to another machine
      (Martin Kersten)
   4. Re: Query execution time (Martin Kersten)
----------------------------------------------------------------------
Message: 1
Date: Sun, 13 Oct 2013 12:31:35 +0200
From: baraa Mohamad 
To: Communication channel for MonetDB users 
Cc: Communication channel for MonetDB users 
Subject: Re: Query execution time
Message-ID: 
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"  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" 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

Re: How to transfer monetdb database to another machine

Rose Beck

Stefan Manegold

tags

participants (2)