At 09:07 AM 3/24/2008 -0500, Ed Leafe wrote: >On Mar 24, 2008, at 9:40 AM, Charlie Coleman wrote: > > > I don't know if you thought of this, but partitioning up that kind > > of data > in multiple VFP tables should be pretty easy. E.g. 1st digit > of area > > code. Then write stored procedures to use for various update/retrieval > > calls to determine which table needs to be hit in a specific > circumstance. > > And for cross-table queries, UNION results (since the structure of the > > tables would be identical). > > Easy? Sounds more like a hack.
You do realize that some DB servers do similar things. E.g. table partitioning. Sure with VFP you have to construct more on your own sometimes. But that often gives you more opportunities to optimize for your situation. -Charlie _______________________________________________ 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.
