Re: Some facts about MsSQL/ODBC

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 <petruchek@zsu.zp.ua> wrote in message news:031801c162fa$d09bebf0$6e64010a@weblab.zsu.zp.ua... > 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 > > >