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

Fri, 19 February 2010 20:09

P_G_
Messages: 9
Registered: February 2010

Karma:

Junior Member

Certainly can, it is:

+----+-------------+-------+--------+-------------------------------------- ---------+---------------------------+---------+--------------------------- --+-------+---------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+--------+-------------------------------------- ---------+---------------------------+---------+--------------------------- --+-------+---------------------------------+
| 1 | SIMPLE | c | system | PRIMARY | NULL | NULL | NULL | 1 | Using temporary; Using filesort |
| 1 | SIMPLE | l | system | PRIMARY | NULL | NULL | NULL | 0 | const row not found |
| 1 | SIMPLE | f | const | PRIMARY,fud26_forum_i_c | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | g1 | const | fud26_group_cache_i_ru,fud26_group_cache_i_u | fud26_group_cache_i_ru | 8 | const,const | 1 | |
| 1 | SIMPLE | g2 | const | fud26_group_cache_i_ru,fud26_group_cache_i_u | fud26_group_cache_i_ru | 8 | const,const | 0 | unique row not found |
| 1 | SIMPLE | t | ref | PRIMARY,fud26_thread_i_flm,fud26_thread_i_rmi | fud26_thread_i_flm | 4 | const | 15724 | |
| 1 | SIMPLE | r | eq_ref | fud26_read_i_tu,fud26_read_i_u | fud26_read_i_tu | 8 | cardiffonline.t.id,const | 1 | |
| 1 | SIMPLE | m | ref | fud26_msg_i_ta,fud26_msg_i_ps,fud26_msg_i_a | fud26_msg_i_ta | 8 | cardiffonline.t.id,const | 9 | Using where |
| 1 | SIMPLE | u | eq_ref | PRIMARY | PRIMARY | 4 | cardiffonline.m.poster_id | 1 | |
| 1 | SIMPLE | p | eq_ref | PRIMARY | PRIMARY | 4 | cardiffonline.m.poll_id | 1 | |
| 1 | SIMPLE | pot | eq_ref | fud26_poll_opt_track_i_pu | fud26_poll_opt_track_i_pu | 8 | cardiffonline.p.id,const | 1 | |
| 1 | SIMPLE | mm | const | fud26_mod_i_uf | fud26_mod_i_uf | 8 | const,const | 1 | Using where |
| 1 | SIMPLE | m2 | eq_ref | PRIMARY | PRIMARY | 4 | cardiffonline.t.root_msg_id | 1 | |
+----+-------------+-------+--------+-------------------------------------- ---------+---------------------------+---------+--------------------------- --+-------+---------------------------------+

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: Sun Nov 24 05:29:08 GMT 2024

Total time taken to generate the page: 0.04274 seconds