[AccessD] With / End With or not?

[Susan Harkins]

Add appropriate commenting and readability suffers less. I will also add that faster code that's harder to write -- takes more billable time -- yet offers no discernable difference to the user isn't in your paying client's best interest. 

Susan H. 

If OTOH, you can reduce response time to the user from say 5 second to .5 seconds then the balance falls to Sacrificing some readability and maintainability in favor of the user experience.

It is the user experience, IMO, that should be the criterion nby which we judge the efficiency of our code.

r

On Fri, Sep 17, 2021 at 5:44 AM Gustav Brock via AccessD < accessd at databaseadvisors.com> wrote:

> Hi Bill
>
> No. You mix up things. The original question, thus my last comment, 
> was about execution speed.
>
> The other topic is about code readability. And that is right: Writing 
> highly readably code often takes longer time. Just think about how 
> many key entries you would save by not indenting your code.
> Regard it as a long-term investment; it will pay back after some years 
> – the day when you review your code.
>
> /gustav
>
> Fra: Bill Benson 
> <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
> Sendt: 17. september 2021 14:16
> Til: Access Developers discussion and problem solving < 
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
> Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
> Emne: Re: [AccessD] With / End With or not?
>
> You're joking right? It takes FAR less of my OWN microseconds to make 
> use of With and use the dots only, than to type or copy paste Target 
> all those times!
>
> On Fri, Sep 17, 2021 at 6:03 AM Gustav Brock via AccessD < 
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>> wrote:
> Hi Bill
>
> Perhaps, and we can all believe, but who knows?
> My believe is, that we are discussing microseconds, thus not worth any 
> efforts for any normal scenario.
>
> /gustav
>
> Fra: Bill Benson 
> <bensonforums at gmail.com<mailto:bensonforums at gmail.com>>
> Sendt: 17. september 2021 11:47
> Til: Access Developers discussion and problem solving < 
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>
> Cc: Gustav Brock <gustav at cactus.dk<mailto:gustav at cactus.dk>>
> Emne: Re: [AccessD] With / End With or not?
>
> Gustav, I believe you could AT LEAST have left With Target in there 
> and got a performance boost. Small, but real.
>
> On Tue, Sep 14, 2021 at 5:04 AM Gustav Brock via AccessD <
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com><mailto:
> accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>>> wrote:
> Hi Arthur
>
> If any gain at all, it will more likely be microseconds.
>
> The use or not of With-End With is rather a matter of preferred coding 
> style. Indeed, if you type in an environment like Visual Studio or 
> Visual Studio Code (yes, you can code VBA with this) where 
> IntelliSense predicts quite well what you intend to type.
>
> The problem with With-End With is, that you easily loose track of the 
> object, indeed when nested.
> For fun, I took an old function of mine with what I considered "smart" 
> use of With-End With tending the unreadable and rewrote it in "clean" style.
>
> <snip>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com