Re: [PHP] Re: Speed up MySQL

2003-06-27 Thread Wendell Brown
On Fri, 27 Jun 2003 15:05:29 -0500, Erich Kolb wrote: >I am already running MySQL 4, how would I go about adding indexes? http://www.mysql.com/doc/en/CREATE_INDEX.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php

[PHP] Re: Speed up MySQL

2003-06-27 Thread Erich Kolb
I am already running MySQL 4, how would I go about adding indexes? "Manuel Lemos" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Hello, > > On 06/27/2003 04:55 PM, Erich Kolb wrote: > > Can anyone offer some suggestions as to how I can speed up MySQL query > > results? I have a sim

[PHP] Re: Speed up MySQL

2003-06-27 Thread Manuel Lemos
Hello, On 06/27/2003 04:55 PM, Erich Kolb wrote: Can anyone offer some suggestions as to how I can speed up MySQL query results? I have a simple database with 3 fields in 1 table. The thing is that there are over 11 million records. Average query time is about 25 seconds. The machine itself is