>I have a paradox database which needs replacing this year. It is single-user to run on a laptop. I don't want to use delphi. Access is not powerful enough. The main table has 1,000,000 yep one million rows and is about 90 mb .
>
>My question is will FoxPro handle this ?
Assuming that the data can be represented with VFP's native data types, certainly; the limit on records per table and file sizes are orders of magnitude larger than what you've indicated here.
I routinesly deal with tables much larger than this (a typical trucking carrier's routing file will have ~800,000 records to map valid 3 digit zipcode-3 digit zipcode combinations, and I sometimes deal with significant subsets of the 5 digit-5 digit zip code mapping, with a few tens of millions of records in the base table), and VFP works well for data manipulation, especially where data is maintained locally on fast storage, with plenty of RAM and swap file space, or where very small subsets of the data are manipulated at any given moment across a LAN. If you're going to be in a heavy traffic multiuser environment where queries against larger tables are being run that require detailed examination of recors on a record by record basis, you may want to look at using a backend database server like SQL Server or Oracle; VFP can work with a backend in any of a number of different ways.