Hello Folks, Hello JPDeni!

I want to install up to i.e. 50 DBmans in my cgi-bin directory. Do you see any problems?

how should i do this:
like
example:
www.host.com/cgi-bin/file1/dbman
www.host.com/cgi-bin/file2/dbman
www.host.com/cgi-bin/file3/dbman
...
www.host.com/cgi-bin/file50/dbman

or:
www.host.com/cgi-bin/dbman/default1.db,default1.cfg,
default2.db,default2.cfg...

What is the max recomended number of Records for on .db?

thanX in advance

Deniz

I see a lot of potential problems with the following:

1) Disk Space...let's assume that you have 50 databases with may be 250,000 bytes per each database. That would be a total of 12.5 MGs just for the database files. Now multiple the .html.pl, .pass, .cgi, etc. files and you will soon use 3 MGs for the other files.

2) CPU...calling cgi scripts multiple times depending on traffic will increase your CPU usage.

3) Relational Issues...if your goal is to relate these 50 databases...it will be highly problematic, unless you have a small amount of fields stored and you also have an easy defined db_key in each database to ensure that you maintain referential integrity and normalization of fields within records.

There are other issues...but these are the most crucial.

BTW: There is no absolute number for the number of records that your database in flat file format can support. It depends on the following:

1) Memory
2) Processor (higher the better)
3) Allocated disk space in your account
4) Number of fields in your database

This issue has extensively been discussed NUMEROUS times in the DBMAN Customization Forum.

Regards,

Eliot Lee

Thanks a lot AnthroRules,

for this good information!
I see, I have to figure out another way!

CU