>I have a parametertized view with six fields and one where condition, and nothing else. It takes about .5 seconds to requery() it. Is that normal?
Is this a local view? If so, make sure that the expression in the WHERE clause match an index. An index on Deleted() can help you on some occasion too.
>Do most people just make normal views when they are processing records in batch and then use for condtitions and filters to limit the current data set?
If the table is small or it's a rare query, yes. If the table is big or the query will be performed many times, it will be faster to create more specialized views.
HTH
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