Slow ODBC

[Anon]

Why are the PHP ODBC functions so slow?

I can fetch data at 10x the speed with a generic sybase driver.

Anyone have some example ODBC code?

[Anon]

Z,

ODBC is slower because it operates on a higher level that uses generic, non-database specific functionality.

Conforming to the ODBC Standards does tend to be a lot slower, regardless of the type of database that you are using. ODBC is a nice convenience in certain situations, but if you can use the specific PHP DB Functions for your database, you will almost always see better performance from them.

Joseph