Use Transaction property

G

Guest

I have a db that I make several data manipulations on (delete, insert,
updates, etc). The database is large ( > 1GB) and I constantly make updates
to tables that contain over a million rows. I have modified the
maxlocksperfile setting to 200,000 but I still get errors. I read somewhere
that I can set the Use Transaction property of a query to No and that will
not capture transactions for rollback and hence not require as much
processing power or disk space.

Is this correct? And if yes, will there be a performance impact? My queries
take over 15 minutes to execute.

I am using Access 2003, with Access 2000 format. Windows XP
 
M

[MVP] S.Clark

The Help file says kinda the same thing. Did you try it?

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
(e-mail address removed)
www.fmsinc.com/consulting
 
G

Guest

Yes, I have tried it; with no perceptible improvement in performance.

Oh well.

Are there any known issues with setting this property to No (other than that
I cannot rollback, which isnt a significant issue for my application).

Thanks in advance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top