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 for the query, you didn't give us anything to go on. What kind of WHERE are you doing? Are you using a full-text search, or a LIKE? Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: icoste [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 18, 2007 4:37 AM > To: mysql@lists.mysql.com > Subject: Results taking over 15 seconds! > > > 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-tf3599 > 623.html#a10054498 > Sent from the MySQL - General mailing list archive at Nabble.com. > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
