With more than 100,000 Record, Locate Methode is Lame duck...How to Get higher speed in searching progress....
Posted on 2001-09-04
I?m writing a code with A Medium size table, ?Member? Table. Problems I have encounter is that I try to create Search-Form to provide user interface by letting user key in MemberId in Edit Box and write OnChange Event of EditBox. Form only have a DBGrid with 3 Columns of MemberId, MemberName, MemberSurname. But searching speed suffer user too much and make my Search-Form lame duck...By using a Locate Methode, I?ve created Index Name ?Member01? in which indexed on Field ?MemberId? but it?s still Run with too bad speed
I wonder if there?s anyway to write a Search-Form to provide user interface by entering a MemberId and Dataset move to Such Record first found
For example, Table contain 3 Record
Record 1 MemberId = 0001 MemberName = Name01 ....
Record 2 MemberId = 0101 MemberName = Name02
Record 3 MemberId = 0201 MemberName = Name03
If User Key in 01 Form Must move RecordPointer to Record 2, if User Key in 02 RecordPointer must move to Record 3 and So on...
What I want is that Record 999 Form Must move Record Pointer to Record of MemebrId 99900 Within 2 Seconds At least on Pentium II-400 , say, must be faster depend on Spec of Computer running it. Any real expert out there Show me how to do so, I?ll give you 200 points