Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sashafroyland
Starting Member
1 Post |
 Posted - 2009-08-02 : 15:25:13
|
| Hello,Looking for some stats to compare MS Access with SQL Server Express. Stats to include would be INSERTs per second and complex query retrieval of record sets under 500 records but involving more then 5 table joins.Also, can someone please let me know if Express utilized multiple cores on a single CPU?I'm trying to justify an upgrade path from MS Access to SQL Server and the above stats would be much appreciated.Cheers,Sasha Froyland |
|
|
ScottWhigham
Starting Member
49 Posts |
Posted - 2009-09-03 : 06:43:46
|
| http://lmgtfy.com/?q=compare+access+to+Sql+server========================================================I have about 1,000 video tutorials on SQL Server 2008, 2005, and 2000 over at http://www.learnitfirst.com/Database-Professionals.aspx |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-09-03 : 06:55:07
|
| >>Also, can someone please let me know if Express utilized multiple cores on a single CPU?no, express is restricted to one, 1gb of memory and 4gb of storageaccess is a file system, so everytime you make an update, the file is opened for I/O and then closed, everytime. Multiple transactions will just cause it to overheat quickly.MSSQL is a RDBMS and optimized for multiple I/O operations |
|
|
|
|
|
|
MS Access vs. SQL Server Express - Performance