ABOUT

All gigs provided end to end solution for conducting any kind of Gig(Event ). You can select from the various vendors available and plan an event of any size. Plan a birthday party, plan a wedding or plan a seminar, book a speaker easily and conveniently . Your budget is kept in mind and you are matched with the best possible vendor within your area or all over Australia.

CHALLENGES

Thanks to the overwhelming response to the website because of our SEO strategies, there were many vendors signing up which was causing an issue in the search function as the database was very large. Due to the size of the database the searching functionality was taking a lot of time to display the results which in turn caused increased of the bounce rate of the website. The current Database was MY SQL which didn’t do the required job.

SOLUTION

We proposed to change the MY SQL database to a database which doesn’t use joins .Mongo Db was suggested by our development team as the best possible solution. We migrated the current database to Mongo Db. We also implemented Haversine formulae to create a look up of a nearest vendor in a given location based on its latitude and longitude. We also implemented replication and scaling of data as a source of backup to fix the issue of displaying the vendors quickly. We also created a datastore by following the repository pattern and also we followed the principle of SOLID.

RESULTS

We were successful in implementing Mongo Db and the searching time was considerably improved and the results were displayed quickly and efficiently. There was an overall improvement of 90% in the speed of the search function to display results once the database was transferred to Mongo DbThis also helped with the SEO and over all user experience of the website.