On Thu, 21 Dec 2000, Edmar Edilton da Silva wrote:
> Hi all,
>
> I ran some performance measures on two perl scripts under
> mod_perl, the first script access a Oracle database using the
> DBD::Oracle
> module and the second script access a MS SQL Server database using the
> DBD::Sybase module. The measured response times was very different at
> the
> two cases, the time for the Oracle database was approximately three
> times
> the time for MS SQL Server databse. Why all this difference between
> the measured values ? I also understood that an Oracle connection needs
> much more resource of machine than an MS SQL Server connection (both
> database servers are not installed on the same machine that the Web
> server). Is it correctly? Please, is there some place where I can find
> docs about it? Any help will be very appreciated. Thanks...
Dear Fast Car magazine,
My Ferrari uses more petrol than my MacLaren F1. Why is this?
Answer: They use different engines.
Seriously, different DB's take different amounts of time to connect
because they are written differently. If you want no connection time use
Apache::DBI to cache the connection.
--
<Matt/>
/|| ** Director and CTO **
//|| ** AxKit.com Ltd ** ** XML Application Serving **
// || ** http://axkit.org ** ** XSLT, XPathScript, XSP **
// \\| // ** Personal Web Site: http://sergeant.org/ **
\\//
//\\
// \\
