+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5)
+--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24)
+--- Thread: Performance boost CI3 (/showthread.php?tid=78725)
Pages:
1
2
RE: Performance boost CI3 - muuucho - 03-07-2021
(03-06-2021, 12:32 PM)iRedds Wrote: Be careful. The proposed option can play a cruel joke with you.Thanks, actually in my case it is only "d" that has different values, "id" is the same inside each loop, e.g. for all 4 queries.
This request can be written as
Code:SELECT *
FROM table
WHERE
(id = 1 AND (d = 20 OR d = 21 OR d = 22 OR d = 25))
OR (id = 2 AND (d = 20 OR d = 21 OR d = 22 OR d = 25))
OR (id = 3 AND (d = 20 OR d = 21 OR d = 22 OR d = 25))
OR (id = 4 AND (d = 20 OR d = 21 OR d = 22 OR d = 25))
OR (id = 5 AND (d = 20 OR d = 21 OR d = 22 OR d = 25))
Depending on the logic of your database, this may conflict with the conditions.
https://www.db-fiddle.com/f/ckHvgzVN2u8a1dtv7GoNMZ/0
Perhaps you'd better use UNION
RE: Performance boost CI3 - php_rocs - 03-09-2021
@muuucho,
I'm glad the suggestion worked for you. How much faster did the change make it?
RE: Performance boost CI3 - muuucho - 03-09-2021
(03-09-2021, 09:53 AM)php_rocs Wrote: @muuucho,Well, I did some other small improvements at the same time and I almost halved the execution time, I am sure most of that cut came from the IN trick. Thanks!
I'm glad the suggestion worked for you. How much faster did the change make it?
RE: Performance boost CI3 - php_rocs - 03-09-2021
@muuucho,
Awesome!! Sure, your welcome. I'm glad that I could help.