Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: Improving performance by generating a static html file?

by mamboking (Monk)
on Apr 12, 2002 at 14:54 UTC ( #158595=note: print w/replies, xml ) Need Help??


in reply to Improving performance by generating a static html file?

Before I would look into caching the html, I would look at trying to improve my DB performance. Are you caching connections to your database? If not, then you probably want to have a pool of open db connections available to your program. Connecting to the database is usually very costly. Also, as was already mentioned, make sure that your tables are properly indexed. I'm not sure if your database has an "explain plan" to show how your query will be executed, but if it does try to minimize the number of table/full scans that are performed.
  • Comment on Re: Improving performance by generating a static html file?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://158595]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others lurking in the Monastery: (2)
As of 2021-09-23 21:13 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found

    Notices?