[repute]

I'm having much trubbles with this on a bussy website please help me ...

[xiesi]

What host are you used?

[repute]

Originally Posted by xiesi

What host are you used?

My own dedicated nothing changed sinds the index was added using php 5 mysql 5.0.27-standard-log

Thanks for helping me!

[Naranja]

can i add an index on categories too? i have 250+ categories and growing up day by day

How can i add an index in categories?

[catchpen]

Does the "type" in the newly added column need to be edited after adding this?
Mine showing: enum('discard', 'queued', 'published', 'abuse', 'duplicated')
The other link indexes have only VARCHAR or init(20) or something

Just wondering because it looks different than the others, sorry I don't spend much time in MySql

thanks.

[bluetv]

Set query_cache_size=256M at my.conf

[pentupentropy]

Originally Posted by Rodney

I don't think a dedicated IP will help in performance at all.

The only way that could possibly help is if you had hundreds of domains pointing at it in your own enclosure setup where you controlled the NS and you could configure bind a little differently. I don't think this is the case with anyone.