[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