On Tue, 2002-07-23 at 15:27, Gerald Clark wrote: > 20 simultaneous cartesian products on large tables would be expected to make > any sql server busy, not to mention use a lot of temporary disk space. > Are you sure you are not running out of disk space?
No, there's enough disk space and memory, but I do agree that this slowdown can be acceptable. This stress testing came out as I had to debug another problem: a simple select made with a java program through jdbc repeated 20 + times (less than 30) gets me the following error: error: 'Can't create a new thread (errno 11). If you are not out of available memory, you can consult the manual for a possible OS-dependent bug' At first I thought this was a thread problem so I decided to stress the db a little, but the java program is very simple. Anyone has ever seen this error ? -- - .a.c. - Andrea Carpani - <[EMAIL PROTECTED]> http://www.vitaminic.[it|com|co.uk|de|es|fr|nl|se|dk|ie] http://www.peoplesound.com http://www.iuma.com http://www.zipmind.it http://www.francemp3.com (www.mp3france.com) _______________________________________ DISCLAIMER, PLEASE NOTE: This communication is intended only for use by the addressee. It may contain confidential or privileged information. Transmission, distribution and/or copy cannot be permitted. Please notify Vitaminic Spa immediately by reply e-mail if you are not the intended recipient. Vitaminic Spa does not accept liability for corruption, interception or amendment, if any, or the consequences thereof. _______________________________________ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
