search substring using database Fastest......?

See more:

VB

MS-Access

hii,
today m here to ask the question ...
my question :-
*i have one Database (.MDB)
items in database (90000) ,
each item is 50 to 250 (char) long ...

* one having textbox polluted with 8000(character) with no space in this long string ...
like :- ABCDEFGHIJKL.....z...etc so on .....

problem facing :-
While on search for a substring in a textbox.text compare with database item ,it took long to match 20 sec to finish ...

wat i want :-
i want to reduce this tym from 8 sec to 1 sec or .200ms

i dont know where i am going wrong ...

need a good guidance to fast this search ...

thnxxs in advance ..
_______________________________

dim line as string = textbox1.text
 
using cmd as new oledb.oledbcommand ("SELECT * from Table1 WHERE Instr('" & Textbox1.text & "', [column1] ) ",connstring)
 
cmd.parameters. addwithvalue("",Line)
 
if cInt(cmd.executescalar()) <> 0 then 
something ....  
else 
something...
end if 
<\pre>