[MonetDB-users] Response time
Hi,
I am experiencing a huge difference between query response times of "mserver5 --readonly" and plain "mserver5".
The difference is in the order of 25 sec vs 25 min.
The disks are rather slow and there is a lot of disk write going on. (Not in readonly, obviously.)
How can I investigate this further?
Regards, Mitja
Mitja Kleider wrote:
Hi,
I am experiencing a huge difference between query response times of "mserver5 --readonly" and plain "mserver5".
The difference is in the order of 25 sec vs 25 min.
The disks are rather slow and there is a lot of disk write going on. (Not in readonly, obviously.)
How can I investigate this further?
Make sure the results are repeatable. THen use the TRACE option for SQL to assess which part of your queries are slow.
Regards, Mitja
This SF.net email is sponsored by
Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
participants (2)
-
Martin Kersten
-
Mitja Kleider