MKportal 1.0 Upgrade: HELP! Slow Page created in XXX seconds with XX queries

[xtremecruiser]

I am having issues with the times of the queries on my forum in the last few days. SLOW !
It is crawling and the DB went belly up with the nice error
"Connection Problems
Sorry, SMF was unable to connect to the database. This may be caused by the server being busy. Please try again later. "

I did a repair via the cpannel and got it working again, if fact all my SQL DB's died at the same time and my host says its not them , a mambo DB died too

I have a test site on another server and if I compare the times they are frighteningly different.
Same threads on each server.
Examples

test server:
Page created in 9.31 seconds with 17 queries.
Page created in 3.654 seconds with 19 queries.
Page created in 3.029 seconds with 19 queries.
Page created in 2.74 seconds with 19 queries.

On the Main server
Page created in 120.474 seconds with 113 queries.
Page created in 72.633 seconds with 112 queries.
Page created in 63.016 seconds with 116 queries.
Page created in 69.982 seconds with 114 queries.

I do not understand all the extra queries since the other one is less than 2 weeks old.
Now my test server I updated to 1.05 and the main slow server is at 1.03 but with all the DB issues I am having I am kinda afraid to do a upgrade right now.

Is 1.05 that much more efficient of is my host full of it since the site ran fast 4 days ago ?

Thanks !

I also have something in the DB that does this "localhost | | Connect | 50 | Reading from net"
I am guessing its the "Integrated Chat      2.2" that is on the main forum that I am too tired to remove tonight that has never caused a issue before.

[xtremecruiser]

I thought it might have been the update of MKportal from .8 to 1.0 so I removed mp and all its tables and the quires are still slow with so many added.

anyone ?

[Oldiesmann]

I'm not sure what could be causing the big jump in page creation time or the number of queries. Fortunately, SMF has great built-in debugging functions...

Add this line to Settings.php:

Code Select Expand

$db_show_debug = true;

Then, at the bottom of each page, you'll see something like this:

Queries used: X.

[show queries]

Click on the "Queries used" line to get a list of queries that were used along with the number of seconds it took for each query. You can also click on an individual query to get more info about that particular one.

Clicking on [show queries] will make SMF display the query info at the bottom of the page as well.

That should give you enough info to figure out what's causing the problems.

[xtremecruiser]

Checked with MKportal and they say that 1.0 may have had a issue with this and to wait for the next release
"The next version M1.1 addresses this issue. You should see the queries drop back to what you where seeing before you updated to M1.0."
This is not good.

I added the script changes you suggested and I am looking but no sql expert.
I can test the same threads and see a difference in speed between them ( in the Top 10 Topics (by Replies) )

Can you point me in the right direction ?
Thanks again.

[xtremecruiser]

19 queries vs 114 

[xtremecruiser]

Test servers output

Code Select Expand

Page created in 16.643 seconds with 16 queries.
Queries used: 16.

      SELECT variable, value
      FROM settings in xx/xxx/Sources/Load.php line 39, which took 0.00071310997009277 seconds.

      SELECT data
      FROM sessions
      WHERE session_id = '5af68a30d6aabe6bd9bba2c226a1475b'
      LIMIT 1 in xx/xxx/Sources/Load.php line 1174, which took 0.00051498413085938 seconds.

         SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH
         FROM members AS mem
            LEFT JOIN attachments AS a ON (a.ID_MEMBER = 17)
         WHERE mem.ID_MEMBER = 17
         LIMIT 1 in xx/xxx/Sources/Load.php line 109, which took 0.00092983245849609 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.use_local_permissions
      FROM boards AS b, topics AS t
         LEFT JOIN categories AS c ON (c.ID_CAT = b.ID_CAT)
         LEFT JOIN moderators AS mods ON (mods.ID_BOARD = t.ID_BOARD)
         LEFT JOIN members AS mem ON (mem.ID_MEMBER = mods.ID_MEMBER)
      WHERE b.ID_BOARD = t.ID_BOARD
         AND t.ID_TOPIC = 64 in xx/xxx/Sources/Load.php line 247, which took 0.00079703330993652 seconds.

      SELECT variable, value, ID_MEMBER, ID_THEME
      FROM themes
      WHERE ID_MEMBER IN (0, 17)
         AND ID_THEME = 1 in xx/xxx/Sources/Load.php line 680, which took 0.00022101402282715 seconds.

      SELECT
         t.numReplies, t.numViews, t.locked, ms.subject, t.isSticky, t.ID_POLL, t.ID_MEMBER_STARTED,
         IFNULL(lt.logTime, 0) AS logTime, t.ID_FIRST_MSG
      FROM topics AS t, messages AS ms
         LEFT JOIN log_topics AS lt ON (lt.ID_TOPIC = 64 AND lt.ID_MEMBER = 17)
      WHERE t.ID_TOPIC = 64
         AND ms.ID_MSG = t.ID_FIRST_MSG
      LIMIT 1 in xx/xxx/Sources/Display.php line 133, which took 0.00098490715026855 seconds.

         REPLACE INTO log_topics
            (logTime, ID_MEMBER, ID_TOPIC)
         VALUES (1126539226, 17, 64) in xx/xxx/Sources/Display.php line 225, which took 0.00047492980957031 seconds.

         SELECT sent, ID_TOPIC
         FROM log_notify
         WHERE (ID_TOPIC = 64 OR ID_BOARD = 1)
            AND ID_MEMBER = 17
         LIMIT 2 in xx/xxx/Sources/Display.php line 233, which took 0.00010895729064941 seconds.

         SELECT mem.ID_MEMBER, IFNULL(mem.realName, 0) AS realName, mem.showOnline
         FROM log_online AS lo
            LEFT JOIN members AS mem ON (mem.ID_MEMBER = lo.ID_MEMBER)
         WHERE lo.url LIKE '%s:5:"topic";i:64;%' in xx/xxx/Sources/Display.php line 298, which took 0.00043916702270508 seconds.

      SELECT ID_MSG, ID_MEMBER
      FROM messages
      WHERE ID_TOPIC = 64
      ORDER BY ID_MSG
      LIMIT 0, 50 in xx/xxx/Sources/Display.php line 529, which took 0.00024008750915527 seconds.

            SELECT ID_ATTACH, ID_MSG, filename, IFNULL(size, 0) AS filesize, downloads
            FROM attachments
            WHERE ID_MSG IN (319,321,323,329,332,336,355,365,371,403,454,462,501,505,508,525,561,565,578,626,627,629,638,639,710,714,715,727,735,739,788,847,856,877,898,902,1016,1031,1041,1058,1089,1279,1378,1403,1404,1406,1451,1479,1500,1725) in xx/xxx/Sources/Display.php line 553, which took 0.0010650157928467 seconds.

      SELECT
         IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, 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.location, 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,
         mg.onlineColor AS member_group_color, IFNULL(mg.groupName, '') AS member_group,
         pg.onlineColor AS post_group_color, IFNULL(pg.groupName, '') AS post_group,
         IF((mem.ID_GROUP = 0 OR mg.stars = ''), pg.stars, mg.stars) AS stars,
         mem.usertitle
      FROM members AS mem
         LEFT JOIN log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN membergroups AS pg ON (pg.ID_GROUP = mem.ID_POST_GROUP)
         LEFT JOIN membergroups AS mg ON (mg.ID_GROUP = mem.ID_GROUP)
      WHERE mem.ID_MEMBER IN ('313', '581', '684', '409', '322', '729', '928', '44', '75', '372', '253', '541', '11', '288', '138', '737', '765', '4', '397', '126', '673', '167', '487', '90', '425', '192', '917', '189', '341', '81', '596', '118', '668', '655', '449', '497', '95') in xx/xxx/Sources/Load.php line 469, which took 0.0032789707183838 seconds.

         SELECT *
         FROM themes
         WHERE ID_MEMBER IN (4, 11, 44, 75, 81, 90, 95, 118, 126, 138, 167, 189, 192, 253, 288, 313, 322, 341, 372, 397, 409, 425, 449, 487, 497, 541, 581, 596, 655, 668, 673, 684, 729, 737, 765, 917, 928) in xx/xxx/Sources/Load.php line 484, which took 0.0012269020080566 seconds.

         SELECT
            ID_MSG, icon, subject, posterTime, posterIP, ID_MEMBER, modifiedTime, modifiedName, body,
            smileysEnabled, posterName, posterEmail,
            (GREATEST(posterTime, modifiedTime) > 1126538988) AS isRead
         FROM messages
         WHERE ID_MSG IN (319,321,323,329,332,336,355,365,371,403,454,462,501,505,508,525,561,565,578,626,627,629,638,639,710,714,715,727,735,739,788,847,856,877,898,902,1016,1031,1041,1058,1089,1279,1378,1403,1404,1406,1451,1479,1500,1725)
         ORDER BY ID_MSG in xx/xxx/Sources/Display.php line 581, which took 0.0020449161529541 seconds.

      SELECT c.name as catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM boards AS b, categories AS c
      WHERE c.ID_CAT = b.ID_CAT
         AND 1
      ORDER BY c.catOrder, b.boardOrder in xx/xxx/Sources/Load.php line 1000, which took 0.00021791458129883 seconds.

            SELECT code, filename, description
            FROM smileys
            ORDER BY LENGTH(code) DESC in xx/xxx/Sources/Subs.php line 1117, which took 0.00069499015808105 seconds.

[hide queries]

[xtremecruiser]

Main slow servers code for the same thread

Code Select Expand

Page created in 133.779 seconds with 109 queries.
Queries used: 110.

      SELECT variable, value
      FROM settings in xx/xxx/Load.php line 39, which took 0.0011680126190186 seconds.

      SELECT data
      FROM sessions
      WHERE session_id = '19484b9c8f48317cd451d714b55004f6'
      LIMIT 1 in xx/xxx/Load.php line 1193, which took 0.27311682701111 seconds.

         SELECT mem.*, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH
         FROM members AS mem
            LEFT JOIN attachments AS a ON (a.ID_MEMBER = 731)
         WHERE mem.ID_MEMBER = 731
         LIMIT 1 in xx/xxx/Load.php line 109, which took 0.0013899803161621 seconds.

      SELECT
         b.sort_method, b.sort_direction,
         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.use_local_permissions
      FROM boards AS b, topics AS t
         LEFT JOIN categories AS c ON (c.ID_CAT = b.ID_CAT)
         LEFT JOIN moderators AS mods ON (mods.ID_BOARD = t.ID_BOARD)
         LEFT JOIN members AS mem ON (mem.ID_MEMBER = mods.ID_MEMBER)
      WHERE b.ID_BOARD = t.ID_BOARD
         AND t.ID_TOPIC = 64 in xx/xxx/Load.php line 249, which took 0.0010640621185303 seconds.

      SELECT variable, value, ID_MEMBER, ID_THEME
      FROM themes
      WHERE ID_MEMBER IN (0, 731)
         AND ID_THEME = 1 in xx/xxx/Load.php line 699, which took 0.022388935089111 seconds.

      SELECT
         t.numReplies, t.numViews, t.locked, ms.subject, t.isSticky, t.ID_POLL, t.ID_MEMBER_STARTED,
         IFNULL(lt.logTime, 0) AS logTime, t.ID_FIRST_MSG
      FROM topics AS t, messages AS ms
         LEFT JOIN log_topics AS lt ON (lt.ID_TOPIC = 64 AND lt.ID_MEMBER = 731)
      WHERE t.ID_TOPIC = 64
         AND ms.ID_MSG = t.ID_FIRST_MSG
      LIMIT 1 in xx/xxx/Display.php line 133, which took 0.0011320114135742 seconds.

         REPLACE INTO log_topics
            (logTime, ID_MEMBER, ID_TOPIC)
         VALUES (1126539226, 731, 64) in xx/xxx/Display.php line 225, which took 0.00041604042053223 seconds.

         SELECT sent, ID_TOPIC
         FROM log_notify
         WHERE (ID_TOPIC = 64 OR ID_BOARD = 1)
            AND ID_MEMBER = 731
         LIMIT 2 in xx/xxx/Display.php line 233, which took 0.0003049373626709 seconds.

         SELECT mem.ID_MEMBER, IFNULL(mem.realName, 0) AS realName, mem.showOnline
         FROM log_online AS lo
            LEFT JOIN members AS mem ON (mem.ID_MEMBER = lo.ID_MEMBER)
         WHERE lo.url LIKE '%s:5:"topic";i:64;%' in xx/xxx/Display.php line 298, which took 0.001215934753418 seconds.

      SELECT ID_MSG, ID_MEMBER
      FROM messages
      WHERE ID_TOPIC = 64
      ORDER BY ID_MSG
      LIMIT 0, 50 in xx/xxx/Display.php line 529, which took 0.00043582916259766 seconds.

            SELECT ID_ATTACH, ID_MSG, filename, IFNULL(size, 0) AS filesize, downloads
            FROM attachments
            WHERE ID_MSG IN (319,321,323,329,332,336,355,365,371,403,454,462,501,505,508,525,561,565,578,626,627,629,638,639,710,714,715,727,735,739,788,847,856,877,898,902,1016,1031,1041,1058,1089,1279,1378,1403,1404,1406,1451,1479,1500,1725) in xx/xxx/Display.php line 553, which took 0.0019369125366211 seconds.

      SELECT
         IFNULL(lo.logTime, 0) AS isOnline, IFNULL(a.ID_ATTACH, 0) AS ID_ATTACH, a.filename, 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.location, mem.ICQ, mem.AIM, mem.YIM, mem.MSN, mem.posts, mem.lastLogin, mem.karmaGood,
         mem.warning,
         mem.ID_POST_GROUP, mem.karmaBad, mem.lngfile, mem.ID_GROUP, mem.timeOffset, mem.showOnline,
         mg.onlineColor AS member_group_color, IFNULL(mg.groupName, '') AS member_group,
         pg.onlineColor AS post_group_color, IFNULL(pg.groupName, '') AS post_group,
         IF((mem.ID_GROUP = 0 OR mg.stars = ''), pg.stars, mg.stars) AS stars,
         mem.usertitle
      FROM members AS mem
         LEFT JOIN log_online AS lo ON (lo.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN attachments AS a ON (a.ID_MEMBER = mem.ID_MEMBER)
         LEFT JOIN membergroups AS pg ON (pg.ID_GROUP = mem.ID_POST_GROUP)
         LEFT JOIN membergroups AS mg ON (mg.ID_GROUP = mem.ID_GROUP)
      WHERE mem.ID_MEMBER IN ('313', '581', '684', '409', '322', '729', '928', '44', '75', '372', '253', '541', '11', '288', '138', '737', '765', '4', '397', '126', '673', '167', '487', '90', '425', '192', '917', '189', '341', '81', '596', '118', '668', '655', '449', '497', '95') in xx/xxx/Load.php line 475, which took 0.0058550834655762 seconds.

         SELECT *
         FROM themes
         WHERE ID_MEMBER IN (4, 11, 44, 75, 81, 90, 95, 118, 126, 138, 167, 189, 192, 253, 288, 313, 322, 341, 372, 397, 409, 425, 449, 487, 497, 541, 581, 596, 655, 668, 673, 684, 729, 737, 765, 917, 928) in xx/xxx/Load.php line 490, which took 0.0034677982330322 seconds.

         SELECT
            ID_MSG, icon, subject, posterTime, posterIP, ID_MEMBER, modifiedTime, modifiedName, body,
            smileysEnabled, posterName, posterEmail,
            (GREATEST(posterTime, modifiedTime) > 1126539006) AS isRead
         FROM messages
         WHERE ID_MSG IN (319,321,323,329,332,336,355,365,371,403,454,462,501,505,508,525,561,565,578,626,627,629,638,639,710,714,715,727,735,739,788,847,856,877,898,902,1016,1031,1041,1058,1089,1279,1378,1403,1404,1406,1451,1479,1500,1725)
         ORDER BY ID_MSG in xx/xxx/Display.php line 581, which took 0.003270149230957 seconds.

      SELECT c.name as catName, c.ID_CAT, b.ID_BOARD, b.name AS boardName, b.childLevel
      FROM boards AS b, categories AS c
      WHERE c.ID_CAT = b.ID_CAT
         AND 1
      ORDER BY c.catOrder, b.boardOrder in xx/xxx/Load.php line 1019, which took 0.00045919418334961 seconds.

      UPDATE log_activity
      SET
         hits = hits + 1
      WHERE date = 20050912
      LIMIT 1 in xx/xxx/Subs.php line 1640, which took 0.00083208084106445 seconds.

            SELECT code, filename, description
            FROM smileys
            ORDER BY LENGTH(code) DESC in xx/xxx/Subs.php line 1273, which took 0.0011970996856689 seconds.

               SELECT COUNT(*)
               FROM postmoderation in xx/xxx/Subs.php line 1771, which took 0.00047087669372559 seconds.

               SELECT *
               FROM banners
               WHERE ZONE IN ('top', 'bottom', 'main')
               ORDER BY rand() LIMIT 1 in xx/xxx/Subs.php line 2072, which took 0.00080704689025879 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00028204917907715 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00015997886657715 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00044608116149902 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0002589225769043 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00041294097900391 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00018596649169922 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00022292137145996 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00014090538024902 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00016689300537109 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011610984802246 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024914741516113 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012707710266113 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00023603439331055 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00017499923706055 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00016903877258301 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011682510375977 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00018906593322754 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012898445129395 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00020098686218262 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00014305114746094 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024294853210449 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0013728141784668 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0022480487823486 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0001680850982666 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0001828670501709 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011992454528809 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00025296211242676 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00021100044250488 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00026607513427734 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00014996528625488 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024890899658203 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00015783309936523 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024080276489258 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00017595291137695 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0002448558807373 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012707710266113 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00020599365234375 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0001220703125 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0002129077911377 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012421607971191 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00020599365234375 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012397766113281 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00025415420532227 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012898445129395 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024604797363281 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012803077697754 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024199485778809 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012707710266113 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00022482872009277 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012612342834473 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00020885467529297 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012397766113281 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00025200843811035 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00015091896057129 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00021004676818848 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00017309188842773 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00024509429931641 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00014209747314453 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00018405914306641 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0001380443572998 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00018596649169922 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.0001380443572998 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0001838207244873 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00013899803161621 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00019097328186035 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00013899803161621 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00019097328186035 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00014400482177734 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00022602081298828 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011992454528809 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00016880035400391 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011706352233887 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00018501281738281 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011706352233887 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00017094612121582 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00011706352233887 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0011239051818848 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00017285346984863 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00032186508178711 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00017881393432617 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00037598609924316 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00024700164794922 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.0011360645294189 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00029993057250977 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.001439094543457 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00013518333435059 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00021219253540039 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00012397766113281 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts ASC in xx/xxx/Display.php line 931, which took 0.00030303001403809 seconds.

      SELECT minPosts
      FROM membergroups
      ORDER BY minPosts DESC in xx/xxx/Display.php line 942, which took 0.00015091896057129 seconds.

               SELECT *
               FROM banners
               WHERE ZONE IN ('top', 'bottom', 'main')
               ORDER BY rand() LIMIT 1 in xx/xxx/Subs.php line 2072, which took 0.00039386749267578 seconds.



[xtremecruiser]

This seems to load over and over and over, and with a search I find nothing, maybe time for a ugrade asap


SELECT minPosts
FROM membergroups
ORDER BY minPosts ASC
in /home/gsc/public_html/yabbse/Sources/Display.php line 931, which took 0.00028204917907715 seconds.

id    select_type    table    type    possible_keys    key    key_len    ref    rows    Extra
1    SIMPLE    membergroups    index       minPosts    3       14    Using index

[xtremecruiser]

Here is a update, most of my spped is back but I still have 5X times the queries

here is a thread that "Unknown" chimed in and make a hack to help, but I am not sure about doing this
SMF Speed Up M1.0 x SMF

Maybe Unknown can chim in and help explain the issues.

I will be upgrading to 1.05 later tonight and then installing MK1.0 and testing it.

[Oldiesmann]

Uninstalling the Bar of Experience mod should make your query count go back to normal. That's what's causing all the additional queries.

[xtremecruiser]

Uninstalling the Bar of Experience mod should make your query count go back to normal. That's what's causing all the additional queries.

By completely removing MK I got my speed back, Thanks again for all the help
I am trying to get all the info from the MK guys, maybe this needs to be moved to the MK area and renamed so others can see about this issue with a update to MK 1.0

[Oldiesmann]

Bar of Experience is a seperate mod for SMF and has nothing to do with MKportal.

[xtremecruiser]

Bar of Experience is a seperate mod for SMF and has nothing to do with MKportal.

I know it is giving me more queries but the speed issues have been fixed by removing MK 1.0

I am doing a upgrade to 1.05 and that will whip all the mods out anyway after I get a good backup DL'd

Thanks again for all the help and tips !

[goitalone]

I need help too I think...can you show me what my problems are too?

I added the code and will be back in a few with the results

[goitalone]

Ok, here is my report:

Page created in 0.084 seconds with 24 queries.
Loading...

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.

[codenaught]

goitalone, do you still need help with this?