• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 14. SQL Server Integration > Comparing MSSQL Server 2000 Desktop Engine...

Comparing MSSQL Server 2000 Desktop Engine to Jet

Besides the obvious advantage of the SQL Server compatibility of the desktop engine, some might be tempted to ask, “Why not just stick with Microsoft Access?” You can always upsize later. Both Jet and MSDE 2000 are designed for small workgroup environments. Both technologies have a 2-gigabyte file size limit.

Better Performance

For starters, even in a small workgroup environment, MSDE 2000 has a performance advantage over Jet because the queries are processed on the server rather than on the workstation. Only the data processed from the query is moved to the workstation using the server. In addition to this, in a client/server setting, the server typically is installed on a more powerful machine. Because the server handles the processing requests, the load is shifted from the client machine.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint