Times:
the create sql view 1.36 seconds
the select view without using nodata 1.2 minutes (passed the where variable)
the select view using nodata .02 seconds
indexing the above .06 seconds
requery() with above 1.5 seconds (passed the where variable)
multi requery's get faster.

We have not checked tableupdate() yet.
John