General information
Category:
Coding, syntax & commands
>>Is there any simple way to enhance the Limit of VFP DBF table beyond 2 GB Capacity ?
>
>Follow a few round rules, and this will not be any problem for a normal size application.
>
>1. Never use general fields. NEVER!!!
>2. Never store pictures in tables, only the name of the picture file, with or without path
>3. Normalize the tables, don't add fields which are seldom used.
>4. Reuse deleted records
We just generate one daily day-end invoice with our retail application with merge all sales but it crush 2 GB barrier every year. If we would be create a record for every POS transactions it would be crush almost every week and also we use deleted records at append new record... . :)
One solution is using a database like sql-server or oracle.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only