Posting messages is very slow (5-6 seconds) Can anyone help?

[goitalone]

Seems to take about 5-6 seconds to post a reply or new topic etc.

Why so long?

I have played around a bit with other themes and so far all of them post very quickly (like in 1-2 seconds) compared to my main theme which takes much longer at around 5-6 seconds each time.

At first I thought it may have been my background image being kinda large, but that wasn't the problem.

Any ideas are greatly welcomed.

Thanks alot

[codenaught]

Where, here? On your forum?

[goitalone]

On my forum sorry.

Here it posts pretty quickly?

I was thinking because it was maybe due to having so many mods intalled on my forum and it might be slowing it down?

Link to my forum if anyone feels like testing it out:

http://infotipper.com/forum

[metallica48423]

not sure, is it a shared server?

if so, that could be part of it.  I'm pretty sure this site is on a dedicated server or two.

[goitalone]

Yeah very well could be due to me having a shared server as well I guess.

I can't afford a dedicated..I am actually with a free hosting service, but it is pretty much the best one out there and I am sticking with it as long as I don't start getting downtimes etc.

[metallica48423]

you could try disabling hostname lookups and see if it helps any.

Admin => Features and Options => Layout and Options => Disable Hostname Lookups

[goitalone]

I just tried it...didn't change anything though...still takes about 5-6 seconds to post...it removes a topic quickly though, just won't post fast

[goitalone]

Hmm...ok, I still need an answer here an if anyone has any ideas why my forum might be taking so long to post a message.

I have played around a bit with other themes and so far all of them post very quickly (like in 1-2 seconds) compared to my main theme which takes much longer at around 5-6 seconds each time.

At first I thought it may have been my background image being kinda large, but that wasn't the problem.

Any ideas are greatly welcomed.

Thanks alot

[goitalone]

I was hoping someone out there would have some idea why.

Anyone at all have any ideas why it takes ferever? Could it be an incorrectly installed mod?

All my other themes post really quick!

[codenaught]

It is only slow for one theme? What theme is it? The SMF default theme? Any errors in your forum error log?  

[goitalone]

I was just reading how to insert the debugging mode code thing and here is the results:

In the area with the quick reply at the bottom of the page (where I have added color bar mod AND enhanced quick reply mod) it shows this error:

Code Select Expand

Notice: Undefined offset: 532 in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?) on line 874

Notice: Undefined offset: 533 in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?) on line 875[/b]

The rest of the report looks like this:

[b]Templates: 2: index (Moonraker), Display (default).
Sub templates: 4: init, main_above, main, main_below.
Language files: 3: index.english (Moonraker), Modifications.english (Moonraker), Post.english (Moonraker).
Files included: 9 - 403KB. (show./index.php, ./Settings.php, ./Sources/QueryString.php, ./Sources/Subs.php, ./Sources/Errors.php, ./Sources/Load.php, ./Sources/Security.php, ./Sources/Display.php, ./Sources/CustomProfile.php)
Queries used: 24.

      UPDATE smf_log_activity
      SET
         hits = hits + 1,
         posts = posts + 1
      WHERE date = '2007-03-23'
      LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Subs.php line 3075, which took 0.00116587 seconds.

         SET NAMES utf8
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 150, which took 0.00055099 seconds.

         SELECT variable, value
         FROM smf_settings
   which took 0.00565195 seconds.

      SELECT data
      FROM smf_sessions
      WHERE session_id = '58d2dc3f9a8f3a500f4d122b49f09c78'
      LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 1984, which took 0.0014782 seconds.

            SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, a.attachmentType
            FROM smf_members AS mem
               LEFT JOIN smf_attachments AS a ON (a.ID_MEMBER = 2)
            WHERE mem.ID_MEMBER = 2
            LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 390, which took 0.00104403 seconds.

         SELECT
            c.ID_CAT, b.name AS bname, b.description, b.numTopics, b.memberGroups,
            b.ID_PARENT, c.name AS cname, IFNULL(mem.ID_MEMBER, 0) AS ID_MODERATOR,
            mem.realName, b.ID_BOARD, b.childLevel,
            b.ID_THEME, b.override_theme, b.permission_mode, b.countPosts
         FROM (smf_boards AS b, smf_topics AS t)
            LEFT JOIN smf_categories AS c ON (c.ID_CAT = b.ID_CAT)
            LEFT JOIN smf_moderators AS mods ON (mods.ID_BOARD = t.ID_BOARD)
            LEFT JOIN smf_members AS mem ON (mem.ID_MEMBER = mods.ID_MEMBER)
         WHERE b.ID_BOARD = t.ID_BOARD
            AND t.ID_TOPIC = 76
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 576, which took 0.00078893 seconds.

         SELECT variable, value, ID_MEMBER, ID_THEME
         FROM smf_themes
         WHERE ID_MEMBER IN (-1, 0, 2)
            AND ID_THEME IN (25, 1)
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 1163, which took 0.00052595 seconds.

         UPDATE smf_topics
         SET numViews = numViews + 1
         WHERE ID_TOPIC = 76
         LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 145, which took 0.00029802 seconds.

      SELECT
         t.numReplies, t.numViews, t.locked, ms.subject, t.isSticky, t.ID_POLL,
         t.ID_MEMBER_STARTED, t.ID_FIRST_MSG, t.ID_LAST_MSG,
         IFNULL(lt.ID_MSG, -1) + 1 AS new_from
      FROM (smf_topics AS t, smf_messages AS ms)
         LEFT JOIN smf_log_topics AS lt ON (lt.ID_TOPIC = 76 AND lt.ID_MEMBER = 2)
      WHERE t.ID_TOPIC = 76
         AND ms.ID_MSG = t.ID_FIRST_MSG
      LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 160, which took 0.00039005 seconds.

               SELECT IFNULL(lt.ID_MSG, IFNULL(lmr.ID_MSG, -1)) + 1 AS new_from
               FROM smf_topics AS t
                  LEFT JOIN smf_log_topics AS lt ON (lt.ID_TOPIC = 76 AND lt.ID_MEMBER = 2)
                  LEFT JOIN smf_log_mark_read AS lmr ON (lmr.ID_BOARD = 24 AND lmr.ID_MEMBER = 2)
               WHERE t.ID_TOPIC = 76
               LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 187, which took 0.00054598 seconds.

            UPDATE smf_log_topics
            SET ID_MSG = 278
            WHERE ID_MEMBER = 2
               AND ID_TOPIC = 76
            LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 275, which took 0.00019288 seconds.

         SELECT sent, ID_TOPIC
         FROM smf_log_notify
         WHERE (ID_TOPIC = 76 OR ID_BOARD = 24)
            AND ID_MEMBER = 2
         LIMIT 2
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 292, which took 0.00034118 seconds.

      SELECT ID_MSG, ID_MEMBER
      FROM smf_messages
      WHERE ID_TOPIC = 76
      ORDER BY ID_MSG DESC
      LIMIT 0, 15
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 682, which took 0.00161982 seconds.

            SELECT
               a.ID_ATTACH, a.ID_MSG, a.filename, IFNULL(a.size, 0) AS filesize, a.downloads,
               a.width, a.height,
               IFNULL(thumb.ID_ATTACH, 0) AS ID_THUMB, thumb.width AS thumb_width, thumb.height AS thumb_height
            FROM smf_attachments AS a
               LEFT JOIN smf_attachments AS thumb ON (thumb.ID_ATTACH = a.ID_THUMB)
            WHERE a.ID_MSG IN (278,273)
               AND a.attachmentType = 0
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 711, which took 0.00045896 seconds.

         SELECT
         IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, a.attachmentType,
         mem.signature, mem.personalText, mem.location, mem.gender, mem.avatar, mem.ID_MEMBER, mem.memberName,
         mem.realName, mem.emailAddress, mem.hideEmail, mem.dateRegistered, mem.websiteTitle, mem.websiteUrl,
         mem.birthdate, mem.memberIP, mem.memberIP2, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.posts, mem.lastLogin,
         mem.karmaGood, mem.ID_POST_GROUP, mem.karmaBad, mem.lngfile, mem.ID_GROUP, mem.timeOffset, mem.showOnline,
         mem.buddy_list, mg.onlineColor AS member_group_color, IFNULL(mg.groupName, '') AS member_group,
         pg.onlineColor AS post_group_color, IFNULL(pg.groupName, '') AS post_group, mem.is_activated,
         IF(mem.ID_GROUP = 0 OR mg.stars = '', pg.stars, mg.stars) AS stars,
         mem.usertitle
         FROM smf_members AS mem
         LEFT JOIN smf_log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN smf_attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN smf_membergroups AS pg ON (pg.ID_GROUP = mem.ID_POST_GROUP)
         LEFT JOIN smf_membergroups AS mg ON (mg.ID_GROUP = mem.ID_GROUP)
         WHERE mem.ID_MEMBER IN ('2', '92')
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 888, which took 0.00088811 seconds.

         SELECT *
         FROM smf_themes
         WHERE ID_MEMBER IN (2, 92)
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 905, which took 0.00057602 seconds.

         SELECT
            ID_MSG, icon, subject, posterTime, posterIP, ID_MEMBER, modifiedTime, modifiedName, body,
            smileysEnabled, posterName, posterEmail,
            ID_MSG_MODIFIED < 280 AS isRead
         FROM smf_messages
         WHERE ID_MSG IN (278,273)
         ORDER BY ID_MSG DESC
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Display.php line 739, which took 0.00029421 seconds.

      SELECT c.name AS catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM smf_boards AS b
         LEFT JOIN smf_categories AS c ON (c.ID_CAT = b.ID_CAT)
      WHERE 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php line 1680, which took 0.00036192 seconds.

      UPDATE smf_log_activity
      SET
         hits = hits + 1
      WHERE date = '2007-03-23'
      LIMIT 1
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Subs.php line 3075, which took 0.00015807 seconds.

               SELECT code, filename, description
               FROM smf_smileys
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Subs.php line 2577, which took 0.000103 seconds.

SELECT IFNULL(mem.realName, m.posterName) AS posterName, m.posterTime, m.body, m.smileysEnabled, m.ID_MSG
FROM smf_messages AS m
LEFT JOIN smf_members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)
WHERE m.ID_MSG = 273
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php(1724) : eval()'d code line 12, which took 0.00028992 seconds.

            SELECT code, filename, description, smileyRow, hidden
            FROM smf_smileys
            WHERE hidden IN (0, 2)
            ORDER BY smileyRow, smileyOrder
   in /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Sources/Load.php(1724) : eval()'d code line 787, which took 0.000139 seconds.

      INSERT INTO smf_log_errors
         (ID_MEMBER, logTime, ip, url, message, session)
      VALUES (2, 1174698637, SUBSTRING('72.188.78.115', 1, 16), SUBSTRING('?topic=76.new', 1, 65534), SUBSTRING('8: Undefined offset: 532<br />File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)<br />Line: 874', 1, 65534), '6f897e6e1ae2ebd50ebcae110f7ac532')
   which took 0.00041986 seconds.

      INSERT INTO smf_log_errors
         (ID_MEMBER, logTime, ip, url, message, session)
      VALUES (2, 1174698637, SUBSTRING('72.188.78.115', 1, 16), SUBSTRING('?topic=76.new', 1, 65534), SUBSTRING('8: Undefined offset: 533<br />File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)<br />Line: 875', 1, 65534), '6f897e6e1ae2ebd50ebcae110f7ac532')
   which took 0.00017285 seconds.

Mod edit: Added code tags for readability!

[goitalone]

And here is the actual SMF error log:

Code Select Expand

SDA_Soul   Today at 08:10:37 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=76.new 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 875

   SDA_Soul   Today at 08:10:37 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=76.new 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 874

   SDA_Soul   Today at 08:09:45 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?action=post;topic=76.0;num_replies=0 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 774

   SDA_Soul   Today at 08:09:45 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?action=post;topic=76.0;num_replies=0 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 773

   SDA_Soul   Today at 08:09:40 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=76.0 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 875

   SDA_Soul   Today at 08:09:40 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=76.0 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 874

   SDA_Soul   Today at 06:31:10 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 875

   SDA_Soul   Today at 06:31:10 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 874

   SDA_Soul   Today at 06:31:05 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 875

   SDA_Soul   Today at 06:31:05 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 874

   SDA_Soul   Today at 06:31:01 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?action=post;msg=270;topic=71.0;sesc 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 774

   SDA_Soul   Today at 06:31:01 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?action=post;msg=270;topic=71.0;sesc 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 773

   SDA_Soul   Today at 06:30:47 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 875

   SDA_Soul   Today at 06:30:47 PM 
72.188.78.115     6f897e6e1ae2ebd50ebcae110f7ac532 
http://infotipper.com/forum/index.php?topic=71.0 
8: Undefined offset: 532
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/Moonraker/languages/Post.english.php (main sub template - eval?)
Line: 874

   gri   Today at 06:05:15 PM 
87.237.119.17     21342aa73eeca8e893048ecd07650d10 
http://infotipper.com/forum/index.php?topic=76.new;topicseen 
8: Undefined offset: 533
File: /www/110mb.com/g/o/i/t/a/l/o/n/goitaloner/htdocs/forum/Themes/default/languages/Post.english.php (main sub template - eval?)
Line: 875

Mod edit: Added code tags for reability!

[goitalone]

K, well I found the problem myself...it was the Moonraker index.template.php itself causing the slow posting of messages. I switched everything to the default theme and it works perfectly.

Something seriously wrong with Moonraker template. Only thing I don't like about the default is the top collapsible part with your personal info. I wanted that to be gone but I guess if you do that, then it becomes Moonraker theme and will be slow again.

Don't feel like messing with it tho. Oh, I also don't like how my logo messes up the color when placed at the top. Not sure how to fix that either.

[SlammedDime]

goitalone, is this issue resolved, or did you still require assistance with it?