Hi,

Is there a known problem with Access2000 and queries??
It;s unbelievable to me that the same query is slower with jet4/access2000
than jet35/access97.

Is there anything i can do to speed up the queries?? Do i have to optimize
the queries in a special way??

The effect raises with the number of returned datasets, the number of joins
and the order by - statement.

i think its the Jet-engine.
Thanks for any help / information.

BTW: Table-Access is faster with Access2000 and works fine!  i dont use Jet4
with access97-dbs.

regards, Yves

Thanks for all the replies ;)

Well, as we figured out here, queries with 'like' and no joker are much
slower with Jet 4.0.

e.g.

Select * from atable where astringfield like "avalue"
is much slower then
Select * from atable where astringfield like "avalue*"

Well, i know it's somehow more bad style than a 'bug' but it's a pitty
anyway.

Just wanted to let you know...
regards, yves.
"Yves Duenow" <duen...@lauer-fischer.de> schrieb im Newsbeitrag
news:8v3t7d$i9i9@bornews.inprise.com...