Re: db performance

Frank- Thanks for the thoughts. The db Server is not on the same machine as the web server. They are connecting via tcp/ip. I used the IP address to rule out DNS trouble. One interesting note. For fun I downloaded Apache for Win32, installed it and the php modules in it. Used the same exact page to connect to a SQL 2000 db server--in other words I did not change any of the source code and it connects and returns instantly! We are talking about a 20 to 1 difference in speed from IIS 5. At 11:10 AM 6/21/2001 -0700, Frank M. Kromann wrote:

This could be an networking issue. Is the SQL server and the Web server on the same computer ? Are you using tcp/ip or netbeui to communicate from web server (php) to the database server ? If web and database is on the same platform I would recommend using netbeui and connect to a server named local. This gives a direct connection to the server. If you are using two different boxes I would use tcp/ip. This uses you approx. 8 times less bandwidth. You have to configure the client (the MSSQL Client tools on the web server) to either use the protocol you prefer as default or by adding a client network configuration. mssql_connect() calls a MSSQL function to connect to the database. It first looks for a client configuration that matches the name you are specifying as first parameter. If that fails it tries to connect using the default protocol (doing a DNS lookup for tcp/ip or a netbeu broadcast). These can take some time depending on network settings. When you create a client network configuration using tcp/ip, you can connect directly to an ip address so you wount have to do DNS lookups. - Frank