MySQL Forums
Forum List  »  Delphi

Re: searching from memory table
Posted by: arslan m
Date: November 24, 2006 06:27AM

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?

Options: ReplyQuote


Subject
Written By
Posted
November 23, 2006 11:05PM
Re: searching from memory table
November 24, 2006 06:27AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.