Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Windows 7 with SQL Express 2005

04 Feb 2010   #1

Windows 7 with SQL Express 2005

We have a test computer that we are using to test out various software applications. This one in particular uses SQL Express 2005. The test computer is Windows 7 Pro, 32-bit OS - 2 GB RAM - 2.40 GHz processor. Is there any known issues relating to the speed of an insert/read from SQL 2005 with Windows 7? I can put the same application on an XP machine and the database reads/writes are quick; but on the Windows 7 machine, they take quite a few seconds (~15). SQL Server is local on the test computer.

My System SpecsSystem Spec

05 Feb 2010   #2

W7 X-64 W8.1 X-64 Opensuse 13.1 W2003 Server

Hi there
put the DB indexes on to the fastest disks , as well as some very often accessed table spaces -- especially if these are used primarily for READ.

I think your problem isn't the SQL or Windows 7 but probably the hardware.

Your XP running system has probably been reasonably optimized for running the SQL or might have SCSI or fast disks - without knowing the hardware its impossible to say.

Your Windows 7 machine might have horribly slow disks in it too -- this will slow down considerably ANY complex DB query.

If you can beg borrow or steal (did I say that) an SSD and can get the Windows page file and the DB indexes on to it it will FLY like greased lightning.

My System SpecsSystem Spec

 Windows 7 with SQL Express 2005

Thread Tools

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 08:48 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33