Using PSQL 9.1 I am comparing the PDAC SQL components to ADO. Selecting and looping through 1,000 rows takes about the same amount of time
using PDAC SQL and ADO with a client side cursor. However, ADO with a
server side forward only cursor takes 2.5 times more time to select and
iterate the same rows. That makes no sense at all. A server side
forward only cursor should be faster if anything.
Any suggestions? I can't help thinking that I must have something set
wrong.
Re: ADO Data Control Concurrency Problem ... >> Editing of row in table is done with the help of ADO Data Control....Cursor location does not bare on whether the ... Client or Server memory.... reflected in the open recordset. ... (microsoft.public.vb.general.discussion)
Re: Client Cursor oder Server Cursor? ... > Summa summarum dürfte es jemanden, der seine Programmierung auf ADO die ... So erstellt der SQL Server ein internes ... > Während der Client Cursor für den Abruf ein ForwardOnly/ReadOnly ... (microsoft.public.de.sqlserver)
Re: Didnt ADO used to default to client-side cursors? ... > The Execute takes a bit longer, but the client-side cursor is quite a ... set on the server in order to create a local ADO result set. ...ADO had more round trips to complete. ...asynchronous load for the client cursor. ... (microsoft.public.sqlserver.server)
Re: Didnt ADO used to default to client-side cursors? ... > The Execute takes a bit longer, but the client-side cursor is quite a ... set on the server in order to create a local ADO result set. ...ADO had more round trips to complete. ...asynchronous load for the client cursor. ... (microsoft.public.vb.database.ado)
