FUDforum: How To » fud

Home » FUDforum » How To » fud_index

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

Re: fud_index [message #160122 is a reply to message #160090]

Tue, 28 July 2009 11:07

remek

Messages: 34
Registered: August 2005
Location: Poland

Karma:

Member

Next observations came to me Smile

SELECT SUM(length) FROM fud_pmsg WHERE duser_id=782

execution time -> 4.7708

In MyPhpAdmin I noticed:

PRIMARY PRIMARY 63533
- id

fud_pmsg_i_dfr INDEX 63533
- duser_id
- fldr
- read_stamp

fud_pmsg_i_dfi INDEX 63533
- duser_id
- fldr
- id

for column `INDEX` was created many indexes

Should I fix it?

Report message to a moderator

[Message index]

		fud_index By: remek on Thu, 23 July 2009 14:51
		Re: fud_index By: naudefj on Thu, 23 July 2009 15:22
		Re: fud_index By: remek on Thu, 23 July 2009 17:12
		Re: fud_index By: remek on Thu, 23 July 2009 17:20
		Re: fud_index By: naudefj on Thu, 23 July 2009 19:07
		Re: fud_index By: remek on Thu, 23 July 2009 20:53
		Re: fud_index By: naudefj on Fri, 24 July 2009 05:40
		Re: fud_index By: remek on Tue, 28 July 2009 11:07
		Re: fud_index By: naudefj on Tue, 28 July 2009 15:10

Previous Topic:	The availability of IP addresses to regular users
Next Topic:	Is it possible to block users from posting

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 00:03:26 GMT 2024

Total time taken to generate the page: 0.04684 seconds