Hi, - How does the server crash, i.e., do you get any error messages either on the mserver5 console or on the mclient side? - Which version of MonetDB are you using? - Which OS are you running MonetDB on? - What kind of hardware (CPU, amount of RAM, amount of swap) do you use? - Is the HW 32 or 64 bit? If HW is 64 bit, is the OS 32 or 64 bit? If OS is 64 bit, is your MonetDB 32 or 64 bit? If MonetDB is 64 bit, do you use 32-bit OIDs or 64-bit OIDs? Providing us with the output of mserver5 --version should answer most of the above questions about MonetDB. Stefan On Thu, Jan 15, 2009 at 09:13:25AM -0500, dariuszs wrote:
Hi, table1 - 1,000,000 records table2 - 300,000 records (from table1) table3 - 400,000 records (from table1)
They key (key27) on all tables is varchar(27) SQL
select count(*) from table1 where key27 in (select key27 from table2, table3); (the answer should be 700,000)
At this point server crashed.
I'm trying to join 3 tables to get a count on table1 only when there is a match in table2 or table3. Could you provide me with a sample how to properly match 3 or more tables based on the match key? Thank you. Dariusz.
Martin Kersten wrote:
dariuszs wrote:
Hi, The SQL server crashes when I try to join 3 tables using 27 bytes key? Can you help me? Thanks. Dariusz.
It would be helpful if you provide a 5 line example that demonstrates the problem.
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
------------------------------------------------------------------------------ This SF.net email is sponsored by: SourcForge Community SourceForge wants to tell your story. http://p.sf.net/sfu/sf-spreadtheword _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- | 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 |