B
Bob Richardson
It takes about 20 seconds to run an UpdateBatch while trying to change only
500 records in my MDB. Is there a way I can speed this up. I think the
bottleneck has to do with locking each record individually. If I could lock
the entire table once, do all my updates, and then unlock the table, the
whole process would be much more efficient. There are only 1 or two users on
the DB at a time. Is there a way to do this. Perhaps something to do with
PagesLockedToTableLock ?
500 records in my MDB. Is there a way I can speed this up. I think the
bottleneck has to do with locking each record individually. If I could lock
the entire table once, do all my updates, and then unlock the table, the
whole process would be much more efficient. There are only 1 or two users on
the DB at a time. Is there a way to do this. Perhaps something to do with
PagesLockedToTableLock ?