Posted by SQL Learner on 03/02/07 03:19

Hi Ed,

Thank you for your reply. I just need to know which one is faster
since the queries that used for this project can be many. If both are
the same, then I will just use Access. This is just a one time event,
but the update queries can be slow. The example that I provided was
simplified for demostration purpose only. Let's assume, I need to run
the such query on a 8 millions records table 10 times. Give I have a
2GB Rem, with very fast hard disk and fast Due CPU, Would SQL Server
be faster? If yes, by how much?

- Grasshopper -

[Back to original message]