I forgot to advise the ProFox group of the apparent latent impact on my Dell sc430 Server when I hammered it so heavily processing a huge number of Federal Do Not Call records the other week. The sc430 runs Windows 2003 Server, and had 1Gb DDR2 ECC RAM (512mg x 2, from Dell). I noticed the morning after running the VFP processes used to update dbf tables for distribution to clients, drawing the client record sets from the PostgreSQL database, my scheduled morning VFP TranslationEngine app was running dog slow. I checked the sc430 Server and found it had not fully released the RAM it ate up running the PostgreSQL processes - likely because I still had that app (and PostgreSQL tables) open so I could tweak it "later on". Upon closing the DoNotCall project the sc430 Server RAM climbed back to where it normally runs.
So, in an effort to prevent poor performance issues, and in keeping with all I have read about PostgreSQL performance and how to enhance it, I ordered 2 1Gb DDR2 ECC RAM chips (installed them this afternoon). I will be processing the DoNotCall updates again next week, using the VFP project that interfaces with the PostgreSQL database. Assuming anyone cares to know what happens with the performance with the additional RAM I will report the results, even if somewhat anecdotal. The sc430 can handle 4Gb RAM, but I wanted to see how this does first. After that little experiment I plan to migrate the PostgreSQL database from the Windows 2003 Server to a Ubuntu Linux v-7.10 Server with a "paltry" 1.5Gb RAM in it, just to see how it performs in comparison. Both Servers have an Intel P4 2.8Ghz Dual-Core CPU, the Dell has 3Gb RAM and uses a non-boot SCSI HDD for the PG database, the Compaq has 1.5Gb RAM, and uses its boot SATA HDD for its PG database. Both Servers can be pumped to 4Gb RAM if need be. Let the games begin! heh-heh... This is too much fun. Gil > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of Gil Hale > Sent: Tuesday, April 01, 2008 11:50 AM > To: [EMAIL PROTECTED] > Subject: [NF] RE: Microsoft New SQL OS > > > Brat! I was about to cut from PostgreSQL to the new SQL OS because I > thought M$ finally did something right. Grrr... > > Gil > > > -----Original Message----- > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Behalf Of Alan Bourke > > Sent: Tuesday, April 01, 2008 6:33 AM > > To: [EMAIL PROTECTED] > > Subject: Re: Microsoft New SQL OS > > > > > > 2 things! > > > > April Fool, and XP SP2 is as bug free as any OS I've used. > > > > [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.
