VB using "SQL SELECT" or "Recordset.Seek".

See more:

VB

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.