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.