Better way to access MS SQL Server from PHP
[email protected] ("cfs")
| Newsgroups | php.db |
|---|---|
| Message-ID | <[email protected]> |
Currently using ODBC to connect to MS SQL server 2005. Profiling shows that to fetch many rows requires a cursor based fetch of each record - a round trip to SQL server for each. I would like to use some driver/interface from PHP to SQL server that would get all rows in one round trip, or at least a smaller number of round trips. The native SQL driver for PHP has a problem with a limit on the number of characters in a string, so can't use that. Is there anything better to use?