When a UniVerse/SQL SELECT is in progress, each group (one at a time) is latched to prevent the current group from being modified. However, these group latches are released immediately the SELECT has finished processing that group, so that ought not to be an issue apart from the minor possibility of contention on those groups. Certainly "lots of locks" ought not to be obtained by a SELECT.
(If you set transaction isolation level high (say 3 or 4), then you may start seeing FS or even IX file locks taken, but not "many" record-level locks.) Might be worth bouncing this one off support. ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/