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:[EMAIL PROTECTED]]
Sent: 18 April 2001 06:41
To: Tomasz Abramowicz
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
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)
>
>
--
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
