advanced_search.php hangs

Help
Irish
2011-07-05
2013-05-28
  • Irish
    Irish
    2011-07-05

    What would cause the advanced_search.php to hang (page doesn't render in the browser & the mysql server connection is retained for long periods of time)? This page has never been revised in any way.  The query hangs on is the SELECT DISTINCT query with the LEFT JOINS, etc. (from the include.inc.php file) when the user is logged in and it causes every other page to hang after that (you have to clear the browser before logging back in). After a bit more research it appears that all SQL queries hang although they don't seem to affect movements after the query is cancelled like the advanced_serach hang does. The advanced_search.php works 100% perfect if you are not logged in. What would cause the SQL statements to not work? I believe this is actually a database issue but any clues or help from anyone would be greatly appreciated.

     
  • You're correct that this seems to be a database issue & you're best bet will probably be to seek help from your database provider.  You don't say which database (and version) you are using.  Do other JOIN queries hang?  Do you have the relevant indexes?