Hello Andreas,
Saturday, March 17, 2001, 6:36:17 PM, you wrote:
AV> I noticed that in 3. and 4. the machine load was constantly at 100% during
AV> the inserts.
AV> but during index recreation the load springs wildley between 0 and 100%, so
AV> the machine is not maxed out in terms of CPU utilization here (in other
AV> words, the machine is waiting for something to do :-). The same applies to
AV> 2. when commit() was send.
AV> I tested also 1. and 3. with a myisam-table. Index recreation draws
AV> constantly 100% load from the machine here, therfore it's faster.
AV> results:
AV> 5. same as 1. but with myisam type => 116 seconds
AV> 6. same as 3. but with myisam type => 65 seconds + additional 33 seconds for
AV> index recreation.
Could you tell me what do you mean by index creation ? Did you drop
all indexes or only secondary index while leaving primary in fact ?
--
Best regards,
Peter mailto:[EMAIL PROTECTED]
---------------------------------------------------------------------
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
