The problem with upgrading hardware is that it belongs to the host, not to us :) So that's why I was hoping to be able to optimize the query as much as possible and then if that still doesnąt work, email my host and see if they can upgrade their hardware...
Cheers! Rick "Continuing to cling to the patterns you know inhibits your ability to discover what you don't know." - Eric Allenbaugh > From: MySQL Newsgroup (@Basebeans.com) <[EMAIL PROTECTED]> > Date: Wed, 31 Jul 2002 13:25:02 -0700 > To: [EMAIL PROTECTED] > Subject: Re: Speed issues... > > Subject: Re: Speed issues... > From: "Jared Richardson" <[EMAIL PROTECTED]> > === > "Richard Baskett" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED]... >> This is my first post here.. So be nice! ;) >> >> I have a database with a little over 60,000 records and when I do a search >> on that db it takes a little over a minute and a half to return results. >> This is very unacceptable, but Im just not sure what I can do to remedy >> this. Here is what the query looks like when just using location and >> category in the search.. > > Post your hardware information as well..... > > Adding ram and cpu helps about any query! ;) > > > > > > --------------------------------------------------------------------- > 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 > > > --------------------------------------------------------------------- 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
