ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Template Debugging with Large Queries

January 28, 2013 12:00pm

Subscribe [1]
  • #1 / Jan 28, 2013 12:00pm

    Ace Prod

    111 posts

    Hi guys,

    We have an EE installation running MSM and the Forum Module with over 230,000 forum members.

    Unfortunately we’re starting the see the following message when accessing the site:

    Database Error: Unable to connect to your database. Your database appears to be turned off or the database connection settings in your config file are not correct. Please contact your hosting provider if the problem persists.

    and our web host has informed us that it’s the following query that slowing things down to a standstill:

    SELECT screen_name, member_id FROM tableprefix_members

    My questions are:

    1)  Out of the following, which of the two are partially responsible for causing the the slow down:

    (1.460080) -> Method Called: entries
    (6.425160) Calling Extension Class/Method: Fieldframe/weblog_entries_tagdata

    Is it the Method or Extension Class call causing the slow down?

    2) Where would the query above be found within my EE installation?

    Thanks!

    David

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases