SQL2005 Express twice as slow as MSDE2000. How do I increase the performance of SQL Express?
Posted on 2006-11-13
Since upgrading from MSDE to SQLExpress it seems that writing to the table is at least twice as slow.
I am running a P4 2.8 Ghz with 512Mb with winXP fully serviced packed.
FYI. We have an application that writes to 2 tables and when we run the app again for a fresh set of results it re-creates both tables.
Any pointers would be really helpful.