Closed arroyoDev closed 6 years ago
The easiest way would probably to have it hit a cache backend like redis? Even if you store it in another table, you're going to have contention with it pulling from the database. This would allow the list to be updated with a separate job running every so often and the footprint for the cache should be pretty small.
This rolling list of Volunteer Organizations is 1000 plus and growing. I want it to cycle through in random order, but not bog down anything. right now it is just a few statically loaded. It needs to pull from the whole is of VERIFIED organizations.
It's located on the bottom of the map page.