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 <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20131013/80333f80/attachment-0001.html>
------------------------------
Message: 2
Date: Sun, 13 Oct 2013 12:54:58 +0200
From: Martin Kersten <Martin.Kersten@cwi.nl>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: Re: Query execution time
Message-ID: <525A7C02.6020002@cwi.nl>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
The first time you run a query all your data may reside on disk, i.e. a cold database.
The second time you run the same query you benefit from caching effects, i.e. a hot database
On 10/13/13 12:31 PM, baraa Mohamad wrote:
> 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 <mailto: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>
>>> <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> <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> <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 <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
>
------------------------------
Message: 3
Date: Sun, 13 Oct 2013 14:21:22 +0200
From: Martin Kersten <mk@monetdb.com>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: Re: How to transfer monetdb database to another machine
Message-ID: <525A9042.1050803@monetdb.com>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
This might help:
http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/DatabaseMigration
On 10/13/13 11:36 AM, Rose Beck wrote:
> I created monetdb database using the python library
> https://pypi.python.org/pypi/python-monetdb/11.16.0.7 on my ubuntu
> 12.04 lts server. Now I want to transfer this database to another
> ubuntu 12.04 lts server. However, I am unable to understand as to
> where(directory name) does monetdb create its database (within ubuntu
> 12.04) and what is the procedure which I must follow to transfer this
> database to another machine (so that i may query the database on
> another machine)?
>
>
> _______________________________________________
> users-list mailing list
> users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20131013/f4d44851/attachment-0001.html>
------------------------------
Message: 4
Date: Sun, 13 Oct 2013 14:36:16 +0200
From: Martin Kersten <mk@monetdb.com>
To: Communication channel for MonetDB users <users-list@monetdb.org>
Subject: Re: Query execution time
Message-ID: <525A93C0.9010604@monetdb.com>
Content-Type: text/plain; charset="iso-8859-1"; Format="flowed"
perhaps this might help
http://www.monetdb.org/Documentation/Cookbooks/SQLrecipes/QueryTiming
On 10/13/13 12:31 PM, baraa Mohamad wrote:
> 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
> <mailto: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>
>>> <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>
>>>>> <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>
>>>> <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 <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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20131013/f9c9975d/attachment.html>
------------------------------
Subject: Digest Footer
_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list
------------------------------
End of users-list Digest, Vol 14, Issue 17
******************************************