[PHP] Some facts about MsSQL/ODBC

2001-11-01 Thread Valentin V. Petruchek

Hello everyone!
Here i'm not going to ask community about smth.
I would like to present results of one test speed.

i perform the same query to MsSQL directly (using mssql_...) and through
ODBC (odbc_...)
In first case (direct connection) php works SLOWER than through ODBC.

My server is on NT 5.1.

Can anyone explain me why ODBC is faster than direct connection?

Thnx, Valentin




-- 
PHP General 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]




Re: [PHP] Some facts about MsSQL/ODBC

2001-11-01 Thread l0t3k

Valentin,
first, let us know exactly how you tested.

second, i think it may have to do with the way the direct extension is
written. the direct extension does batch fetches every time it does a
physical read of the database. if all you're trying to get is a value from
the first row in a multi-row result set, then it makes sense that this would
be slower than a driver that does only single row fetches.

Valentin V. Petruchek [EMAIL PROTECTED] wrote in message
031801c162fa$d09bebf0$[EMAIL PROTECTED]">news:031801c162fa$d09bebf0$[EMAIL PROTECTED]...
 Hello everyone!
 Here i'm not going to ask community about smth.
 I would like to present results of one test speed.

 i perform the same query to MsSQL directly (using mssql_...) and through
 ODBC (odbc_...)
 In first case (direct connection) php works SLOWER than through ODBC.

 My server is on NT 5.1.

 Can anyone explain me why ODBC is faster than direct connection?

 Thnx, Valentin






-- 
PHP General 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]