hello All, (this might not be the right forum. But i hope you can help me)

I am using Mod_Auth_MySQL in replacment for .htpasswd

I am wounding if any has ever come across any problems with it. The current problems i am having are...

-MySQL is working very very hard. and is making the site run SLOW.

I have a lot of traffic and i assume each time a user logs in it is doing 1 query for each page a member hits. Is there anything in replacement to Mod_Auth_MySQL (besides .htpasswd Could it be its not installed correctly ?

Anyone with some experience with this Apache Module that can help me out would be a bonus!

I use the mod_auth_mysql module with no problems or slowdown at all. In fact, it operates extremely fast for the site I'm using it on. ( 3 different servers in fact ) I'm running apache 1.3.something on windows NT 4.0 systems of various power. I'm running perl embedded (mod_perl) not that it should make a difference here.

I wonder why you are experiencing slow down...

I have experienced one time when I had to restart apache and the mysql server becuase the authorization wasn't working at all, but after the restart, faster than a speeding bullet.

And by the way, the lowest end of my servers ( a total joke given it's surroundings ) has a 200 mhz processor! How pathetic! But it still does it's job.

I don't use an .htaccess file, I just put directives in the apache httpd.conf to limit access to certain directories. Maybe that is the difference that matters. I haven't tried it with .htaccess files.

My server is handling less traffic, but your traffic shouldn't at all be near the capacity of your technology. So my knee jerk reaction would be "no" that's not the reason it's malfunctioning - but you'd be amazed at how many times I've been wrong before.

Does MySQL/Mod_Auth_Mysql lock the table every time an authorization is done? I wouldn't think that it would be necessary.