Sqlalchemy almist certainly implements transactions. The point is that insert
is bad for bulk loading data. (I presume you are bulk loading because you want
to use transactions for batch processing)
Correctly and quickly loading data is strongly depending upon the DB.
E.g. For PostgreSQL you
* Andreas Jung [EMAIL PROTECTED] [070423 09:49]:
--On 23. April 2007 08:18:54 +0200 Andreas Jung [EMAIL PROTECTED] wrote:
Additional info: using SA 0.3.6, Postgres 7.4.6, psycopg 2.0.4
Andreas
File build/bdist.linux-i686/egg/sqlalchemy/engine/base.py, line 971,
in fetchall
Normally, like is case sensitive.
if you want to query something case insensitive, one can use all kinds
of expressions, one that comes to mind would be
lower(col) like 'lowercase%'
creating indexes on lower(col) would speed that up.
Andreas
* Paul Kippes [EMAIL PROTECTED] [070404 20:07]:
* Paul Johnston [EMAIL PROTECTED] [070404 20:11]:
Hi,
Maybe I'm not understanding this. Is ILIKE only a mysql thing? So is
LIKE normally case insensitive in complaint SQL database?
ILIKE is quasi-standard. Postgres has it as well, but MSSQL doesn't -
all LIKEs (and in equals too