CODEWITHSUNDEEP
sqlms-accessvb6ado
ViTaLdZ
ViTaLdZ

Reputation: 3

slow when using Select SQL Command in Big MDB File

I'm using access 2000 mdb file with 500 MB size, when I make Select * From MyTable Where Phone=7744111 it takes too long, over 30 second to get results.

How can I increase searching performance? (I'm using vb6 and ado 2.8)

Upvotes: 0

Views: 535

Answers (1)

rezna
rezna

Reputation: 2243

index the field [Phone] - seems you're doing full scan

also try giving exact column list instead of '*'

Upvotes: 6

Related Questions