Enhance Large SQL Database Performance
Budget: £250 – £750 GBP
I am seeking a seasoned SQL expert to analyse, clean up and optimise my large SQL database, which is over 5GB. The database has more than 100 tables and is experiencing performance issues.
Ideally, you will have:
- Proven expertise in SQL optimisation techniques
- Experience in dealing with large databases
- Practical knowledge to handle complex database with extensive tables
Current Issues:
- Slow query response
- High CPU usage
- Our shopping cart back office operations are slowing down due to these issues
Your task would be to identify, and optimise the database to enhance the speed and efficiency, resulting in efficient business operations. I look forward to your proposals.
The shopping Cart is Prestashop 1.6.24 one of the table = 95% of the entire SQL database by all accounts this is a known issue with the core of the software from what im reading most of the entries are junk, its taken 13 years to get to this position so im presuming a good clean up and optimise maybe even an update will do the job.
Ideally, you will have:
- Proven expertise in SQL optimisation techniques
- Experience in dealing with large databases
- Practical knowledge to handle complex database with extensive tables
Current Issues:
- Slow query response
- High CPU usage
- Our shopping cart back office operations are slowing down due to these issues
Your task would be to identify, and optimise the database to enhance the speed and efficiency, resulting in efficient business operations. I look forward to your proposals.
The shopping Cart is Prestashop 1.6.24 one of the table = 95% of the entire SQL database by all accounts this is a known issue with the core of the software from what im reading most of the entries are junk, its taken 13 years to get to this position so im presuming a good clean up and optimise maybe even an update will do the job.