Hi Kevin,
Walter mentioned this but only indirectly. . .
*IF* you are running with DELETED ON *and* your tables (especially the ones used by the views in this case) have an index/TAG on DELETED() *and* the proportion of actually deleted rows is either very very low or very very high
. . . this would most likely be your problem.
The "cure" for the above case is to eliminated the TAG on DELETED(). While this will give only partial optimization, that is better in this case than full optimization.
Good luck,
Jim N
>Walter
>
>Most of my views are parameterized on an indexed field but do appear to be the culprits.
>
>In each of my Pages Activate event, I requery the views needed, but on some pages there are around 10-12 views that need to be updated - this is even quite slow on my own PC.
>
>I always thought that a requery would be instant on a simple view, but it appears to be quite slow - what do you think?
>
>Kev
Previous
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