Hi, I have this simple procedure, that it's connecting to a remote DB and
it's too slow. It seems an ado problem because if
I use pgsql it's very fast. I understand that this query must send only one
record, but if I sniff the session (sniffit) I can see that
postgres is sending a lot of records, why ???
PD : Postgresql 7.1.3 under freeBSD 4.5-prerelease
Thanks a lot
Simeó Reig
Dim rsConexioDadesGenerals As ADODB.Recordset
Dim SQLDadesGenerals As String
Set rsConexioDadesGenerals = New ADODB.Recordset
---- identitatinforme is a primary key
SQLDadesGenerals = "SELECT nomentitatinforme FROM entitatsinformes WHERE
identitatinforme=" & idSocietatActual With rsConexioDadesGenerals
.LockType = adLockOptimistic
.CursorType = adOpenKeyset
.CursorLocation = adUseClient
--conexioADO is a global connection
.Open SQLDadesGenerals, conexioADO, adOpenDynamic
Set AdodcTaulaDadesGenerals.Recordset = rsConexioDadesGenerals
End With
msgbox AdodcTaulaDadesGenerals.Recordset.recordcount -- return 1
