>Depends on your design, the amount of data and the stability of your system.....! The total size of our tables including FPT and CDX is about 4GB, and I have had only one (o-n-e) crash is 20 years which forced me to pack and reindex. And this is a 24/7/365 system, and only DBF tables.
We're not that lucky. We keep getting Invalid Seek Offset problem with the older version of the program, which is currently in production. Since I don't know, what change that I made eliminated the problem, we may have to repeat shooting in the dark. In the meantime we have to repair database every time it happens...
If it's not broken, fix it until it is.
My Blog