Kenneth Kixmoeller/fh wrote: > On Apr 9, 2008, at 5:08 PM, Jeff Johnson wrote: >> Has anyone built an application using this technique? > > I agree with Paul, but if you are running into size issues, one step > short of going to a server-based DB (or as a stop-gap until you do) > is to split the table vertically. > > I think splitting horizontally (by month or whatever) is generally a > bad idea. Vertically isn't that great either, but it is far less > disruptive to an old style VFP application that isn't set up for > diverse data engines. Screens and reports can be hacked > programmatically to accommodate the added table.
Horizontal splitting makes sense sometimes, like when it is the same data structure for x number of customers, where each customer only sees their data. Better to have separate databases for each than to risk one corruption spreading to everyone. Paul _______________________________________________ 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.
