ODBC speed

sde · 05-13-2003, 12:21 PM

i might be being forced to connect to MSSQL server via ODBC with a PHP application. is it really as slow as i hear it is? are there any other alternatives?

randy · 05-13-2003, 01:08 PM

Well, if it must be MSSQL, you can use ODBC or go with the native PHP functions for MSSQL. I don't know why that's not an option.

There is a little more work and a re-compile of PHP if it's installed on a Unix/Linux system, but it seems it would be a standard direct connection as opposed to ODBC.

http://www.php.net/manual/en/ref.mssql.php

sde · 05-13-2003, 01:19 PM

doh! thanks randy .. i completely forgot there was built in mssql functions .. probably because after looking at them i though 'who uses mssql' =)

thanks !

randy · 05-14-2003, 10:06 AM

No problem, I do that too.
Especially after looking at code and documentation for hours.

The only issue I saw with using it is that if PHP is running from a Unix/Linux server, you may have to recompile it.