Re: Best way to increase concurrency when using adopenstatic ?

What type of lock does it supposedly hold? I don't understand how moving to
the last record will affect locks,

Do you have a reference to this article?

Paul

"Ian Ippolito" <IanIppolito@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F886A278-15C3-42FA-B084-7B6968750F78@xxxxxxxxxxxxxxxx
I am forced to use adOpenStatic cursors on a few queries on a high volume
website (over 10 million page views/month) running Server 2005 (64 bit
version).

I read an article about SQL Server 7.0 stating that when you open a static
cursor, SQL Server holds locks on the rows until you get to the very last
row. So it recommended that you do a .MoveLast and then .MoveFirst to
increase the concurrency.

Is this still a valid technique in sql server 2005?

Thanks,


.

Relevant Pages

  • Re: row vs page locking...
    ... so they automatically escalate to page level locks. ... 'Lock Escalation' - see Books Online. ... SQL Server 2005 is going to have a Snapshot ... Good old fashioned locking is less sexy, but I find, more productive! ...
    (microsoft.public.sqlserver.server)
  • Re: Repeatable read. What is it exactly...
    ... SQL Server will hold locks on the data you have read ... can change change the data until you commit or rollback. ... SQL Server locks the data you read. ... > as transaction Isolation levels go. ...
    (microsoft.public.sqlserver.server)
  • Re: Locking in SQL Server and Oracle
    ... I am glad you would like to stay with SQL Server :-) ... > hard it would be to convert to Oracle during our next PeopleSoft upgrade. ... > had thought that since databases are databases, tables are tables, and SQL ... > uses row-level locks exclusively. ...
    (microsoft.public.sqlserver.server)
  • Re: Need help with DAO and SQL Server locking issue
    ... I will forward your response to the client. ... > Absolutely nobody uses DAO to work with SQL Server, ... I'd advise moving code that uses recordsets ... >>Locks are being placed on tables inside of a transaction each time the ...
    (microsoft.public.sqlserver.odbc)
  • Need help with DAO and SQL Server locking issue
    ... SQL Server 2000 blocking locks on Access upsized database. ...
    (microsoft.public.sqlserver.odbc)