Hi,
I have the following problem :
when I launch a query in the query analyzer I have my results within 3
seconds, and when I monitor the MSDE through the Profiler I see that he does
some 8000 reads to get his results.
When I launch the same query in a Delphi application using ADO (it's even a
test application, I only have this one query) the query runs for a minute
and in the profiler I see that he does 2.300.000 reads to get the same
result.
I only have this problem since I've updated my database, I've added some
tables, views ...
When I restore the same database on an SQL-Server I don't have this problem.
I'm really puzzled, I know that MSDE has a performance throttle but I don't
have 2GB of information and I'm the only user.
Any ideas ?
Hi Kurt,
If the queries and data are identical, the other difference could be the
query plans generated. You may need to rebuild your statistics so your
indexes get used appropriately.
Look at UPDATE STATISTICS and CREATE STATISTICS in BOL.
HTH,
Greg Low (MVP)
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Kurt Duyck" <kurt.duyck@.hdp.be> wrote in message
news:OnNckyrWEHA.500@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I have the following problem :
> when I launch a query in the query analyzer I have my results within 3
> seconds, and when I monitor the MSDE through the Profiler I see that he
does
> some 8000 reads to get his results.
> When I launch the same query in a Delphi application using ADO (it's even
a
> test application, I only have this one query) the query runs for a minute
> and in the profiler I see that he does 2.300.000 reads to get the same
> result.
> I only have this problem since I've updated my database, I've added some
> tables, views ...
> When I restore the same database on an SQL-Server I don't have this
problem.
> I'm really puzzled, I know that MSDE has a performance throttle but I
don't
> have 2GB of information and I'm the only user.
> Any ideas ?
>
sql
No comments:
Post a Comment