Prefix cache design may lead to data loss for large numbers of guilds #8
Description
The prefix cache uses TTLCache(maxsize=1000, ttl=3600) in bot/bot.py. If the bot joins more than 1000 guilds, some prefixes may be evicted from cache prematurely, leading to unnecessary database queries and possible performance issues.
Example Files:
bot/bot.py(prefix_cachedefinition and usage)
Recommended Actions:
- Assess and implement a scalable caching strategy for guild prefixes.
- Consider using an LRU cache with dynamic sizing or a persistent cache backed by Redis.