Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Max access file entries

3 views
Skip to first unread message

Aaron G. Sword

unread,
Jan 16, 2002, 10:25:20 PM1/16/02
to
Can anyone tell me if there is a realistic limit to the number of lines
I have in my access [access.db] file? I am sure that the more lines I
have the more resources it takes, but I am curious if anyone can say
that they have hundreds of lines or more or if there is a good number to
stop at.

Thanks!

Aaron

Neil W Rickert

unread,
Jan 16, 2002, 11:09:54 PM1/16/02
to

I seem to have 3169 lines at present, and I haven't yet thought of
stopping. (Some of these lines are generated by cidrexpand -- I have
around 690 non-comment lines before cidrexpand is run).

I did move to a dbm file instead of nis+, because of the
size. As far as I know, dbm can handle over 100,000 lines without
any problems, and hash should be able to handle over 100,000,000
lines (if your disk is big enough).

J

unread,
Jan 17, 2002, 3:41:36 PM1/17/02
to

I've got 1831 "553" entries before cidrexpand, 2026 lines overall. 3455
"553" entries after cidrexpand, 3650 overall. Seems to be working fine
for me. I've been pleased.

J

0 new messages