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...
Yes, see the guide.
Oracle is slow to connect -- use Apache::DBI and connect_on_init to solve
this problem.
_____________________________________________________________________
Stas Bekman JAm_pH -- Just Another mod_perl Hacker
http://stason.org/ mod_perl Guide http://perl.apache.org/guide
mailto:[EMAIL PROTECTED] http://apachetoday.com http://logilune.com/
http://singlesheaven.com http://perl.apache.org http://perlmonth.com/