RE: [PHP-WIN] mssql and php4

Thanks for the responses. I am already connecting to my database through TCP/IP (it was set as default in the client network utility). I was just providing the IP address of the database server to the mssql_pconnect function. I just experimented with adding an alias in the client network utility and providing this to mssql_pconnect but that didn't make it any faster... I guess if I am just using IP addresses then DNS couldn't be an issue either? PHP is running on my 550Mhz PIII with 256MB RAM. This should be fast enough I guess - for testing at least. But it is taking around 6 seconds for a database driven page to appear - this is definitely slower than it should be isn't it? I've just started using PHP because I thought it was better and faster than cold fusion but the same page written in cold fusion is considerably faster which makes me think that I must just have PHP somehow set up wrong... Any other ideas? Thanks, Kelvin. -----Original Message----- From: Frank M. Kromann [mailto:frank@frontbase.com] Sent: 18 April 2001 06:41 To: Tomasz Abramowicz Cc: kelvin@sasdesign.co.uk; php-windows@lists.php.net Subject: Re: [PHP-WIN] 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) > >