Gossamer Forum
Home : Products : Gossamer Links : Discussions :

MySQL usage

Quote Reply
MySQL usage
Is there any way to know the number of mysql queries each page from links SQL uses. In vbulletin we just add &showqueries=1 to the end and it does that.

If not, can someone give an estimate. The reason is vbulletin uses mysql quite extensivly and is it normally the weak link in the server set up (max of about 250 online with a decent dedicated server) so wondering how much links use of mysql is going to add to that. This would also affect whether i go for static pages or dynamic. As 50% of everything is going to be dynamic anyway it seems perhaps silly doing static as well but I am not sure.

http://www.ASciFi.com/ - The Science Fiction Portal
Quote Reply
Re: MySQL usage In reply to
Hi,

If you turn debug on, and put <pre><%GT::SQL::query_stack_disp%></pre> in your template, you will see the last 50 queries that were executed.

Cheers,

Alex

--
Gossamer Threads Inc.
Quote Reply
Re: MySQL usage In reply to
brilliant. Thanks.

http://www.ASciFi.com/ - The Science Fiction Portal