Optimize db query |
Hi,
Not sure what much to optimize here $this->db - is basically a service, so real DB connection is called only once. Many queries will not make multiple DB connections I can't see unions and joins here and even if so - they would not make DB responses faster Sugestions: - try using objects instead of arrays. Objects simply work faster - use models - use entities and model returns (entity will return as object by default) - https://codeigniter4.github.io/CodeIgnit...ities.html - i would optimize controller code, something like this PHP Code: class ServiceController extends Controller |
Messages In This Thread |
Optimize db query - by Johnny Stec - 10-20-2022, 12:52 AM
RE: Optimize db query - by encodedigital - 10-20-2022, 02:27 AM
RE: Optimize db query - by davis.lasis - 10-20-2022, 01:16 PM
|