not the variable, Its the sql statements which get fired at the database when you do the search on you application. May be you should check you app server for this sql statements.
regards anandkl On 4/18/07, Ananda Kumar <[EMAIL PROTECTED]> wrote:
can u please let us know the mysql query that gets generated during your search. Also, get the explain plan of the sql. regards anandkl On 4/18/07, icoste <[EMAIL PROTECTED]> wrote: > > > Hi, I am having problems with result times. I run a search from my > website > and it takes around 15 seconds to generate the mysql query and then 40 > seconds to load the page! > > Does anyone have any ideas on this because it is racking my brains! > > The address is http://www.icoste.com > > Thanks in advance. > -- > View this message in context: > http://www.nabble.com/Results-taking-over-15-seconds%21-tf3599623.html#a10054498 > Sent from the MySQL - General mailing list archive at Nabble.com<http://nabble.com/> > . > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
