Our client is a eCommerce store which has catalog of about 100,000 products. The store is based on Magento and uses MySql as RDBMS. The store was using full text and LIKE to find matching products. For attribute filters GROUP BY sql queries were being used which was putting a lot of load on servers [...]
ELK implementation for Cisco & Huawei Firewall logs
Waseem2020-05-04T10:51:43+00:00We implemented ELK (Elasticsearch, Logstash, Kibana) to analyze logs from Cisco and Huawei firewalls. We consumed the logs in real time using Logstash and after some processing and normalization we stored it in Elasticsearch for analysis. Also implemented an Kibana dashboard to visualize the data for different events and other details. It helped our client [...]
Elasticsearch for Ads Clicks Recording
Waseem2020-05-04T10:52:29+00:00Our client is an ads distribution agency. The receive millions of clicks on daily basis on their ads. Click recording stats are very important for the business and it needs to be presented to advertisers and calculation of RoI. On advertiser dashboard different aspects of clicks were presented in charts. As all this data was [...]
Solr Implementation for eCommerce store
Waseem2020-05-04T07:56:48+00:00Our client is a eCommerce store which has catalog of about 300,000 products from different vendors. The website is based on .Net and uses MS SQL Server as RDBMS. The website was using MS SQL full text and LIKE to find matching products. For navigation based on different product attributes and categories GROUP BY queries [...]
Solr Performance Optimzation for Business Directory
Waseem2020-05-04T07:58:35+00:00Our client is largest business directory of Nigeria. It offers more than 1,000,000 business listings from the region. Solr was already in place for search but there were some performance issues being faced. Our team helped the website to fix these performance issues by modifying schema, server settings and search queries. Result of these efforts [...]
Solr Performance Optimization for Classified Ads Portal
Waseem2020-05-04T08:00:11+00:00Our client is large classified ads portal in Pakistan. It has more than 1,000,000 active ads and more than 200,000 daily page views. When we were reached by client, Solr was already in place for searching and navigation. It was having performance issues in queries and indexing. Solr used to crash frequently due to these [...]
Sphinx Search Optimization for Video On-Demand Platform
Waseem2020-04-30T11:42:58+00:00Our client is one of the largest freely available Video On-Demand & Pay-per-view library. The client already had Sphinx Search implemented for the content search, but it was not performing to its full potential. There were multiple issues in search relevancy and indexing performance. Sphinx and db servers were hosted on AWS EC2 Our team [...]
Solr Implementation for WordPress
Waseem2020-05-04T08:01:50+00:00Our client is a online community to share lasting side effects from pharmaceuticals and provide support platform to support patients and promote awareness. The website is based on wordpress and has thousands of articles and growing number of discussions. The website uses BBPress and BuddyPress plugins to enable discussions and social networking. The site was [...]