You are viewing a plain text version of this content. The canonical link for it is here.
Posted to embperl@perl.apache.org by Hartmaier Alexander <Al...@t-systems.at> on 2004/06/15 09:38:03 UTC
performace issues
Hi list!
I've got a performance issue with embperl since a long time.
My main webpage is a status page with 5 sections which are 5 different
epl files.
My first approach was to use an .shtml file and include all 5 pages.
The page takes about 3 seconds to load which is definitly too long!!!
So I changed it to an embperl file and used includes which doesn't help
either.
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.).
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.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Re: performace issues
Posted by Gerald Richter <ri...@ecos.de>.
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
---------------------------------------------------------------------------