Essentially, this is the workstation I put together recently for myself. If you or your client have the time, and don't mind getting your hands a little dirty, you can put together a fairly nice workstation for around $950.00 or so; mouse, keyboard, video console and video card not included. The motherboard may have all the video hardware you need already built in, but if not, you can alway add a video card. Once you have the basics in place, it's easy to upgrade/replace components that wear out or become obsolete.
I'm running Fedora 11 on mine workstation, and it works beautifully. 1) ANTEC P182 ATX mimi-tower case for $136.98 http://www.mwave.com/mwave/SKUSearch_v3.asp?px=FO&scriteria=BA50047 2) ANTEC TP-750 for 83.29 http://www.mwave.com/mwave/deepsearch_v3.asp?scriteria=antec+tp+750&ALL=y&TP= mwave will assemble case and power supply for free. 3) Two Western Digital WD500ABYS enterprise class drives for around $83.95 x 2 = $167.90. These drives cost a little more, but they are fully tested, (eg burned in), so reliability is partically guaranteed: http://www.wdc.com/en/PRODUCTS/Products.asp?DriveID=489 http://www.mwave.com/mwave/deepsearch_v3.asp?scriteria=wd+500gb&ALL=y&TP= 4) ASUS M4A78T-E AM3 AMD 790GX ATX motherboard with PHENOM II X4 925 2.8G, and PHENOM II X4 925 2.80G and CORSAIR 4GB KIT CMD4GX3M2A1600C8 with CPU and memory fully assemble and tested from mwave.com for around $430.96. http://www.mwave.com/mwave/SkuSearch_v3.asp?scriteria=ba31314 http://www.tigerdirect.com/applications/searchtools/item-details.asp?EdpNo=4444096&pagenumber=0&RSort=1&csid=ITD&recordsPerPage=10&body=REVIEWS#ReviewStart Regards, LelandJ On 11/15/2009 01:18 PM, John Weller wrote: > Hi Guys, > > I need some advice on a hardware spec. > > My client has just had the requirement to make simple selections from a > database containing about 11 million records, about 3.5Gb. Obviously this > is well outside VFP's limits so I have looked at PostgreSQL and am quite > impressed. I have managed to set it up and import data and then make simple > selections using SPT. > > He is looking to buy a new workstation for this job. It will be networked > in a small peer-to-peer system. The data will be downloaded every quarter > and will then be imported in to a PostgreSQL table. The data will not be > changed in any way. Selections will be made using SPT from a front end I > will build in VFP9. The selection will be saved as a text file which will > then be imported into an existing VFP app for further processing. All of > the action will take place on the new workstation. He has asked for my help > in specifying the new workstation. Cost is an issue so I don't want to make > the spec any higher than necessary. RAID is not required, nor backup, as > the data can be downloaded again at any time. The selections are processed > almost immediately and the files then discarded. My first instinct is a > dual-core processor with as much RAM as possible, perhaps 8Gb, however I > remember an instance about 10 years ago when we gave machines so much RAM it > slowed them down as they were spending more time managing the memory than > they were processing and I don't want that to occur again. > > Any comments on the spec gratefully received. > > John Weller > 01380 723235 > 07976 393631 > > [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.
