VoiceGuide IVR Software Main Page
Jump to content

Modes Of Connect To Database

Recommended Posts

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

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

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

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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×