RE: MSDE Performance

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi

MSDE 2000 does not support query parallelism and some other tuning features.
If you woul have more RAM, it could cache more data, negating the effect of
the simpler query processor.

Regards
Mike

"Theo" wrote:

> Hello to all,
>
> I am using MSDE and i recently realised that the query performance is
> decreasing while db size increases. In a db table of 20000 rows a simple
> select query with 6 inner joins took 1.27 sec. to execute (XP Pro, 775 MHz,
> 248 MB). I upgraded to SQL Server personal edition and the same query was
> executed instantly. I tested it in many different pc and the results were
> the same.
>
>
>
> Could it be that MSDE performance is so dramatically lower than SQL Server?
> And if this is the case then for which applications is MSDE suitable for?
>
>
>
> Any advice is much appreciated.
>
> Thanks,
>
>
>
> Theo
>
>
>
.

Relevant Pages

  • Re: MSDE Performance
    ... Query parallelism is where SQL Server splits up a query into multiple pieces, ... The workload governor will kick in at 8 concurrent processes. ... I have found MSDE to be less aggressive when requesting memory. ...
    (microsoft.public.sqlserver.msde)
  • Re: MSDE Performance
    ... > Query parallelism is where SQL Server splits up a query into multiple ... This enables multiple parts of the ... > I have found MSDE to be less aggressive when requesting memory. ...
    (microsoft.public.sqlserver.msde)
  • Re: access query and DataAdapter have different data
    ... MSDE would have much better performance especially with stored ... > Here is the command text configured for access view AdHocItems ... > Here is the Access Query AdHocItems ... > My concern is I plan to query the access database for sums to be used in ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Performance of MSDE Vs. Access
    ... Upsize your Access DB to MSDE ... For each query paste it into Access, and paste it and modify it ... A word of warning concerning MSDE - Performance of the SQL Server ... it won't work the miracles that Oracle does. ...
    (microsoft.public.sqlserver.msde)
  • Re: Performance of MSDE Vs. Access
    ... Bigger differences as well as you work with multiple users. ... MSDE Manager SQL Tools ... For each query paste it into Access, and paste it and modify it> (only as absolutely need! ... But if you don't have numeric primary and foreign keys> it won't work the miracles that Oracle does. ...
    (microsoft.public.sqlserver.msde)