I'm interested in learning how to improve SQL Server performance when using a consistent GUID when using Access 2007 as the interface of SQL Server 2008 (note that this is the only context that interests me).
I conducted several tests (and got some rather unexpected results, in particular, from SQL Server when using a consistent GUID : the insertion performance decreases very quickly, and it seems to me quickly.
Basically the test is as follows:
In the Access interface, using only VBA, insert 100,000 records in batches of 1000 in sequence.
- I tried this with both the identifier and the serial GUID of both the PC.
- I tried this in SQL Server 2008 Standard (without a special default setting), and also as an Access 2007 database. All tables are associated with an interface.
Some of the results (moreover, with the source data on in my blog post about the test ):
It’s clear that as the database grows, insert performance decreases, but SQL Server does not work very well here.
http://blog.nkadesign.com/wp-content/uploads/2009/04/chart02.png
Extended view of results for SQL Server:
http://blog.nkadesign.com/wp-content/uploads/2009/04/chart03.png
Edit 13APR2009
I found a problem with my server setup and I updated on my blog .
Thanks to everyone for your answers, they helped me a lot.