Re: Hierarchical recordsets

2002-01-25 Thread DL Neil
Hi Jon, > I have a query that is returning 15 records per page. For each record, I > may do up to 2 subselects - this is done by issuing seperate queries inside > the 15 record recordset (depending on the level of detail chosen by the > user). The problem is that things slow down quite a bit wh

Hierarchical recordsets

2002-01-25 Thread Jon Wahl
Hi all, I have a query that is returning 15 records per page. For each record, I may do up to 2 subselects - this is done by issuing seperate queries inside the 15 record recordset (depending on the level of detail chosen by the user). The problem is that things slow down quite a bit when doing