Welcome Guest, Not a member yet? Register   Sign In
CodeIgniter Forums Archived Discussions Archived Development & Programming Running a Query with in a foreach loop
Running a Query with in a foreach loop
  • El Forum
    Guest
  •  
#11
08-10-2009, 04:13 PM

[eluser]Phil Sturgeon[/eluser]
Look at the code a little closer.

Firstly, he needs a list of all projects.

Then he needs a list of all projects a user is involved with.

Finally he needs a list of all tasks for that project. You COULD join the two but it makes the looping a P.I.T.A and think about it, its not going to be that much data. If a user is involved with 10,000 projects then the slow performance will be an acceptable punishment for being such an idiot.

the only performance issue here would be the full list of projects for each user, but that is why the cache was invented. :-)


Messages In This Thread
Running a Query with in a foreach loop - by El Forum - 08-09-2009, 10:56 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 12:04 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 02:07 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 07:52 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:34 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:56 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 09:41 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 10:27 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 11:12 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 11:39 AM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 04:13 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 05:20 PM
Running a Query with in a foreach loop - by El Forum - 08-10-2009, 08:22 PM
Running a Query with in a foreach loop - by El Forum - 08-11-2009, 04:15 PM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 02:38 AM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 03:40 AM
Running a Query with in a foreach loop - by El Forum - 08-12-2009, 08:38 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:05 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:18 AM
Running a Query with in a foreach loop - by El Forum - 08-13-2009, 09:33 AM
Running a Query with in a foreach loop - by El Forum - 08-15-2009, 10:34 PM



Theme © iAndrew 2016 - Forum software by © MyBB