Efficient way to access MS SQL server
| From: | charlie | Date: | Wed, 30 Jan 2008 14:55:40 +0000 |
| Subject: | Efficient way to access MS SQL server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-44542@lists.php.net to get a copy of this message | ||
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?