>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?
>

Gee... that depends on ALOT of stuff... machine speed, network speed, optimization level of query, etc, etc.

>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 you are procesing ALOT of records in a process, you should create a view that contains all the records... process the view as you would a table with scan...endscan or replace for, whatever, then do a tableupdate().

This will be alot faster than querying one record at a time, processing it, update it, then query the next record.

>Thanks for everyones help! I've found most answers to be extremely insightful here, and I appreciated everyones time. :-)

HTH,
BOb