On Mon, Jul 7, 2008 at 8:15 AM, Ed Leafe <[EMAIL PROTECTED]> wrote: > On Jul 7, 2008, at 8:04 AM, Stephen Russell wrote: > >> per database, so you could have 15 + databases for a single >> application > > Oh sure, and we can split VFP tables so that they are all under the 2 > gig limit, too. But this is a hack; there is no reason to have 15+ > databases in an app, and lots of reasons not to. Permissions and > security come to mind, as well as join speed, journaling, backups, etc.
---------------------------------------------------- all of the areas of the business have their own database. ShippingSystems = data for getting a package shipped OfferingSystems = What we sell. With TONS of meta data ties customers to rules they themselves create. OrderSystems = orders that customers make with us PaymentSystem = AR data. UserSystem = Customers. the list goes on and on. I now have very well normalized tables that are normalized to the area of business they perform. It sounded dumb at first but it is very well laid out. -- Stephen Russell Sr. Production Systems Programmer Mimeo.com Memphis TN 901.246-0159 _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[EMAIL PROTECTED] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
