Re: [sfWiki-devel] MySQL vs PHP speed

[Iain S. <iai...@ya...>]

At 07:22 PM 12/1/00 -0500, Todd L. Miller wrote:
>         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)?

I can see this being true (although 10 minutes does seem wrong) because 
your result set should be over a thousand records.  Hence, it should be 
done once in a long while, or done incrementally (so you only get the full 
hit once when first doing the import).  I would also imagine php may be 
inefficient at such a large operation...  What's the size of the resulting 
page?

-iain