I have a project with a few Codeigniter Mysql queries I need to change / optimize . Some of them are models that will need to be converted to RAW format .
Your job will be :
1- Optimizing existing queries for maximum efficiency and removing unnecessary operations that affect performance
2- Adding proper indexes to each query
3- Identify bottleneck issues with existing queries and change them accordingly
You need to have both experience with Codeigniter Queries, not just the simple ones , and experience with MysQL optimization with understanding how to use EXPLAIN and other mysql tools that can help you evaluate the performance of each query .