General information
Category:
Forms & Form designer
This is a wild ass guess, since it's not obvious why it wouldn't be rushmore optimized, but have you checked sys(3054,11) to see if it gives you more information?
HTH
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only