This is the code i’m using to get a data through ODBC from a SyBase (SQL)
SQLString = "SELECT top 500 pm.articolo, p.descrizione FROM plumag pm
JOIN plugeco p ON pm.articolo = p.articolo WHERE p.plueto != ´EM´ AND
pm.articolo = " & Keywords(0)
Qry.SQL = SQLString
Res.MaxRows = 500
Set Res.Query = Qry
If Not Res.Execute Then
Messagebox Res.GetExtendedErrorMessage, , Res.GetErrorMessage
End If
´save data to the variable webstring
WebString =Res.GetValue(1) & “-” & Res.GetValue(2)
Print (WebString + “THE END”)
as it showed - the time taken to display the data are about 15 seconds if i replace in the code the row
WebString =Res.GetValue(1) & “-” & Res.GetValue(2)
with
WebString =“”
it takes to display the word “THE END” only about 1-2 seconds.
Mi question is as follow: how such a big difference is possible? where
is my mistake ? at the execution of the SQL where all data from the
ODBC are stored?
Why it takes so much time to get the data out of Res.GetValue() ?
if i open DB with Notes and i do CTRL + SHIFT + F9 … time of research after is only few sec… why??? HELP ME PLS
thanks a lot in advanced
Max