Gossamer Forum
Home : Products : DBMan : Discussions :

Size and Problems

Quote Reply
Size and Problems
I have seen several threads on size not affecting DBMAN other than speed. However, I have created a rather large database (near 400 fields by 100 entries). Not all the fields are used though.

The database is being filled every few days from an offline database.

This week, the file reached its largest, around 1.6 megs. The display became messed up in several ways with no changes made to either database. Basically, I am wondering if the data has become too large to be held properly in the array. Is there any validity to this concern? (has anyone seen anything similar?)
Any help will be greatly appreciated.

Thanks

Zack

Quote Reply
Re: Size and Problems In reply to
In Reply To:
Basically, I am wondering if the data has become too large to be held properly in the array.
Yep.

In Reply To:
Is there any validity to this concern? (has anyone seen anything similar?)
Definitely and yes...basically, when flat files exceed 1.0 MGs on MOST servers, databases tend to become corrupted in terms of deleted fields and the inability to add new records....

Solution: Use the Relational Mod to break-up your datbase files -OR- upgrade to DBMAN SQL.

Good luck!


Regards,

Eliot Lee