> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Charlie Coleman > Sent: Monday, March 24, 2008 10:41 AM > To: [EMAIL PROTECTED] > Subject: Re: VFP and PostgreSQL used to process FTC DoNotCall updates > > > 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.
At one point I was considering a partition/UNION approach, but my needs go far beyond just the utility app I have in taking all the Area Code/Phone Number records and building out a set of update tables for my client machinery. I have several other commercial applications that I want to alter so I can handle some larger single database solutions, as opposed to splitting dealerships up into separate databases (for multi-location and multi-franchise operations that want to get consolidated reports and have a single set of tables to use to get info on one or more stores easily). Another application is hugely disk consumptive, and I have been putting off having to cut that over to a SQL solution just because of time limitations. But the time is almost here where I will have to do something with that as well (document archiving solution). On the other hand, I wanted to start using a back end that has built in security, hot backup and native high performance capabilities for thin-net environments. I could use VFP with parameterized views to get the thin-net piece of that done, but I would also be bumping the edge (or pushing over it) with my 2Gb file limit. I could (and have) write a hot backup/data synchronization for VFP tables (which worked well in the past, I named it Cross-Fire back in 1996), but I would still have to get exclusive access to the tables to rebuild the indexes before or after doing my table backups. It just felt like I was outgrowing what VFP is designed to do in its File Server based offering. Hence the search for a SQL back end solution. But, I still want to use VFP as a front end, and use VFP tables for configuration and internal data lookup purposes. At least for now. At some point I need to look at Dabo as I plan to start doing my automated (daily) commercial data translations on a Linux platform. Although Ed and I (Mostly Ed. Okay, all Ed! Geez!!) did succeed in getting some of my compiled VFP apps to run under Red Hat via WINE/CrossOver Office, I would like to eventually get away from depending on WINE/CrossOver Office in case M$ comes after me chucking spears for violating their EULA re: running compiled VFP apps under Linux (without a separate, even if unused Windows OS license). All-in-all I am very comfortable with my decision to move in the direction I chose. It took me a few years to pick away at a solid direction, I had a few starts where I had to go back to the start of my SQL journey (Firebird, MySQL) for one reason or another. But for my purposes PostgreSQL just feels like it has what I need, and blends in well within my little world. Speaking of "worlds" (warning, almost-[OT] diversion ahead), I was working on an Ubuntu Linux installation the other week and tested the audio card & speakers by lighting up one of the audio apps they include in the basic 7.10 installation. I lit up Virgin Radio, Classic Rock, which is one of the choices I had at hand, and heard a cut I had not come across for many years. Some of us older rockers will remember "Arthur Brown", and his "The Crazy World of Arthur Brown" album, and its chart topping hit "Fire!" This is the cut that starts off with a shouted proclamation, "I am the god of hell-fire, and I bring you FIRE!" What memories that evoked. I dug up some YouTube clips, and watched the precursor to Alice Cooper put on a wonderful rock show with that particular cut. Anyway, almost-[OT] diversion is now ended. Enjoy listening once you find a clip of his tune. (he still tours and performs, in his 60s now). Gil > > > [excessive quoting removed by server] _______________________________________________ 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.
