mssql_connect slow (linux server)

Question

Does anyone know why mssql_connect would be slow? PHP is running on a Linux server with FreeTDS. I am trying to connect to a remote database. When I connect from PHP it takes about 3 seconds, but if I use the FreeTDS tsql command from the shell it connects in under a second, so it is able to connect faster. Is there a setting I can change or a different driver I should use?

Do you have enough remaining database connections? – user1474090 Oct 12 '12 at 16:10 — user1474090, Oct 12 '12 at 16:10

score 0 · Answer 1 · edited May 23 '17 at 11:43

0

You should start using PDO with MSSQL driver support.

More info on:

http://php.net/manual/en/ref.pdo-dblib.php

And some examples:

Connecting to mssql using pdo through php and linux

edited May 23 '17 at 11:43

Community

1
1

answered Oct 12 '12 at 16:37

PDO is just as slow. I think it uses the same driver as mssql_connect. Also for some reason it also crashes after connecting and I get an empty response. – Meir Oct 12 '12 at 17:17

mssql_connect slow (linux server)

1 Answers1