>Hi,
>
>We have a client that we've done an application for. The App has grown since we started it, and now it looks like they will be doing approximately 25 million records added per month and approximately 300 million per year. Does anyone have any info on FoxPro's limitiations (if any) as to number of records in a table? Has there been any studies done on tables this large?
>
>TIA,
>
>Rod Lewis
>MS Consulting, Inc.
>Minneapolis, MN

The maximum number of records for a table is 1 billion, and the maximum file size for a table is 2 gigabytes. Take a look at the help file. Search for Visual FoxPro System Capacities. It should give you all the info you need. With tables that large, you may want to look at client server.