I want fetch data from mysql with Faster Speed.
because Currently in my database are large. 30 - 40 laks row in table.
now i am face issue only single table. because in this table total row in 30-40 laks. and data fetch time 20-30 sec.
so if you decrease this speed. kindly contact me.
Rajesh Saini , (removed by admin)
NOTE: if you are using any code like: PHP, JSON.
20 freelancers are bidding on average ₹1029/hour for this job
please do share the DB table metadata ( columns , Pk and indexes and Queries u use to retrieve data) it mostly is due to non indexed queries. or your presentation layer logic of the application is too complex
I am good in MySql. I know how to solve this issue. If you can provide us some more details this will help us to resolve this issue. I have some methods to solve this. But this depends on how you are fetching from DB.