in reply to
Re: Feedback Appreciated on text-parsing, SQL querying subroutine
in thread Feedback Appreciated on text-parsing, SQL querying subroutine
Actually, he's not using placeholders so in his case, he will have to put the prepare in the loop. Once he switches to placeholders, then preparing it once at the beginning would be much better.
Also, your HEREDOC terminated with an empty line and a mandatory comment (otherwise, it will get broken over and over) seems a lot less clear and more cluttered than your first example.