in reply to Re: Avoiding too many DB queries
in thread Avoiding too many DB queries

Will this actually reduce any overhead?

I've got too many statements all over my code to go through and update it as you recommend...

Cheers
Sam

Replies are listed 'Best First'.
Re^3: Avoiding too many DB queries
by eric256 (Parson) on Jun 18, 2004 at 17:42 UTC

    It is more of a security issue. You no longer have to wory about what is in those variables because DBI is going to make sure they are safe and not trying to break anything. It also means you can prepare it before hand using placeholders, then execute it multiple times later with different values, I beleive in that case it DOES reduce the overhead.


    ___________
    Eric Hodges