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 #165791 is a reply to message #161906]

Thu, 11 August 2011 14:23

eclipsewebmaster

Messages: 46
Registered: November 2009
Location: Ottawa, Ontario, Canada

Karma:

Member

naudefj wrote on Fri, 19 February 2010 14:58

PS: This query looks all too familiar. I've tried to "tune" it before, but was unable to get it any faster.

I've posted another thread about this.

http://fudforum.org/forum/index.php?t=msg&th=120085&unread=1&

This query is part of the "Unanswered Messages" features. I don't think you'll be able to optimize this query any further. To make matters worse, no matter how aggressively you tune MySQL's buffers, it will more than likely create a rather large tmp table on disk.

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 19:34:04 GMT 2024

Total time taken to generate the page: 0.04290 seconds