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
---------------------------------------------------------------------------