On 26 Jun 2003 at 17:45, Charles Vos wrote: > Could somebody please enlighten me as to why it takes nearly 2 > hours to put 8 rows of data into my table?
It's not the INSERT that's taking so long -- it's the SELECT. Try the SELECT alone, and it will probably take the same amount of time. Do an EXPLAIN on each of your SELECT queries and compare the use of indexes to see why there's such a difference. -- Keith C. Ivey <[EMAIL PROTECTED]> Tobacco Documents Online http://tobaccodocuments.org -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
