What are your suggestions for getting fast results in a large database?

Hello ,

There is a project I have done with dmxzone plugins before. and now i plan to do this again with wappler. The project has been running for a long time. I have a problem with this project and this issue is not related to dmxzone.

This project takes orders over the phone and sends an order to the relevant branch, so you can think of it as a call center. As the number of orders and users increase every day, the data from the database slows down and there are problems related to slowness.

The project does not contain long and complex mysql queries that will cause this slowdown. I created the simple calculations on the client side and wrote the result to the database. So I know that database planning is important and there may be a problem due to incorrect database planning.

I think I need to find an elastic search or something similar solution. Or are there any other ways you would suggest?
Also, will a useful development like elastic search be in wappler?

Your suggestions are important to me.
@wappler_ambassadors , @George , @patrick , @Teodor

Community Page
Last updated: