RE: Results taking over 15 seconds!

2007-04-18 Thread Jerry Schwartz
The sheer number of tables and rows might be part of the problem with displaying the page, although it's hard for me to say. At one point I put some HTML comments inside a PHP loop, so they were generated for every line item on a page, and was astonished at how long it took to load and render. As

Re: Results taking over 15 seconds!

2007-04-18 Thread Ananda Kumar
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

Re: Results taking over 15 seconds!

2007-04-18 Thread Ananda Kumar
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 g