How to optimize Uploads table ?

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.

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

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.