FUDforum: Database discussions » Query taking 2 minutes

Home » General » Database discussions » Query taking 2 minutes (Board grinds to halt for that period of time)

Show: Today's Messages :: Polls :: Message Navigator

Re: Query taking 2 minutes [message #161936 is a reply to message #161920]

Mon, 22 February 2010 10:57

P_G_
Messages: 9
Registered: February 2010

Karma:

Junior Member

Okay, after having a play around with a few things, I have the query down to between 10 and 18 seconds (from between 90 and 120), ending up with doing the following:

- ALTER TABLE fud26_thread ADD INDEX fud26_forum_thread (forum_id, id), and;
- adding "FORCE INDEX (fud26_forum_thread)" AFTER "INNER JOIN fud26_thread t" on line 815 of fudforum/theme/default/selmsg.php.

It's obviously a lot better, but still not perfect, so hopefully it is something you can improve on further?

I also assume that this is something called upon while in the admin panel only. What task actually runs this statement, and are we perhaps able to avoid it at all?

Cheers
P_G_

Report message to a moderator

[Message index]

		Query taking 2 minutes By: P_G_ on Fri, 19 February 2010 15:33
		Re: Query taking 2 minutes By: naudefj on Fri, 19 February 2010 19:58
		Re: Query taking 2 minutes By: P_G_ on Fri, 19 February 2010 20:09
		Re: Query taking 2 minutes By: naudefj on Fri, 19 February 2010 20:54
		Re: Query taking 2 minutes By: P_G_ on Sat, 20 February 2010 12:54
		Re: Query taking 2 minutes By: naudefj on Sun, 21 February 2010 00:08
		Re: Query taking 2 minutes By: P_G_ on Mon, 22 February 2010 10:57
		Re: Query taking 2 minutes By: naudefj on Mon, 22 February 2010 16:06
		Re: Query taking 2 minutes By: P_G_ on Mon, 22 February 2010 17:18
		Re: Query taking 2 minutes By: naudefj on Tue, 23 February 2010 19:19
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 10:34
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 11:23
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 11:25
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 12:01
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 12:04
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 12:21
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 12:30
		Re: Query taking 2 minutes By: naudefj on Wed, 24 November 2010 12:47
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 13:35
		Re: Query taking 2 minutes By: Ernesto on Wed, 24 November 2010 13:41
		Re: Query taking 2 minutes By: eclipsewebmaster on Thu, 11 August 2011 14:23
		Re: Query taking 2 minutes By: naudefj on Mon, 17 October 2011 10:03

Previous Topic:	Cannot connect to database
Next Topic:	Has anyone tried to use this w/SQL Server 2000

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 27 22:57:49 GMT 2024

Total time taken to generate the page: 0.04276 seconds