Difference with the previous random lookup functions
Description
The previous random lookup methods in service(GetRandomUserInfo and GetRandomGuildInfoV3) have the following issues:
- Tends to use a large amount of DB during random lookup
- Response is slow during random lookup
- Increased DB usage and delayed response speed with more data
To resolve such issues, new random lookup functions have been developed.
The new random lookup functions will not automatically include data or provide table information like the existing versions. However, significant improvements have been made to its DB usage and response speed, and it enables the insertion and deletion of desired data.
Differences
| Old Version | New Version | |
|---|---|---|
| Response speed | Slow(takes 1 sec or more on average) | Fast(takes no more than 0.5 sec on average) |
| DB usage | Large Increases according to the size of data | Small Does not increase according to the size of data |
| Data insertion | Automatically included in the random range upon inserting game information DB | Desired data can be inserted |
| Data lookup | Looks up from all the data in the game information management table | Looks up only the necessary values from the table exclusive for random lookup |
| How the gap is used | Looks up by increasing/decreasing scores according to the gap based on the score | Looks up by increasing/decreasing placements according to the gap based on the rank |
| Deletion method | Deletes the row | Uses the random lookup data deletion method |