Rob C wrote:
would it make it faster though? like php boards etc?
thanks |
It depends....
If your DB and Web server on the same network, then it will be faster. If not then it will be much slower. WWF speed depends on the proximity of your SQL and your web server as it makes multiple connections to your database on each page. If your SQL and web server are on the same network, then the connection time is minimal, but if they are not then the connection time starts to add up. Through optimizing the code for SQL Server you can overcome this, but you will have to modify the code with every release and would be better off with a forum that makes better use of SQL Server's ability to return multiple recordsets with a query (ie one that does not also have a Access version).