SQL Anywhere database - Windows Networks and Opportunistic locking

Author

Windows Networks and Opportunistic locking

Frank

2005-06-28, 3:23 am

Hi there, I am new to the deep technical world of SQL databases so please
forgive me if this is a stupic question.
A technician is trying to convince me that this document:
http://www.dataaccess.com/whitepape... /> aching.html
which discusses some obscure matter called "opportunistic locking"
is important when setting up networks for database use.

We have been using ASA5, 7 to ASA9 for the last 10 years and never had to
tweak a windows network.

Is there any relevance to the Sybase ASA world?

Thanks in advance
Frank
Techsupport Centaur Software

Dmitri

2005-06-28, 3:23 am

Frank wrote:

> A technician is trying to convince me that this document:
> http://www.dataaccess.com/whitepape... /> aching.html
> which discusses some obscure matter called "opportunistic locking"
> is important when setting up networks for database use.
>
> We have been using ASA5, 7 to ASA9 for the last 10 years and never had to
> tweak a windows network.
>
> Is there any relevance to the Sybase ASA world?

It haven't got anything to do with any kind of true C/S architecture
(not just based on Sybase ASA) as it implies that there is no file
access over the network.

Dmitri.

Martin Baur

2005-06-28, 7:23 am

In article <42c0d23d@forums-2-dub>, frankp@centaursoftwa
re.com says...
> http://www.dataaccess.com/whitepape... /> aching.html
>
> Is there any relevance to the Sybase ASA world?

ASA clients access a DB Engine on a server machine, not a file on the server machine.

So, don't care about this doc.

Martin
MindPower.com

David Kerber

2005-06-28, 7:23 am

In article <42c0d23d@forums-2-dub>, frankp@centaursoftwa
re.com says...
> Hi there, I am new to the deep technical world of SQL databases so please
> forgive me if this is a stupic question.
> A technician is trying to convince me that this document:
> http://www.dataaccess.com/whitepape... /> aching.html
> which discusses some obscure matter called "opportunistic locking"
> is important when setting up networks for database use.
>
> We have been using ASA5, 7 to ASA9 for the last 10 years and never had to
> tweak a windows network.
>
> Is there any relevance to the Sybase ASA world?

Not much, if any. Its main application is to databases where the client
opens the database file directly, rather than connecting to a database
server process. So systems such as dBase (.dbf) files, M$ Access .mdb
databases and the like have to worry about this. Client-server
databases like Sybase ASA and ASE, Oracle, DB2, etc do not. The subject
comes up all the time on the dBase newsgroups I also participate in.

--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).

Breck Carter [TeamSybase]

2005-06-28, 7:23 am

IMO "file system database" is an oxymoron :)

If your database file is on a drive that is *locally* connected to the
computer running the ASA engine (dbeng5.exe, dbsrv9.exe, etc) there
are no issues. The clients can be across the LAN, WAN, or internet,
but not the databasee file.

Breck

On 27 Jun 2005 21:29:54 -0700, "Frank" < frankp@centaursoftwa
re.com>
wrote:

>Hi there, I am new to the deep technical world of SQL databases so please
>forgive me if this is a stupic question.
>A technician is trying to convince me that this document:
>http://www.dataaccess.com/whitepape... /> aching.html
>which discusses some obscure matter called "opportunistic locking"
>is important when setting up networks for database use.
>
>We have been using ASA5, 7 to ASA9 for the last 10 years and never had to
>tweak a windows network.
>
>Is there any relevance to the Sybase ASA world?
>
>Thanks in advance
>Frank
>Techsupport Centaur Software
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links