On 6/15/11 12:14 AM, julio Puebla wrote:
When I run
COPY 5000 RECORDS INTO myTests FROM '/home/loadFile88.csv' USING DELIMITERS ',';
In my development enviroment makes it very fast, but in my ubuntu server 10.10 makes it very very slow took 2 minutes to complete this task. There are many issues involved that can cause this to happen. Most likely it is related to what is running on your server, (check top to see how much other stuff is running), and how it attaches to the disk drive (see iotop), the file system type and location (see /etc/mount). Not to mention just basic hardware differences.
Overall, the information provided does not provide us enough contextual information to be of much help here. regards, Martin
Date: Tue, 14 Jun 2011 09:48:31 +0200 From: Fabian.Groffen@cwi.nl To: monetdb-users@lists.sourceforge.net Subject: Re: [MonetDB-users] problem with ubuntu server 10.10
On 14-06-2011 00:12:43 +0000, julio Puebla wrote:
I installed monetdb_11.1.1-20110324 in my development enviroment and everything works great under ubuntu desktop 10.10, when I installed the same version of monetdb in the production enviroment on ubuntu server 10.10 the connections and querys are very slow, It doesn't happen in my development enviroment, I already use the package installation and the source code. Same result. Do you have any idea why?
What exactly do you mean with "slow"? Is the query execution slow? Is making connections slow? Debian/Ubuntu has a known odd behaviour of having a very slow startup time of monetdbd.
------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ EditLive Enterprise is the world's most technically advanced content authoring tool. Experience the power of Track Changes, Inline Image Editing and ensure content is compliant with Accessibility Checking. http://p.sf.net/sfu/ephox-dev2dev
_______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users