I have a program that has a lookup, my filter is
Surname House Number Town Postcode using a MDB with 600000 more r less records. I created a code that uses the
SELECT statement but it takes 8 or more seconds to view all queried data from a list. Someone suggest that use the
RecordSet.Seek.
This Record is been parse from a text file to MDB
This is the table layout using the
SELECT statement
ID | Surname | House Number | Town | Postcode
1 | Name | 10 | Town | 2121
2 | Last | 50 | AAA | 2121
3 | Surname| 101 | BBB | 3030
4 | Name | 10 | Town | 2121
If I use the
RecordSet.Seek, I will add another table for filter data
ID | Surname | House Number | Town | Postcode
1 | Name | 10 | Town | 2121
2 | Last | 50 | AAA | 2121
3 | Surname| 101 | BBB | 3030
4 | Name | 10 | Town | 2121
Filter | IDS
Name10Town2121 | 1,4
Now when I execute it to the program I will
Seek the Filter then when a record is found, I will get the
IDS then split and loop the IDS value and Seek the
ID one by one.
My question is what is more faster, using the SELECT Statement or using RecordSet.Seek.
Also I dont know how to use Seek method so I ask here first.