Re: database performance problem

2008-01-30 Thread [EMAIL PROTECTED]
On Jan 30, 1:33 pm, Thomas Guettler <[EMAIL PROTECTED]> wrote: > > def markable(checkins, project_category): > > projects = project_category.projects.all() > > res = [] > > for day in checkins.group_dates(): > > for ci in day: # for every checkin that day > > if

Re: database performance problem

2008-01-30 Thread Thomas Guettler
> def markable(checkins, project_category): > projects = project_category.projects.all() > res = [] > for day in checkins.group_dates(): > for ci in day: # for every checkin that day > if ci.project in projects: # <-- HERE > res.append(day.date) >

database performance problem

2008-01-30 Thread [EMAIL PROTECTED]
I'm developing a time-tracking app, and I've run into some performance issues.. In my models I have that a Project (e.g. "customer A, research") can be a member of a ProjectCategory (e.g. "customer A"), and that each work-unit (Checkin) includes who worked, when they started, when they stopped and