BestSpotBet

The BestSpotBet portal was launched Jan 7, 2011 and very soon it became very popular.

BestSpotBet Comparison provides the latest betting odds for all football/rugby matches, horse racing across the world from the leading bookmakers. It is a realtime system so the development team has been able to provide a technical solution that was up to the challenge.

Task

To implement search engine, synchronize odds collections via pusher.com, integrate external BB2 system, apply many mathematic algorithms, apply caching technics, multi domains.

Challenge

• use an one field for searching to show definite entries of the search queries using various output templates results;
• quick generation of pages that contain dynamic and static data.
• to show increase/decrease of odds in real time mode.
• improve perfomance.

Solution

Sphinx is used as search engine. Millions rows from each db table are combined into one big db view, sphinx uses this db view for its index. Our team have created many search patterns for it, so we know what type of template we have to use.

To ensure stable and efficient work under heavy and peak loads we have used the memcache technology, which is a general-purpose distributed memory caching system that allows speeding up dynamic database-driven websites by caching data and objects in memory to reduce the number of times the database must be read.

In background, BestSpotBet communicates with pusher.com and knowd about all open users’ pages, so each time system sends to pusher.com new data. In turn, pusher.com notifys all users’ browsers through listener on site, in this way users could know about all changes of odds in real time mode.

Minimize the number of database queries, minified javascript files, css, minimize number of calls to server, grade B by YSlow. emset is used.