>I have rather big exe file 1.8Mb
>
>Among other things I have a grid witch shows a view of a table. This table have 610 records. And
>11 fields.
>This view have parameters.
>1 for employee
>9 for departments.
>
>In the form where the view is I have a listbox,
>where you can select witch employee you want
>to see.
>
>I use the IN (?dep1,?dep2.... in filter.
>In DE of the form I have PUBLIC dep1,dep2....
>
>The main app is on a 166Mhz Pentium with
>32MB ram running NT 3.51
>
>The workstation runs Win95 and is a
>486DX4/100Mhz with 8Mb RAM.
>
>My problem when I click a employee
>And the view is updatet it takes approx
>5 sec??
>
>What when my tables gets big???
>
>The dep part off the view is connected with
>witch dep. the user is responsible for.
>When the user is logged in, there is checking
>for this dep. in a dbf
>
>Best regards
>
>Per Simmersholm
Try setting up your view with no order or filter (essentially SELECT * FROM yourdbf )
Dont use filters on your table/view with an active tag/order, if you are concerned about speed