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