On Tue, 02 Aug 2011 11:56:20 +0100 FreeBSD Ports <[email protected]> wrote:
> I'm using Apache 2.2.19 on FreeBSD 7.3 > mod_dav v.1.0.3 > mod_auth_mysql v.3.0.0 > > I've noticed that when I make a simple PROPFIND request to get just a > getcontenttype tag a large number of authentication queries are made to > the mysql server, however if a PROPFIND with any of the other tags (eg. > getcontentlength) is made, only one authentication query is made. That difference is indeed puzzling. Are you sure of it? The large number of queries happens when the server runs a subrequest on each file to determine whether it's accessible (and therefore whether to include it in the listing). In a normal listing you can turn it on and off with the ShowForbidden option, but I'd have to RTFM to tell whether mod_dav supports an equivalent. But that doesn't explain the difference! FWIW, even if you can't turn the behaviour off, you can avoid the repeated SQL queries with mod_authn_socache. In your case, I'd expect that to get you a substantial performance improvement. -- Nick Kew --------------------------------------------------------------------- The official User-To-User support forum of the Apache HTTP Server Project. See <URL:http://httpd.apache.org/userslist.html> for more info. To unsubscribe, e-mail: [email protected] " from the digest: [email protected] For additional commands, e-mail: [email protected]
