in reply to Re: speedy update routine
in thread speedy update routine

Thanks for your reply. I'd forgotten about the placeholders.

Will getting rid of the global variables and passing parameters actually improve performance or is that just good programming practice?

Lastly, the update routine takes over a second. The insert routine takes 0.26 secs which I'm happy with.

js.

Replies are listed 'Best First'.
Re^3: speedy update routine
by Zaxo (Archbishop) on Jun 12, 2004 at 22:17 UTC
    Will getting rid of the global variables and passing parameters actually improve performance or is that just good programming practice?

    Good practice, mainly. It may improve performance, but only indirectly. By reworking your code with attention to variable scope, you may see simplifications which speed things up.

    Don't get too caught up in timing performance. Correctness is far more important.

    After Compline,
    Zaxo