million plus records

million plus records

Post by JGel1 » Fri, 17 Feb 1995 11:52:44




>Date: Wed, 15 Feb 95 08:09:18 +400
>How well does FOXPRO handle 1 million plus records on an NT server?


     Although you may have to be clever about programming style, I
regularly work with db's up to 15 million records in Foxpro. The biggest
drawback seem to be that Fox can't load all it's indexes into memory, even
with 64 meg installed, especially when doing an SQL operation with a 15
mil db related into a 6 mil db related into a .... you get the point.

    The point is , Fox does handle very large databases reasonably well.