View Single Post
  #2  
Old 11-06-2007, 11:39 AM
ashwken ashwken is offline
Registered User
 
Join Date: 10-16-2005
Location: Blairsville, GA USA
Posts: 431
I guess I fall into the category of Many Databases, but they would not be considerd small, and they contain many different types of Items. It's more segragation by Topic or Useage.

For example:
I have a separate database for Tracking Leads, and a separate database for Tracking Listings. The useage is different although both deal with aspects of the Real Estate business.

Another situation:
I've got one database for a particular comic book series, and another database for the original stories that the comic book issues are based. Both of these databases are in the development stage, but will eventually be merged to take advantage of Linking.

I've been avoiding the Hoist function until the bugs are worked, that point my be approaching soon. This will make large databases more managable.

Another issue with large databases:
Currently, I can only burn to CD, which places a phyical limit on what I can backup. Granted, a DVD burner is in the future, but for now...

I don't think that there is a single "Best Method", just depends on your needs.
Reply With Quote