Beefy Boxes and Bandwidth Generously Provided by pair Networks
No such thing as a small change
 
PerlMonks  

Re: Super Duper Inefficient

by hmerrill (Friar)
on Jun 20, 2003 at 13:23 UTC ( [id://267561]=note: print w/replies, xml ) Need Help??


in reply to Super Duper Inefficient

I'm not sure I understand - can you explain what data is in the database? Is it webserver 'access_log's? From one webserver, or from all 60 webservers?

Hard to make a recommendation without a better understanding of the situation.

My guess is that the database contains a conglomeration of 60+ webserver access(?) logs - your script separates out the entries for each webserver into a separate '.tmp' file for each webserver. An easier way to accomplish this doesn't really come to mind - the only way I can see to make this better would be to have each of the webserver's log into their own log file from the start, instead of having to separate out each webserver after the fact. If they're all in one database because you have 1 webserver serving 60+ virtual webservers, then I don't know how that could be done.

Sorry I couldn't be more help(yet). Clarifying and describing your setup in more detail may spark an idea from either me or someone else ;-)

Log In?
Username:
Password:

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

How do I use this?Last hourOther CB clients
Other Users?
Others admiring the Monastery: (3)
As of 2024-04-19 19:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found