Re: searching from memory table

[arslan m]

dear martijn tonies thanks for your help i am from turkmenistan my english not so much good i will try to explain you
i am using delphi 7 and ehlib 4.01.

there is more than 200,000 records in my table and my program is multi user program and i want to do my program is very fast

now i am selecting my data to my memory table:

procedure Tdm.mnotesBeforeOpen(DataSet: TDataSet);
begin
q1.Close;
q1.SQL.Text:='select studentname,birthdate,class from studentable';
qspr.Open;
mnotes.DataDriver:=drv;
end;
after this i want to search data from my memory table
i am tryying with

memtable.locate()
memtable.fields.fieldbyname('studentname').asstring:='Alan'
how can i search very fast
could you mind to help me?