Our client is a real estate search engine in Canada. It offers estate listing for sale and rent from all over Canada. Data from different sources is fed into database. This data has 200+ associated attributes like city, state, address, location, rooms and other information about estate.
Due to volume of data the insertion in database was very slow. We provided consultancy to redesign database for optimized storage of the data. We also implemented parallel import of data so data can be imported in less time. After optimizing the import process we replaced mysql based search with Sphinx Search. Searching for address and enabling filtering on so many attributes was challenging and was not possible wihtout Sphinx Search. It made the search faster, more accurate and scalable. We implemented delta indexing to minimizing indexing load on database.