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.
Advertising
Is there anything better to use? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
