[AccessD] Access 2013 -- MDB Back Ends Dead?

Jim Lawrence accessd at shaw.ca
Sun Jul 22 17:12:56 CDT 2012


Hi Mark:

Are you using direct OLE-ADO? Are you using SPs? Are you using recordsets?

Jim

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mark Simms
Sent: Sunday, July 22, 2012 12:35 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Access 2013 -- MDB Back Ends Dead?

Re: " speed is much better "....Sniff, sniff..boy, do I smell something.
My last benchmarks with Access with SQL Server backend had great speed For
RETRIEVALS (4x faster). Horrible speed for inserts (10x slower).

This was back in the SQL Server 2000/2005 days. Naturally, this could have
changed with 2008.


> "Speed is a whole different ballgame now. Since 2013 now uses SQL
> Server to
> store the data, speed is much better, even over larger recordsets.
> Also,
> aggregrate queries are supported again. Overall from what I've seen,
> database size and speed are not concerns anymore."


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list