Andy Lacey
andy at minstersystems.co.uk
Fri Oct 24 03:56:26 CDT 2008
That's my experience too (with indexes of course). That's why my suggestion used that. I agree 100% with Gustav. Andy Lacey -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 24 October 2008 08:05 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Updating a specific record using VBA. Hi Bobby For a single update that may be true but for many records like in a loop it is indeed not. That's one of the ways you can pinpoint an ASP or old-school VB programmer - they write code using endless series of sql execute methods. I once cleaned up an application made in Access but converted from a previous VB application by someone else. It was well done - no sloppy code - but the client complained about the slowness of an update routine. It ran several interrelated loops retrieving, verifying, and uploading data and pictures from/to an FTP server where all datatable manipulation was done calling SQL code. I transferred this to a system of recordsets and the speed increase was so high that I hardly believed it myself - and I gained eternal guru status at the client! Thus, as you write: > .. the .edit/.add methods do have their place. /gustav >>> bheid at sc.rr.com 24-10-2008 03:57 >>> I believe in many cases that the sql methods are faster. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com