Sub Menu
Links Menu
Online Users

In total there are 128 users online :: 2 registered, 0 hidden and 126 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Majestic-12 [Bot] based on users active over the past 60 minutes

Resolved: Slow Query (1000+ seconds)

Support for IntegraMOD 140

Moderator: Integra Moderator

Resolved: Slow Query (1000+ seconds)

PostAuthor: Oracle_SOD » Mon Jul 17, 2006 7:31 pm

our site has 7000+ users and 500000+ posts

we have just moved to integramod (granted we are using phpbb v.20.17)

the following query kills the site on numerous topic id's

[code]# Query_time]

does any one know why this would be happeing an of a way to resolve the issue...

this code is run when a user loads viewtopic.php?t=******

but the issue is only with a few threads... normaly its fine.... but the number of threads seams to be increasing and we are not sure what is causing this

any ideas ?
Last edited by Oracle_SOD on Mon Jul 17, 2006 8:31 pm, edited 1 time in total.
Image
-=Quote=-
The person who says it cannot be done should not interrupt the person doing it.
User avatar
Oracle_SOD
Newbie
Newbie
 
Posts: 21
Likes: 0 post
Liked in: 0 post
Joined: Thu Jul 13, 2006 2:45 pm
Cash on hand: 0.00

PostAuthor: Oracle_SOD » Mon Jul 17, 2006 8:30 pm

Problem solved

we have disabled this code now that i worked out what it actualy does, site is rather quicker to use...

some more tweeking in my.cnf will make it very quick
Last edited by Oracle_SOD on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Image
-=Quote=-
The person who says it cannot be done should not interrupt the person doing it.
User avatar
Oracle_SOD
Newbie
Newbie
 
Posts: 21
Likes: 0 post
Liked in: 0 post
Joined: Thu Jul 13, 2006 2:45 pm
Cash on hand: 0.00

PostAuthor: Adrian Rea » Fri Jul 28, 2006 7:31 am

very impressive stats. I do not have a laser but it does show that IM can work on larger boards. It is a touch slow on loading, And I am not sure if that is the db or the server issue. But nice stats all the same <img>

A
Last edited by Adrian Rea on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
Adrian Rea
Sr Integra Member
Sr Integra Member
 
Posts: 1263
Likes: 0 post
Liked in: 0 post
Joined: Sat Mar 11, 2006 11:59 pm
Cash on hand: 0.00

PostAuthor: Oracle_SOD » Sun Sep 17, 2006 9:43 pm

thankx muchly :)
Last edited by Oracle_SOD on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Image
-=Quote=-
The person who says it cannot be done should not interrupt the person doing it.
User avatar
Oracle_SOD
Newbie
Newbie
 
Posts: 21
Likes: 0 post
Liked in: 0 post
Joined: Thu Jul 13, 2006 2:45 pm
Cash on hand: 0.00

PostAuthor: binh.tang » Sun Feb 10, 2008 12:41 am

I think this is the root of my problems as well.

Oracle_SOD, I see you are banned, so I don't know if you will ever replyto this topic.

Can you please tell me what you did and what code you removed to improve the speed issue?

Thanks,
Binh
Last edited by binh.tang on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
User avatar
binh.tang
Members
Members
 
Posts: 43
Likes: 0 post
Liked in: 0 post
Joined: Tue Feb 06, 2007 12:11 pm
Cash on hand: 0.00

Re: Resolved: Slow Query (1000+ seconds)

PostAuthor: sethshawn » Thu Apr 28, 2011 3:17 am

My root problem solved just due to this very informative forum post.
Regards
Shawn

sethshawn
Newbie
Newbie
 
Posts: 1
Likes: 0 post
Liked in: 0 post
Joined: Thu Apr 28, 2011 3:13 am
Cash on hand: 0.00


Return to IntegraMOD 140

Who is online

Registered users: Bing [Bot], Majestic-12 [Bot]

cron