Hi Raj,
I have a situation where I needed to split my data into several tables. What I ended up with, was naming the tables something1, something2, something3 and so on. Then in the search routine I search all the tables one by one and add the result for all the searches into one cursor. The cursor also have a field telling me which of the somethingX table the result came from. This may sound like a lot of work, but with VFP it is very easy and very fast.
>Hello David,
>
>In my previous thread about any plans to Increase Table Size from 2GB.
>
>I remember Martin Salias Mentioning about he has a database table with 30 millions records in it.
>
>
http://www.levelextreme.com/wconnect/wc.dll?FournierTransformation~2,41,17,872674#872938>
>we are storing the OCR data to the table, we have a search by string in VFP form.
>
>Thank you.