I mean, how fast is it in relation to the number of records?? when does it start to lose performance???
thanks in advance !!!

This really depends on the following server-client features and database size and configuration:

Server: (Hosting Company Equipment)

1) RAM: Anything less than 128 will slow down the processing of data.

2) Processor Type: Pentium is the best. But anything less than Pentium II will surely decrease performance.

3) Connection to Net: If your server is not connected to multiple T-3 or T-1 lines, then performance will surely falter. Also, it depends on switches and routers. The more data and bandwidth that they can hold, the better.

Client: (User's Equipment)

1) RAM: - Anything less than 64 MGs will surely falter performance.

2) Processor: Anything less than a Pentium II processor will falter performance.

3) Connection to Net: Ideally, anything less than 56K will surely falter performance.

Database:

1) Size: Typically, under the flat file ASCII file structure, CGI scripts cannot parse data effectively that are larger than 1 MG.

2) Configurations: Scripts, like DBMAN, cannot support large number of fields for flat file ASCII structure, around 150 fields. Of course, the more fields you have, the longer the download time will be. Also, the more dynamic drop-down menus you have (especially ones that utilize pulling data from all records and build a drop-down menu), the longer the download time will be.

Hope this helps.

Regards,




------------------
Eliot Lee....
Former Handle: Eliot
* Check Resource Center
* Search Forums
* Thinking out of the box (codes) is not only fun, but effective.

I am not sure if this will interest you, but I have three test databases set up, one with 3600 records db size 200k, 19000 records db size 1.1 megs, and 57000 records db size 3.3 megs.

There are nine fields, two of which are one character. My hosts server is Dual III 600's
512megs ram serving about 300 domains.

You are welcome to view/search or add items.

Login is test and password is test.
lm = 3600
mm = 19000 records
bm = 57000 records

http://www.fastcom.uk.com/cgi-bin/db/bm/dbmanloadtest.cgi?db=lm

http://www.fastcom.uk.com/cgi-bin/db/bm/dbmanloadtest.cgi?db=mm

http://www.fastcom.uk.com/cgi-bin/db/bm/dbmanloadtest.cgi?db=bm

rog

Thanks for the real world example... I found it most useful.

------------------
The Immuatable Order of Modding
-=-=-=-=-=-=-=-
1. Read the FAQ, 2. Search the board, 2a. Search the board again, 3. ask the question, 4. back-up, 5. experiment, 6. rephrase question (or better yet, post solution to original question)