Woohoo! Found the link... chalk one up for consistent thinking/searching patterns!!
http://spacefold.com/colin/articles/sql_backend/backend.htmI found all of it helpful, but the section you're looking for is titled, "Handling Busy Connections"
It's a few years old, but it's still relevant and there's always something to be said for concise, straight-forward plain english.
Thankfully I found this, or it would have bugged me all day. Now I can get (back) to work!
---J
>In addition to Yuri's suggestion, you can also try these settings on your views:
>
>FetchAsNeeded = .F.
>FetchSize = -1
>MaxRecords = -1
>
>These will force the view to retrieve all records before moving on to the next statement in your code. You could do the same by issuing a RECCOUNT()/GO BOTTOM or anything that forces the record pointer to traverse the record set completely, but IMO these settings do the job in a cleaner manner.
>
>When we were struggling with these issues earlier this year, I stumbled upon a fantastic white paper-esque website with exhaustive research (including time trials) on these properties and how they interact. Unfortunately, I didn't bookmark it. >:( If I find it again, I'll send it to you.
>
>Hope that helps,
>---J
