10,000多个不同的文件，我需要每5秒抓取4个文件？

Question

I have a database of 10,000+ different files and I need to grab 4 random ones out of that database every 5 seconds.

I am wondering what are you suggestions for architect. I am thinking of using a flat file or maybe a sqlite? Doing this via mysql would be very very slow?

Answer 1

Just a Generalized Approach Running The selectRandom() procedure every 5seconds will be too messy. instead run selectRandomGroups() every 120 seconds.

selectRandomGroups() executes selectRandom() 120/5 times in every execution. and stores the resulting groups in some storage (cache).

next use grabRandomGroup() every 5 seconds that retrieves the last Group from the cache.and remove it.