Replacing relational databases with search engines for simple lookups

One of the things we often notice about existing systems based on relational databases (RDB) is that as they scale to millions of items, simple lookup tasks become slow and inefficient. These tasks don't usually require complicated database operations, so in most cases it is possible to relocate the data from the RDB into a search engine like Flax. Consider a system where a search engine has already been implemented to search textual product information, but numerical data on each product, such...Continue reading