>ok my question is that i already have a program running with the dbf database and i want to change the database to be more fast. So do i have to redo all the program for the database access or can i do something more fast
>
>thanks !
If you want performance, there are some ways you can do to make it faster.
1. Upgrade your server to dual processor server or more.
2. Add more RAM.
3. Make your database server to used RAID 5.
4. Store lookup tables to your local machine.
You can increase your program access to your database by doing this. As a matter of fact, access to native VFP data is a little bit faster compare to MS SQL Server. When you want data integrity and no data limit, proceed in porting your VPF local data to MS Sql Database Server. You also need to update/change your code when you decide to use MS Sequel Server.