Re: Performance measures of a perl script !!!
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. -- /||** Director and CTO ** //||** AxKit.com Ltd ** ** XML Application Serving ** // ||** http://axkit.org ** ** XSLT, XPathScript, XSP ** // \\| // ** Personal Web Site: http://sergeant.org/ ** \\// //\\ // \\
Re: Performance measures of a perl script !!!
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/
Performance measures of a perl script !!!
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... Edmar Edilton da Silva Bacharel em Ciência da Computacão - UFV Mestrando em Ciência da Computacão - UNICAMP