We are building a recommender engine to be integrated in an app that, each time an API is called, will pull thousands of records from an Azure SQL database and create recommendations. Currently with Azure, the time taken to query thousands of records is slow (several seconds). Is there any way to improve this speed? Is another database provider such as GCP faster in this case? Thanks

  • $\begingroup$ most probably you need to change the architecture of the data in database, for example exploring graph databases or nosql databases. The first are specialised in handling multiple connections between data and the latter are very fast $\endgroup$ – Nikos M. Jul 25 '20 at 8:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.