[sfWiki-devel] MySQL vs PHP speed

[Todd L. M. <tm...@ha...>]

	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