My understanding is that one cannot compare this two. Foxpro is an open
file based DBF system (like MD2). A bit of trivia, it originates from
Fox Software purchased by M$ circa 1992 and pre-dates Access and MS-Sql
(designed by Sybase not M$) during the times that M$ was trying to build
a database product and customer base.
Foxpro features a max address space of 2GB (up to 4GB in some configs)
and it does not provide real Sql features such as replication,
interleaved or nested queries, etc.
Foxpro features an inbuilt db engine intended for RAD and not meant to
be a stand alone DBMS, rather is meant to be a front end to the real
thing (MS-SQL).
In fairness to Foxpro, I understand it is fast and easy to develop with it.
mario
Greg Twyford wrote:
MD3 appears faster from a client, with it's sample database, because all
the processing is done on the server, and only commands and display of
resulting data goes across the LAN. MS SQL might be more efficient than
FoxPro as well, who knows.
Greg
_______________________________________________
Gpcg_talk mailing list
[email protected]
http://ozdocit.org/cgi-bin/mailman/listinfo/gpcg_talk