[AccessD] With / End With or not?

[Rocky Smolin]

For me the question of techniques to speed up execution time should be
measured by the end user experience. If you have a technique to speed up
execution time of your code and that results in no discernable difference
in response time to the user then, if that technique results in less
readable and maintainable code, I would not use the technique.  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
>