Guest Jose Report post Posted 02/21/2003 11:41 PM Hi all is there any other mode of connect to database different to ODBC? because my query is too slow with ODBC regards José Share this post Link to post
SupportTeam Report post Posted 02/22/2003 06:38 AM What database are you using? ODBC itself does not add much ovehead - perhaps your query just takes a long time to run? Share this post Link to post
Guest jose Report post Posted 02/25/2003 08:48 PM I am using Sybase with 2 million of registers, My query take approximately five minutes the first time, but the second time take one minute. Share this post Link to post
SupportTeam Report post Posted 02/26/2003 12:32 AM As I've mentioned before the ODBC interface itself does not add any significant overhead to transaction time. If you are finding that you can perform the query faster in Sybase native mode then via it's ODBC interface (is this the case?) then the problem may be caused by poor implementation of the ODBC drivers by Sybase... If there is a faster way to perform the Sybase query then through it's ODBC drivers then antoher way to approach this is to write an external program/script which perfoms this query and call it from a Run Program module. If Sybase installs some COM Scriptable objects that work faster then their ODBC drivers then you can also use them from inside the VB Script module... Share this post Link to post
