> Also will it possible for me put filters on table 1(say Employees) and> then
> perform join with other tables?
I'm not sure. I think it's more like join then filter.
Something like below...
query = (db.person.id==db.dog.owner) & (db.person.name.like('Omi%'))
rows = db(query).select()
On Feb 9, 8:53 am, Sonal_b <[email protected]> wrote:
> Thanks Omi.
>
> I will give it a try.
>
> Also will it possible for me put filters on table 1(say Employees) and
> then perform join with other tables?
>
> On Feb 9, 7:34 pm, Omi Chiba <[email protected]> wrote:
>
>
>
>
>
>
>
> > Sound like you're looping all the records to connect different table.
> > I use join for the purpose and working fine though I only have about
> > 10000 records.
>
> >http://www.web2py.com/books/default/chapter/29/6?search=join#Inner-joins
>
> > On Feb 9, 8:19 am, Sonal_b <[email protected]> wrote:
>
> > > I have to query 3tableswhich contains large number ofdata
>
> > > I have to come up with report which displays
>
> > > Employee Firstname, Lastname, Manager's FirstName, Manager's Lastname
> > > and Organisation name.
>
> > > Table Structure/Details:
>
> > > 1. Employee table: which contains employee information(First name,
> > > lastname), Organisation id and manager's id.
> > > 2. Manager Table: Which contains firstname, lastname etc.
> > > 3. Organisation table: which contains organisation's name.
>
> > > The process i follow is:
> > > 1.Fetchall the employees
> > > 1.a for each employee get the manager id
> > > 1.b For the manager id get the manager's firstname and
> > > lastname by querying the Manager table
> > > 1.c for each employee get the organisation id
> > > 1.d For each organisation id get the Organisation name by
> > > querying the Organisation table.
>
> > > When I try tofetchthe records from 3tablesfollowing the above
> > > approach, I get deadlineexceedederror as my request could not complete
> > > in 30 seconds time.
>
> > > Please suggest a betterwayto do this. Also what should i use which
> > > can improve performance and also get me the result in the 30 second
> > > timeframe.
