Re: ADO server side cursor sloooow

Nice. Did they give you a Bug Number for tracking purposes?
Goldstar Software Inc.
Building on Btrieve(R) for the Future(SM)
Bill Bach
BillBach@xxxxxxxxxxxxxxxxxxxx
http://www.goldstarsoftware.com
*** Chicago: Pervasive.SQL Service & Support - March, 2006 ***
*** Chicago: Pervasive DataExchange Class - March, 2006 ***

Bill wrote:

> Bill,
>
> FYI, I finally opened a support case and Pervasive confirmed that
> server side cursors have a performance problem with the OLE DB
> provider. Their recommendation is to use the ODBC driver with ADO.
> Using the ODBC driver my tests show that both client and server side
> cursors are faster than with the OLE DB provider and a read only
> forward only server side cursor is faster than a client side cursor as
> one would expect.

.

Relevant Pages

  • Re: Bidirectional cursor navigation
    ... It has async operations (including async connections), ... has server-side AND client-side cursors, ... >> the wonders of the web implemented connected architectures. ... >> Server can support thousands of users (we ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: problem with asp web site recorsets (sqlserver2000) return esporadicaly EOF BOF
    ... You are using server side cursors 'CursorLocation=2'. ... > that the database is complitly functional when this occurs, ... this is an aplication on the intranet of the company and has a heavy ...
    (microsoft.public.sqlserver.odbc)
  • Re: Database access sucks!
    ... In VB6 DAO recordsets the default was client ... side cursors, when ADO was introduced the default was server side cursors. ... Other database access methods don't allow this goofy design, ...
    (microsoft.public.dotnet.general)
  • Re: ADO Performance, command cachezize > 1?
    ... First of all CacheSize supported only for the ... cursors opened on a server side. ... then provider passes SQL query and parameter to the provider. ... most likely you opened recordset on a server side. ...
    (microsoft.public.vb.database.ado)
  • Re: ADO Performance, command cachezize > 1?
    ... First of all CacheSize supported only for the ... cursors opened on a server side. ... then provider passes SQL query and parameter to the provider. ... most likely you opened recordset on a server side. ...
    (microsoft.public.vb.general.discussion)