Re: mssql and php4

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 >