Gossamer Forum
(Advanced Search)
for
Home : Products : DBMan : Discussions :

DB size limit?

Jun 6, 2001, 8:49 AM
lubatico
User (64 posts)
Jun 6, 2001, 8:49 AM
Post #1 of 3
Views: 2774
Shortcut
Quote Reply
DB size limit?
HI. Just a few short questions:

1)Is there a size limit for DB man files?

2)Is it better/safer to have many short fields or few long ones?

3)What is the probability of data corruption on your db? I'm afraid of filling up a database and having it go to waste!

Thanks a bunch :)

Jun 6, 2001, 4:55 PM
AstroBoy
Enthusiast (720 posts)
Jun 6, 2001, 4:55 PM
Post #2 of 3
Views: 2702
Shortcut
Quote Reply
Re: DB size limit? In reply to
1) From the readme:
Code:
This database is quite fast considering the information is stored
in a flat file text database. There is no upper limits on either
the number of fields you can have, or the number of records. Search
speed will slowly degrade as your database grows. You can expect reasonable
performance for database approaching 1 MB though.
DBMan SQL however, is signifigantly faster, and hos no real limit as to database size.

2) I don't think it really matters, it depends solely on your own preference. Many Shorter fields will make for more searching capabilites etc, whereas Fewer Longer fields may make data entry a bit easier.

3) As long as your using file locking and don't to too much hand editing of the raw data, the chances of corruption are practically nill.

- Mark


Astro-Boy!!
http://www.zip.com.au/~astroboy/
Jun 7, 2001, 7:12 AM
lubatico
User (64 posts)
Jun 7, 2001, 7:12 AM
Post #3 of 3
Views: 2696
Shortcut
Quote Reply
Re: DB size limit? In reply to
Thanks a bunch

It helps a lot :)

Luis