MSSQL vs ODBC

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
0perand
Forum Newbie
Posts: 9
Joined: Wed Oct 15, 2008 12:28 am

MSSQL vs ODBC

Post 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
User avatar
Attero
Forum Newbie
Posts: 18
Joined: Thu Jan 29, 2009 9:35 am
Location: Farnborough, UK

Re: MSSQL vs ODBC

Post 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.
Post Reply