perl-embperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gerald Richter" <rich...@ecos.de>
Subject Re: performace issues
Date Tue, 15 Jun 2004 10:20:29 GMT
Briefvorlage> I don't think that the database (oracle 9ir2) queries cause the
> problem because the select statements just query views (which contain
> 0-10 rows approx.).  
> 

Do you use Apache::DBI ?

Oracle need very long to make the inital connect and without connection caching you will get
very slow responses

Gerald


> How can I track down which part of code is causing this and/or
> benchmark parts of my code??? 
> 
> Any suggestions???
> 
> Greetings Alex
> 
> 
> #############################
> status.epl:
> #############################
> 
> [!
> use strict;
> use nactools;
> Execute ({ inputfile => 'nacadminlib.epl', import => 1 });
> !]
> 
> <?xml version="1.0" encoding="UTF-8"?>
> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
>   "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" >
> 
> <meta http-equiv="Refresh" content="300">
> 
> [- page_header() -]
> 
> <body>
>   <table>
>     <tr><td class="title">Network Status (auto-refresh every 5
> minutes)</td></tr> 
>   </table>
>   <br>
>     [-
>         Execute('down-devices.epl');
>         Execute('down-interfaces.epl');
>         Execute('new-interfaces.epl');
>         Execute('mod-interfaces.epl');
>         Execute('old-interfaces.epl');
>     -]
> </body>
> </html>
> #############################
> 
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
> Hinweis: Dieses E-mail kann vertrauliche und geschützte Informationen
> enthalten. 
> Sollten Sie nicht der beabsichtigte Empfänger sein, verständigen Sie
> bitte den Absender und löschen Sie dieses E-mail dann sofort. 
> 
> Notice: This e-mail contains information that is confidential and may
> be privileged. 
> If you are not the intended recipient, please notify the sender and
> then delete this e-mail immediately. 
> *"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*

---------------------------------------------------------------------------
Gerald Richter            ecos electronic communication services gmbh
IT-Securitylösungen * Webapplikationen mit Apache/Perl/mod_perl/Embperl

Post:       Tulpenstrasse 5          D-55276 Dienheim b. Mainz
E-Mail:     richter@ecos.de          Voice:   +49 6133 939-122
WWW:        http://www.ecos.de/      Fax:     +49 6133 939-333
---------------------------------------------------------------------------
ECOS BB-5000 Firewall- und IT-Security Appliance: www.bb-5000.info
---------------------------------------------------------------------------

Mime
View raw message