📢 Tech Update
Core focus is currently on improving speed to meet BetRadars performance requirements for their Managed Trading Service & Live Odds Integration.
Works being conducted include:
- Implementing Kafka queue to process messages for multiple fixtures simultaneously
- Code refactoring to handle messages for independent processes in parallel
- DB-level and query optimization:
a. Aggregating related tables to one table: when writing data from one message, only one table needs to be queried and written to.
b. Indexing tables for LO, which will improve the performance of queries to these tables
c. Grouping multiple queries in a process to one single query
d. Use Cache: get data which has been processed recently instead of fetching data from the server
- Optimize socket (changes that you see on screen without refresh are from sockets) and forward messages from BR directly to FE
a. Create rooms for sockets and only send sockets for registered rooms to client
b. Data will be processed at BE and sent to FE (UI) at the same time
The current goal is to have live odds integrated and testing on EarnU by the 19th - 26th of July.