Re: mssql and php4

MSSQL is actually as fast (or faster) as mysql on the same hardware, but I guess you can compare the two and get the results you want. On the other hand that is not the issue ! When you are configuring MSSQL systems with server and client on two different computers you should consider using TCP/IP as the communication protocol. You do this by selecting TCP/IP as the default protocol in the "Client Network Utility" or by adding a new client configuration using TCP/IP in the same tool. Another performence problem could also be DNS. You could configure the sytem to use a fixed IP address (you do that in "Client Network Utility" too) - Frank > hihi, mssql = sux > check out www.mysql.com > (or you maybe a really big bubu in your DB structure) > > > > Hi, > > I am just starting out with php and have managed to get it running OK on > my > > machine (Win2K) and connecting to an MSSQL 7 database on another machine > (on > > my LAN). However, it seems to run really slowly when accessing the > database. > > It takes around 6 seconds for my simple page to appear... At first I > thought > > that it was because I was running IIS so I tried installing Apache and > using > > that. It is no quicker. > > Pages that don't contain connections to the database appear much faster. I > > am using the mssql functions. So for example my script might look > something > > like this: > > > > $connection = mssql_pconnect($databaseServer, $databaseUsername, > > $databasePassword) or die("ERROR CONNECTING TO DATABASE"); > > $database = mssql_select_db($databaseName); > > $getArticles = mssql_query($getArticlesSQL) or die("ERROR EXECUTING SQL"); > > while($getArticlesResult = mssql_fetch_row($getArticles){ > > $articleID = $getArticlesResult[0]; > > $date = $getArticlesResult[1]; > > $title = $getArticlesResult[2]; > > $introText = $getArticlesResult[3]; > > echo $articleID . $date . $title . $introText . "<br> > > } > > > > Is there a faster way to do this? As far as I can see in the docs this is > > the most efficient way to get a result set and loop through it. Or are the > > connections to a MSSQL database just slow from PHP? > > Thanks in advance for any help anyone can give me, > > Kelvin. > > > > > > -- > > PHP Windows Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > > For additional commands, e-mail: php-windows-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > > -- > PHP Windows Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-windows-unsubscribe@lists.php.net > For additional commands, e-mail: php-windows-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >