I have a large database that is called very frequently.
it is growing very fast and now has over a million entries.
my requests take 30 seconds and i need them down much faster
i have some indexes on the database but i don't understand them very well.
i would provide access to a git repository of a cakephp project and a dump of the database for you to get running and work on locally.
then you would need to make updates and optimizations and explain what was changed and how i can go about doing it on my local version and later live version.
this could be done in git making a fork request or explaining manually.
25 freelancers are bidding on average €188 for this job
Optimization expert here, normally for that many rows is convenient to other approachs, let me know about your database, which table is having that many rows and what is the use of that table on your script. Jose
Please provide some more details (your environment, use cases, queries, etc.) so then I could estimate time and effort needed for this task and adjust my bid accordingly.