How to optimize Uploads table ?

4 posts by 2 authors in: Forums > CMS Builder
Last Post: July 29, 2014   (RSS)

By claire - July 28, 2014

Hi Djulia

You could also add an index to the recordNum column.

Please be aware, though, that adding indexes is pretty intensive, depending on the number of records, and it could slow your server down a lot until it's done.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By Djulia - July 29, 2014

Hi Claire,

I also have some Slow with the Hidden field. I think that the use of an index would be pointless.
ANALYSE() recommends to use a type ENUM. This kind of field seems to behave like an index...

Do you have an opinion?

Thanks again!

Djulia

By claire - July 29, 2014

Hi Djulia

Normally I'd start running through a few test queries in the database itself, using EXPLAIN to check what indexes are being used and how many records are being searched.

Honestly, there isn't any one solution to database optimization, so the best thing to do is to copy your database locally, and try a few different approaches to see which gives you the biggest boost to speed.

--------------------

Claire Ryan
interactivetools.com

Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/