Skip navigation

Why is SQL Server slower than Access/FoxPro/DBase etc.

A. Twofold :-

  1. The mentioned products are great for "small" numbers of users and "small" databases. They carry very little overhead and rely on the client for record/file locking. This is great for one or a few number of users, or when data is read-only, but when many users access the system the overhead of doing locking by file offset with SMB packets is enormous, and the application will usually grind to a halt/connections will be lost/database will be corrupted etc.
    SQL Server is a true client/server app and so scales far better, but the overhead of doing all the locking etc. at the server end is far higher in some cases.
    (Note "small" is a relative term - this could be a hundred users and a 1Gb database - which is large to many people).#
  2. SQL Server logs all writes to a transaction log before it writes to actual data pages. It also (with 6.5 and below) has to update indices when records in the main table are changed due to page splits etc. This overhead is great for consistency and reliability, but not for raw performance. This logging cannot be turned off.

TAGS: SQL Server
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.