PervasiveSQL2000 slow data retrieving

[emilioantonio]

hi folks,

i'm developing a VB6 real-time 3d graphic application that retrieves, every 10 seconds, data from a Pervasive.SQL2000 SP2 server database through the following DSNless connection code:

Dim adoConn As New ADODB.Connection
Dim rst1 As New ADODB.Recordset
dim curdb as string

curdb = "N:\database\db1" - This is the remote database path

With adoConn

    .Provider = "MSDASQL"
    .ConnectionString = "driver={Pervasive ODBC Client Interface};ServerName=;ServerDSN=;dbq=" & curdb
    .Open
    
End With

If adoConn.State = adStateOpen Then

rst1.Open "select " & Chr$(34) & "ref measured depth" & Chr$(34) & " from " & Chr$(34) & "drilling data" & Chr$(34) & " order by " & Chr$(34) & "ref measured depth" & Chr$(34), adoConn

 rst1.Close
    adoConn.Close

The problem is that looping trough 10000 to 25000 records to retrieve last data to refresh plot it's a very slow process and takes much longer the 10 seconds.

I heard that using bitrieve API to get data it's much faster, but i really have no idea on how to convert
my odbc connection code into betrieve api connection code.

Any help would be very welcomed

Thanks

emilioantonio

 

[zemp]

This is a continuation of thread222-1312804.

zemp