Re: 10 minutes seems excessive...

2004-04-22 Thread Ken Menzel
=month_day then? Ken - Original Message - From: "Mailing Lists" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, April 21, 2004 3:04 AM Subject: 10 minutes seems excessive... > Hello all... > > Source table has approximately 23,000,000 rows.

10 minutes seems excessive...

2004-04-21 Thread Mailing Lists
Hello all... Source table has approximately 23,000,000 rows. The explain below shows we'll be working with 2,707,366 of those rows just inserting them into a table. Why does this take 10 minues to run? System specifications below all that. * Precompiled binary from mysql.com * Completely idle