Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Storing 3 million pages to table(will be under 2GB)
Message
 
 
To
15/03/2004 14:05:10
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00886413
Message ID:
00886472
Views:
12
Raj,

3000000 * 2500 = 7,500,000,000 = 6.9GB. VFP can only handle 2 gb per fpt file.

You can split the data across multiple tables, or only store a filename and let the actual scanned image reside in a subdirectory structure. You probably want to architect it to keep the number of files per directory down to a few thousand per folder.

>We are planning to stire 3 million pages, each page 1 record with menu datatype.
>
>each page will have 2000 to 2500 chars.
>
>Can you please tell me is it ok to store that many pages data to table, via ocr capture.
>
>The program is working great but it is the beginning, ones they finish all the ocr of the documents its going to be nearly 3 million pages.
>
>Please give me some ideas of how to do the regular maintenance of this table.
>Thank you very much.
df (was a 10 time MVP)

df FoxPro website
FoxPro Wiki site online, editable knowledgebase
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform