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
Hi,
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?
Thanks!
Djulia
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/