I suspect speed may suffer as it gets large, since there aren't really any memory-based indexes, Rushmore, etc. Obviously security is a problem because a flat file can be brought up in any editor and someone can remove/add/alter bytes, change record length, etc. Then of course there's the inability to add/change field definitions, etc.

Just some thoughts,

HTH.


>A while ago I spent a day building a little app for a colleague. It was more a prototype than anything and it was only a test. It had 95 fields in one large flat table. Well it turns out he has been using it and there are now a few thousand records. It is not a professional program and he doesn't want to change anything since it is working fine. What problems can he expect if it keeps on growing? The fields are mostly numerical.
>
>Thanks,
>
>Vim