httpd-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Brian Behlendorf <br...@organic.com>
Subject Re: namelookups and databases
Date Tue, 25 Jul 1995 20:12:12 GMT
On Tue, 25 Jul 1995, Rob Hartill wrote:
> > I've been attempting to shove my log data into Postgres and am
> > coming to a sobering realization. It has taken 9 hours to process
> > 15,000 requests.....  
> 
> What are you running it on, a 8086 PC ?
> 
> There's something really wrong if it is taking that long.
> Is it reindexing on each entry ?.. that'd be a braindead approach.
> 
> > As I am in the process of discovering that
> > much of that time is spent doing gethostbyaddr() for each entry.
				     ^^^^^^^^^^^^^^^
> What exactly are you doing with the data ?

gethostbyaddr can be *really* slow on sites not on the 155mbps backbone 
like yours, Rob ;)

If it's taking that long, and your web site isn't heavily loaded, why not 
just do a gethostbyaddr at the time of the request (like the default) or 
immediately *after* a response is sent?

	Brian

--=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=--
brian@organic.com  brian@hyperreal.com  http://www.[hyperreal,organic].com/


Mime
View raw message