> -----Original Message-----
> From: Cory Nelson [mailto:[EMAIL PROTECTED] 
> Sent: Saturday, November 05, 2005 11:40 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Request for comment: Proposed SQLite API changes

> > *I* know that, and *you* know that, but the idea is to 
> minimize the impact
> > of inefficient code.  This is somewhat akin to the ol' += 
> string concat
> > operator ... so many people use it that you can't throw it 
> out the window as
> > inefficient -- but you CAN change your underpinnings to 
> minimize the impact.
> > As a wrapper writer I can't control how people code -- in 
> my case I am bound
> > by the ADO.NET 2.0 architecture and have a standard that I 
> cannot deviate
> > from.
> 
> Hmm... no.  It is not the job of the author to optimize for improper
> use of something.  If you have so many ignorant users, perhaps you
> need to re-think your documentation.

First, there's a difference between improper and inefficient.  String
concatenation using a += operator is not improper, but it can be inefficient
if the string class doesn't use its buffer wisely.  Likewise building a SQL
string each time and executing it isn't improper, but depending on what it
is, it can be inefficient.

As for the documentation, tell that to Microsoft.  I didn't write ADO.NET.
I have an entire section of my helpfile dedicated to educating users about
the wonders of paramerized queries and transactions, but I can only lead the
horse to water.

Robert


Reply via email to