Just had an IT Consultant call me regarding one of my DBISam applications.
He wants to turn Op Locks off on the server because of another program, and
has asked if it will cause any problems with DBISam?

I didn't think that it would, but thought it would be prudent to ask the
question here. Does Opportunistic Locking make any difference to DBISam
(running in local mode)?

Thanks & Regards

Adam.

Adam,

What version of DBISAM are you using?
Do you use DBISAM in a shared-file (local) or client/server mode?

Also, check out these resources:
http://www.elevatesoft.com/bulletin_6.htm

or

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q129202



Adam H. wrote:
> Just had an IT Consultant call me regarding one of my DBISam applications.
> He wants to turn Op Locks off on the server because of another program, and
> has asked if it will cause any problems with DBISam?
>
> I didn't think that it would, but thought it would be prudent to ask the
> question here. Does Opportunistic Locking make any difference to DBISam
> (running in local mode)?
>
> Thanks & Regards
>
> Adam.
>
>

"Adam H." <ahairsub4@rREMOVEMEspamSTOPPER.jvxp.com> wrote in message
news:137926A4-18EE-4B55-9825-F09F110F0F9B@news.elevatesoft.com...
> Just had an IT Consultant call me regarding one of my DBISam applications.
> He wants to turn Op Locks off on the server because of another program,
> and has asked if it will cause any problems with DBISam?
>
> I didn't think that it would, but thought it would be prudent to ask the
> question here. Does Opportunistic Locking make any difference to DBISam
> (running in local mode)?
>

No difference. A single user application will run slower.

http://www.elevatesoft.com/bulletin_6.htm

Robert

Hi Jason,

> What version of DBISAM are you using?

I'm running whatever the latest is in version 4. (Forgot what I'm up to
atm).

> Do you use DBISAM in a shared-file (local) or client/server mode?

Shared File (Local) mode.

> Also, check out these resources:
> http://www.elevatesoft.com/bulletin_6.htm
>
> or
>
> http://support.microsoft.com/default.aspx?scid=kb;en-us;Q129202

Thanks. I have seen them in the past, and I'm aware of how they affected
Paradox tables. (Always advised to turn them off). However, I'm wanting to
verify if their's a difference with DBISam. Whether they're better off than
on, (as I'm currently under the opinion they should be on, unless corruption
occurs), and whether turning them off will cause problems / speed issues,
etc.

Thanks & Regards

Adam.

Hi Robert,

Thanks. So in short - it's best to keep them on, just incase a single user
decides to run the app. (Would make things slightly faster).

Cheers

Adam.

Adam,

<< Just had an IT Consultant call me regarding one of my DBISam
applications. He wants to turn Op Locks off on the server because of another
program, and has asked if it will cause any problems with DBISam? >>

It will cause single-users using a given table to slow down.  However, if
more than one user is usually using a given table anyways, then you probably
won't even notice a difference.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hi,

We always recommend to turn it off to our customers since we still use
the file/server model. Oplocks do not work correctly on all versions of
windows and can even corrupt access databases. Microsoft actually
recommends turning it off on some of its windows flavors if using the
access Jet engine. There are also plenty of postings around the web that
indicate that turning off OpLocks eliminates corruption issues. I
suspect that oplocks allow the workstation to cache data and sometimes
this all doesn't get properly flushed to the server in file/server
applications. So, I would turn it off if you use DBISAM in in
file/server mode. If you are using Client/Server DBISAM I can't see how
it would affect you.

Also stops calls about why the program slowed down suddenly when another
user logged on

Sean

Adam H. wrote:
> Hi Robert,
>
> Thanks. So in short - it's best to keep them on, just incase a single user
> decides to run the app. (Would make things slightly faster).
>
> Cheers
>
> Adam.
>
>