Rajesh,

The short answer is "it depends." There are a lot of issues that can affect performance in VFP or a server database. VFP will perform best when you have powerful workstations and a fast network. SQL Server and Oracle will do best with a very powerful server. Also, in client/server you should try to limit the number of records you retrieve from the server. Instead of bringing the whole table down from the server, you're better off having the user enter some search criteria and bringing only the records that match the user's criteria down from the server.

Of course, your knowledge of how to tune any system for peak performance will have an impact on how well it performs. Every system has different ways of using indexes and performing queries. Understanding how your platform works will help you use it at its peak efficiency.

Over all, I've found that if you have a fast network VFP will perform a little bit better than SQL Server. If you're using a WAN, a well written SQL Server application will be much faster.

>does useing backend like sqlserver or oracle slow vfp
>than using dbfs.