FUDforum: comp.lang.php » Microsoft SQL and PHP

Home » Imported messages » comp.lang.php » Microsoft SQL and PHP

Show: Today's Messages :: Polls :: Message Navigator

Microsoft SQL and PHP [message #181846]

Tue, 18 June 2013 23:32

rob.loy
Messages: 1
Registered: June 2013

Karma:

Junior Member

I am running PHP 5.2 on a Windows machine using Apache. It is a legacy application which uses ODBC as part of the PHP install to connect to the MSSQL server 2008. I am running in to a performance issue where each SQL query makes a round trip from the Web to the SQL server for each record so a recordset with 150 results makes 150 roundtrips. Is there a setting for the ODBC connection to return the entire recordset or should I "just"migrate to the Microsoft SQL Drivers? Any input would be a great help.

Report message to a moderator

[Message index]

		Microsoft SQL and PHP By: rob.loy on Tue, 18 June 2013 23:32
		Re: Microsoft SQL and PHP By: Erwin Moller on Tue, 25 June 2013 14:00
		Re: Microsoft SQL and PHP By: Mike McGinn on Wed, 26 June 2013 01:29

Previous Topic:	PHP form generator
Next Topic:	strange one

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 19:48:46 GMT 2024

Total time taken to generate the page: 0.04737 seconds