> > I have to search for field5 in some DB files (30 or more for a total of 50 GB > of space and 150 M of records ). > > The DBs have the same structure. > > I want to find the string (if exist) in all DBs. > > The query is like this: > > > > select * from main where field5= "AABBCCDD";
Did you put an index on field5?
