+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Archived Discussions (https://forum.codeigniter.com/forumdisplay.php?fid=20)
+--- Forum: Archived General Discussion (https://forum.codeigniter.com/forumdisplay.php?fid=21)
+--- Thread: Help with SELECT statement (/showthread.php?tid=20969)
Pages:
1
2
Help with SELECT statement - El Forum - 08-05-2009
[eluser]bgreene[/eluser]
single select with join. i rarely use select from where x in (select x from where). if your table is big and a join is slow, check you have an appropriate index on the table eg on downtime table you'd have an index on eventid (key), deviceid and componentid