|
From: Todd L. M. <tm...@ha...> - 2000-12-02 00:16:59
|
Should this query jump mysqld's CPU usage to 99% on a celeron 400, and cause the page to to take ten minutes to generate when run on all the pages from the JOSwiki (archive from jos.org)? $result = mysql_query( "SELECT topic,web,summary FROM" . $_SITE["dbtable"] . " WHERE web=\"" . $web . "\" ORDER BY lastedit DESC;" ); Or do I need to figure out a more efficient way to generate the table in the subsequent PHP code? (in TopicBody.ihtml, at http://cvs.sourceforge.net/cgi-bin/cvsweb.cgi/sfWiki/portal/htdocs/wiki/TopicBody.ihtml?cvsroot=sfwiki ) Thanks. (In either case, it looks like I should be pre-rendering the topic page!) -jQuinn |