>What determines the speed of a parameter view? I have a form with a pview based grid. The pview is a simple:
>select * from DETAIL where ID = ?pID
>
>In the Form.MoveRec() method there is something like:
>pID = MASTER.ID
>requery(grid.Recordsource)
>gird.refresh()
>
>MASTER has some 3,000 records and DETAIL 100,000
>
>It takes 25 seconds to requery the grid!
>
>If I change the grid to use the traditional approach, linking both tables directly, there is no apparent delay when changing records in MASTER.
>
>Both tables are properly indexed, have no relations set and no triggers.
>
>What am I missing?
>
>TIA
>
>Silvio
How many records are being returned in the result set?
Erik Moore
Clientelligence