Optimize emote stats queries

Misha12 / GrillBot

Discord bot with features primarily for VUT FIT discord guild.

https://git.grillbot.cloud/

MIT License

5 stars 5 forks source link

Closed Misha12 closed 3 years ago

Misha12 commented 3 years ago

On VUT FIT discord server:

Takes more than 2 secs (+- 90 000) records.
SSMS Reports are freezed, because queries are long (more than 1000 User IDs in SQL query).

Misha12 commented 3 years ago