Hi alfred,

>We are looking for benchmarks documneted for VFP 6.0/7.0. By Microsoft or any third party source. We would also like to know if anyone has large scale applications operating on tables greater than 40 million records. Today a customer requested if VFP 6.0/7.0 could handle 1000 transactions per minute. Also, if VFP 6.0/7.0 could hanlde file sizes of 40 million records. The most our applications have handled very well, is in the 10 million record range in a real working envirnoment.

I'm not aware of any benchmarks in this arena, though they are very common (but also controversial) in the server database market.

However, Seeing the amount of data and the requirements of handling 1000 transactions per minute, I think a C/S solution with a database server might be better, not only because of avoiding the 2 gig table limit, but also because of better transaction handling, OLTP, a better scalability and backupfacilities.

If costs are a factor of not going into the server database arena, I think a lot depends on how the users are connected to the database. A fast network is a requirement if the dataprocessing is not done on the server (Via a n-Tier approach). Of course the complexity and nature of the transacion is also an important factor. A simple lookup costs less time than a replace, insert or a delete)

Walter,