Re: Speed of SQLExpress vs SQL2005

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?


.

Loading