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. Just a little question. Why would you save the selection as a text file? Wouldn't it be easier and faster to save it as a dbf table considering it will be used by another VFP application?
_______________________________________________ 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.
