Ms Access Query

[KEK1205]

I am developing our intranet system with asp & ms-access 2003 & window 2003 server.

I have a problem to query from ms-access 2003.

When i query information of employees, it takes too long.


my query : select * from table where Last_Name like '%KK%'

i think the problem is to use keyword "like".

i just test simple "select * from table where Last_Name='kk'" is really fast.

If somebody have any idea, could you tell me

[idsanjeev]

The query like %kk% serch and display all records thats have kk anywhere in last name
but in ='kk' means only used kk in last name
so i think thats the reason to taking time and depends on how many data in you table


Jha

[KEK1205]

I know it takes time to query but too slow.

I tested it in win 2000 that was slow and then i installed in 2003.

It is really slow... so maybe i thought maybe system problem....

[DrBunchman]

How many records are in the table(s) you are trying to query? A LIKE will be slower than using an = but assuming that your query isn't too complex it shouldn't be that much slower.

Dr B

[KEK1205]

There are about 7000 records..it's slow. Maybe it takes 15 second...
I don't know that Querying with used "LIKE" could take time....like those time.
But i don't have choice..now.