On Tue, 02 Aug 2011 11:56:20 +0100 FreeBSD Ports <freebsd.ports@xxxxxxxxxxxxx> 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: users-unsubscribe@xxxxxxxxxxxxxxxx " from the digest: users-digest-unsubscribe@xxxxxxxxxxxxxxxx For additional commands, e-mail: users-help@xxxxxxxxxxxxxxxx
|