in reply to RE: Re: More on selecting rows with DBI...
in thread More on selecting rows with DBI...

The MySQL book (Paul DuBois) explicitly states that queries aren't cached, in the section on placeholders.

He also says that you might as well use them, because if you port to another database, you might get the benefit there. I'd add that they make your queries easier to read and they do quoting for you automatically. Save yourself some trouble.

  • Comment on RE: RE: Re: More on selecting rows with DBI...

Replies are listed 'Best First'.
RE: RE: RE: Re: More on selecting rows with DBI...
by btrott (Parson) on May 02, 2000 at 20:32 UTC
    Oh, yes, I definitely would recommend using bind variables. :) It's just that in this particular case of MySQL-specific syntax (LIMIT [offset], rows), it's worthwhile to note that MySQL doesn't actually support bound variables; so it's not an issue in this *particular* case.

    In general, though, it's *highly* recommended.