[AccessD] SQL vs DAO -- rattling cages

Step one is to define how bloat is caused. Dont think DAO or SQL figure there. 
How would the choice here bloat the database as a direct result of your choice?

Different tools for different jobs

DAO which is the default with Access 11 which indicates that even MS recogise 
thats it the better language for MDBs. SQL within an MDB yes.

ADO when working on SQL Server via ADPs and the web

SQL. Nope. When working with SQL Server on the web for instance its SPs all 
the way. Indirect SQL of course but inside the code. No.

Martin

Quoting "John W. Colby" <jcolby at ColbyConsulting.com>:

> Susan,
> 
> I think this is a non-debate.  MS tells us that SQL will perform faster
> than
> DAO, and ADO performs even slower than DAO (for MDBs).  The problem with
> DAO
> at any rate is that you have to set up loops to work with the data set
> a
> record at a time.  SQL performs operations on sets of data "all at
> once".
> 
> I have no idea why SQL or DAO would make a difference "bloatwise".
> 
> John W. Colby
> Colby Consulting
> www.ColbyConsulting.com
> 
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan
> Harkins
> Sent: Monday, March 31, 2003 12:27 PM
> To: AccessD at databaseadvisors.com
> Subject: [AccessD] SQL vs DAO -- rattling cages
> 
> 
> Charlotte and I are having a brief discussion off list of how SQL can
> solve
> some bloat problems. Now, I find SQL superior to DAO/ADO almost
> everytime
> and would rather work in SQL if given the choice. However, I have seen
> discussions about performance right here on this list -- do any of you
> think
> DAO/ADO performs faster than SQL? If so, can you provide some
> statistics?
> 
> SUsan H.
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> 
> 
> ----------------------------------------------------
> Is email taking over your day?  Manage your time with eMailBoss.  
> Try it free!  http://www.eMailBoss.com
>