>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?
I've just been timing my code, and I have a fairly simple local view of 12 fields, 2 parameters in Where, and it takes about .012 seconds each requery from a fairly small table, small result set, with indexes on Where fields, not much longer without indexes. So there's very little overhead in a Requery() command itself. Slowness may result from lack of index on Where field, large result set, network overhead, perhaps, in your case...also, index on deleted can slow it down.
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.