How to optimize Uploads table ?

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

By Djulia - July 25, 2014


Our MySQL server records much request slow on the Uploads table.

I will want to know if somebody had optimized the approach.

I thought of adding an INDEX on the tableName column.

Would somebody have another suggection?



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

Save time by getting our experts to help with your project.

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!