.htaccess Limits - What's your largest? - GoFuckYourself.com

Babaganoosh · 05-03-2002, 08:29 AM

I am putting the finishing touches on a new "join for free" type script. The first version of it will use .htaccess for password protection. How many users can .htaccess handle? After all, it is only a flat text file. I can cook up a mod_auth_mysql version easy enough so apache can authenticate users from a MySQL database, but for most people, that apache mod wouldn't be practical. Anyway, my largest .htpasswd file is about 6000 users long and it seems to work okay. Anyone have any experience with a larger password file?

AdultWire · 05-03-2002, 08:33 AM

I don't actually know the answer to this (which is why I never use htaccess authentication), *BUT*, the magic number for most old-school unix flat files is in and around 65535. Performance may degrade before that, however.

Babaganoosh · 05-03-2002, 08:34 AM

65535 lines?

chodadog · 05-03-2002, 08:59 AM

I think it's 65535 kilobytes.. or bytes.. one of the two.

JFPdude · 05-03-2002, 09:01 AM

65535 kb file size is the limit

NetRodent · 05-03-2002, 09:06 AM

Size isn't the only concern, you also need to consider how often that file will be accessed. If you're reading it 100 times / second, you're going to have trouble long before you would if you were only reading it 1 time / minute.

05-03-2002, 08:29 AM	#1
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	.htaccess Limits - What's your largest? I am putting the finishing touches on a new "join for free" type script. The first version of it will use .htaccess for password protection. How many users can .htaccess handle? After all, it is only a flat text file. I can cook up a mod_auth_mysql version easy enough so apache can authenticate users from a MySQL database, but for most people, that apache mod wouldn't be practical. Anyway, my largest .htpasswd file is about 6000 users long and it seems to work okay. Anyone have any experience with a larger password file? __________________ I like pie.

05-03-2002, 08:33 AM	#2
AdultWire Confirmed User Join Date: Feb 2002 Location: Toronto, ON Posts: 962	I don't actually know the answer to this (which is why I never use htaccess authentication), BUT, the magic number for most old-school unix flat files is in and around 65535. Performance may degrade before that, however. __________________ SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.

05-03-2002, 08:34 AM	#3
Babaganoosh ♥♥♥ Likes Hugs ♥♥♥ Industry Role: Join Date: Nov 2001 Location: /home Posts: 15,841	65535 lines?

05-03-2002, 08:59 AM	#4
chodadog Confirmed User Join Date: Apr 2002 Posts: 9,736	I think it's 65535 kilobytes.. or bytes.. one of the two.

05-03-2002, 09:01 AM	#5
JFPdude Confirmed User Join Date: Jan 2002 Location: Mountains of Western North Carolina. Posts: 4,027	65535 kb file size is the limit

05-03-2002, 09:06 AM	#6
NetRodent Confirmed User Join Date: Jan 2002 Location: In the walls of your house. Posts: 3,985	Size isn't the only concern, you also need to consider how often that file will be accessed. If you're reading it 100 times / second, you're going to have trouble long before you would if you were only reading it 1 time / minute.