English Boards > Support

database slower

(1/2) > >>

spanky:
if I enter the SQL Server Express as the program runs slower than with SQL Compact
why?

JohnS:
If you are running SQL express on another computer thru a network, then it's the network slowing things down.
SQL Compact runs locally, and will be faster than a network.
We run 3 terminals over wifi to a SQL Express server at one site and find its ok most of the time, but can be a little slow during peak periods, but not too slow to be negative on productivity. Site will be fully cabled when renovations are complete later this year.

spanky:
I use it locally, and still see a smaller polar response when you press a button with respect to compact sql

JohnS:
SQL Compact is a light weight standalone SQL server with less overheads than SQL Express. Maybe that is what your experiencing. SQL Express is a resource hog.

What spec is the computer you are running it on?

spanky:
PC is a AMD Sempron 1.9 ghz - 2 giga ram

Navigation

[0] Message Index

[#] Next page