Raj,

>In my previous thread about any plans to Increase Table Size from 2GB.

To go bigger than 2gb in VFP, you have to split the tables either vertically (by columns) or horizontally (by rows).

Of you can move the data to a SQL backend.

>I remember Martin Salias Mentioning about he has a database table with 30 millions records in it.

30 million rows is not that much, I've worked with one dbf that was 80 million rows that was no where near the 2gb limit, and one table of 2 million rows that was right at the 2gb limit.

The 2gb limit is a function of # of rows * width of the row.

>we are storing the OCR data to the table, we have a search by string in VFP form.

You have a daunting task ahead of you, to provide text serach over that many documents. You might want to think in terms of storing the documents outside any table. Create a table of DocumentIds and file locations. A table of WordIds and words. And then use a join table that links words to documents.

You might also consider using SQLServer and it's full text search engine.