Home Original page

[ANN] istring 1.0.1 released; announce list created

David Bolen db3l at fitlinxx.com
Wed Mar 13 18:42:28 EST 2002 
"Bjorn Pettersen" <BPettersen at NAREX.com> writes:

> Except that's not how SQL is quoted (It should have been 'O''Hara').
> Besides, anyone not using bound variables must be crazy <wink>

Or looking for performance.  In some environments (e.g., remote access
over dialup with ODBC), issuing an ExecDirect() call with a simple
string can be significantly faster (e.g., a ways back I was in an
environment where the difference was 2-3x) than using bound variables
which requires additional server requests along the way.

I don't disagree with the underlying sentiment that letting the driver
handle DB-specific quoting issues is a cleaner way to go, but it does
also carry some disadvantages at times or in some environments.

--
-- David
-- 
/-----------------------------------------------------------------------\
 \               David Bolen            \   E-mail: db3l at fitlinxx.com  /
  |             FitLinxx, Inc.            \  Phone: (203) 708-5192    |
 /  860 Canal Street, Stamford, CT  06902   \  Fax: (203) 316-5150     \
\-----------------------------------------------------------------------/
More information about the Python-list mailing list