Page 1 of 1

MSSQL vs ODBC

Posted: Sat Feb 14, 2009 3:46 am
by 0perand
I am writing some db classes... I am wondering if using the MSSQL classes with the native client/ntwdblib.dll is faster/more efficient than using odbc.

Please let me know any experiences with this situation. Ex... Larger database sizes get better results with ... From what I understand in "theory" odbc should be slower... but I am not 100% sure.

All help is appreciated!

Thanks,

0p

Re: MSSQL vs ODBC

Posted: Sat Feb 14, 2009 8:37 am
by Attero
It would be better to make your own drivers for each database using their standard functions in PHP and use ODBC for any other databases that standard PHP doesn't supply support for.

If you are planning on using stored procedures, ODBC doesn't have support for returning values (only for returning data sets) and I think there are several problems with using it for advanced database coding.

Use the MSSQL functions.