Re: Speed of SQLExpress vs SQL2005

If this is the first transaction you run and if you're the only one logging
on, then it's probably an autoclose issue. By default, SQL Express
databases are autoclose to minimize resource usage. That means the first
query you run after login on will take much longer because the database has
to be started. Try measuring the second query or turning off autoclose on
the database.

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm

"Andrew J. Kelly" <sqlmvpnooospam@xxxxxxxxxxxx> wrote in message
news:OehYuISnGHA.1044@xxxxxxxxxxxxxxxxxxxxxxx
Did you update the statistics after you restored the db? If not try
running sp_updatestats. Also make sure you run it multiple times to remove
any caching issues.

--
Andrew J. Kelly SQL MVP

"Brad Carroll" <BradCarroll@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9CAE113A-521E-456E-A45B-6763798F0CE7@xxxxxxxxxxxxxxxx
I have been tasked with testing SQLExpress with my companys software and I
am
running into a speed issue with SQLExpress. I have ran our applications
with
no problems on SQL2005 developers edition but once I uninstall it and
reinstall SQLExpress the performance problems are back. I have ran a
trace on
both versions and I am seeing vast differances in the times for the same
exact querry.
0 ms on 2005 and 550 ms on SQL express. I am running both tests on a 1
Ghz
machine with 512 MB of memory. Both tests are using TCP/IP protocol
Anyone have any ideas?




.

Relevant Pages

  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... But SQL does not have a pointer data type or the ... > being told to design a database. ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: DBMS and lisp, etc.
    ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database. ... (eq (order-customer orderA) ...
    (comp.lang.lisp)
  • Re: dbdebunk Quote of Week comment
    ... > a lot of really bad SQL programmers. ... a surrogate key should support the primary key. ... But SQL does not have a pointer data type or the ... > being told to design a database. ...
    (comp.databases.theory)
  • Re: dbdebunk Quote of Week comment
    ... But SQL does not have a pointer data type or the ... More and more programmers who have absolutely no database training are ... But why is little Cindy Lou Who employee ...
    (comp.databases.theory)
  • Re: Just say no to threads [Was: Software architecture]
    ... they knew there was going to be a database in the app. ... Now my colleague just spent a couple/three weeks designing an SQL ... Turns out they have a flat file of sample information, ...
    (comp.object)