Access vs SQL Server – performance

I just was looking at this 14m row table.. I had a copy sitting in Jet and a copy in SQL Server.
I just couldn’t get over how slow jet queries are.

The SAME QUERY in Jet takes 140 seconds..
In SQL Server? 2 seconds!

This entry was posted in SQL Server and tagged . Bookmark the permalink.