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 #161908 is a reply to message #161907]

Fri, 19 February 2010 20:54

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

OK, the slow-down is probably caused by fetching 15724 rows from fud26_thread. MySQL uses the thread_i_flm index (which is probably not selective enough).

Looking at the query, candidate keys would be:

* id
* root_msg_id
* forum_id
* last_post_date (in ORDER BY)

Existing indexes:

* PRIMARY (id)
* thread_i_flm (forum_id, moved_to) <-- use for leading col.
* thread_i_t (thread_opt)
* thread_i_rmi (root_msg_id)
* thread_i_r (replies)

Will you be able to create some indexes to see it they will help?

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: Sat May 11 11:53:30 GMT 2024

Total time taken to generate the page: 0.04874 seconds