We are limiting the memory using sys(3050).

I am interested in looking at the Case study. Can you point me in the right direction?


>There used to be a Case Study on the MS site about a hospital whose primary DB was SQL but they offloaded all reporting to run in VFP for performance reasons. Maybe there're some more tricks in there..
>>>>We have a web app which needs to support up to 100 plus users. We have multiple web sites that all use basically the same code. One of the websites has a table with 2.5 million records about 350mb. There is one summary report which if pre-digested will run very quickly on the web.
>>>>
>>
>>The web server and the data base server are both using VFP.
>>
>>Having a separate machine may be the way to go even SQL server, but we have to convince our client that we have run out of options in improving performance. We also need to make it very clear that even 2 seconds is too slow on a web app. It only takes a number of hits that all take 2 seconds and the site can slow down to a crawl.