At 02:53 AM 3/24/2008 -0400, Gil Hale wrote: >Well, it finally happened. The source data DoNotCall files I download from >the FTC monthly for clients finally pushed over the 2Gb file size limit for >the Area Codes used by my clients! Luckily I saw this freight train coming ...
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). But if you don't need the easy portability of the VFP data store, and you don't need to worry about licensing, playing with SQL back-ends works. :-) -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.
