mysql good way of programming

Question

i have the video gallery in my database, which has over 200 000 videos. in my home page in the site i show exactly some videos, which must satisfy to some criteria. and so, what is the question. is it a good way to sort videos every time the home page opene, or i must save the sort results somewhere in the database, and refresh them only if something change. i think it can save me a lot of time. what you think about it. thanks in advance.

Answer 1

do any optimizations steps only when you have troubles with performance. until the troubles appeared - just hold breath and monitor performance statistics.

Answer 2

If the sort operation is expensive, do it at intervals or on specific triggers, otherwise do it dynamically

Answer 3

Sort videos every time the page opened. Database were invented intentionally to do such things.

Answer 4

You should let the database sort the data!!! If the table is set up correctly it shouldn't be much overhead!!! You can also look into query caching which can do some of what you are thinking of doing for you!!! I was very excited to answer this question!!!