Visual FoxPro is one of the fastest database program in the market. It is used for small scale database applications. Its limit of 2GB for its database tables makes it for small scale only. It does not have a feature that secures the data (unlike MS Access you can assign a password for your database). I will recommend Visual Foxpro + MySQL5 + FreeBSD or LINUX platform to solve this kind of problem and boost the speed and data security of client/server applications for a smaller fee (actually MySQL5 and FreeBSD or LINUX are all downloadable for free from their respective websites. Of course, you can purchase a copy of Visual Foxpro from Microsoft
).
This combination for me is more practical and cheapest compare to other software combinations.
For Filipino computer programmers and students studying DBMS and Visual Foxpro, you can start the study of MySQL and FoxPro combo by installing first the MySQL5, MySQL .NET Connector and other MySQL GUI Tools. Download all this programs and tools from the official website of MySQL.
Then look for the topics from the help file of Visual Foxpro regarding the SQLCONNECT and other SQL commands. Study the topics that deals with creating Remote Views and Local Views. That will be the beginning.
If I have time after I'm done with my recent project, I'll try to prepare a demo program that uses this combo. For FreeBSD, visit their website at www.freebsd.org for info and downloads. Good luck
I want check the speed
Posted by pancha at April 3, 2008, 11:06 amthat gives me an idea, might try that one on this days, you can also consider using cursoradapter for remote data sources, it’s easy to use.
Posted by leycer at April 29, 2008, 1:42 pm
very god iam glad
Posted by muratno at May 18, 2007, 7:14 pm