On Tue, Aug 05, 2008 at 05:25:09PM +0200, Cronje Fourie wrote:
Hi guys....
I've got to machines running Monet. 1. Quad core Intel with 4GB RAM, Ubuntu 8.04 32BIT (server ed) 2. AMD64 Quad Core, 4GB RAM, KUbuntu 8.04 64BIT (kde 3.5.9) Very good that you list you hardware details. Could you also include
On Tue, Aug 05, 2008 at 06:15:38PM +0200, Stefan Manegold wrote: the version of MonetDB you are currently using (on both) systems? Niels
On system 1 I can do a "copy into" of 6million records in no time at all :)
On system 2 the same function, with the exact same data takes forever.
Any thoughts on the reason? Is this a memory related issue?
I assume that you configure MonetDB on both machines with the same (if any) optimization and/or debugging options and compiled it with the same (versions of) tools (in particular compiler).
Morover, I assume that you built a 64-bit version with 64-bit OIDs on the 64-bit machine (should be the default on a 64-bit machines).
Finally, I assume that both machines have comparable I/O systems (disks).
Did/can you check how big your mserver5 process is growing on both machines during the copy into, and/or whether either machines (obviously the second one) is swapping heavily during the copy into?
How wide are your records, i.e., what does your 'create table' statement look like?
Do you load from a plain (uncompressed) file or from a compressed (how) file?
Stefan
Cronje
-- | Dr. Stefan Manegold | mailto:Stefan.Manegold@cwi.nl | | CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ | | 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 | | The Netherlands | Fax : +31 (20) 592-4312 |
------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- Niels Nes, Centre for Mathematics and Computer Science (CWI) Kruislaan 413, 1098 SJ Amsterdam, The Netherlands room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312 url: http://www.cwi.nl/~niels e-mail: Niels.Nes@cwi.nl