>hello,
>
>I have 2 occasions where I have a much slower grid ( and I know that I've done this before without a problem, but... )
>
>1. filters
>??? slow slow slow ( only ~20 records on test table )
>
>2. DynamicBackColor
>not sure why, there are only 2 iif() and 1 rgb() in the string, and only 20 records in the test cursor driving the grid.
>
>It's the same base table that drives these two problems. The filtered grid is a modal form that will always be spawned from the form with the DynamicBackColor, if that makes any differance.
>
>ideas?
>
>- jer
1. Filters
Be sure your filter does not conflict with your sorting index. In other words, SET ORDER TO LastName and SET FILTER TO ZipCode = "23456" can be slow because each time you change go to the next record it has to check the table for the filtered value. With only 20 records I wouldn't think that would be much of a problem, but it can definitely be a problem with a few hundred records. You can get around it with some creative indexing.
2. DynamicBackColor
Just a wild guess, but see if your test cursor is based on a large table. If so, add NOFILTER to be sure you're truely woking on a small cursor.
David.