[DB-SIG] Python and static SQL
Mon, 26 Feb 2001 18:40:32 +0100
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
This ODBC discussion made me think of something completely
I haven't actually done a lot of measurements, but I've
often read that databases like Oracle and DB2 have much,
much better performance using static SQL, than they have
with dynamic SQL.
Is anyone using static SQL "with" Python?
What I mean is: Has anyone here built systems where they
do their database calls in C or C++ with embedded SQL,
basically placing their database IO in a C or C++ module?
If the performance claims are true this should be able to
boost performance a lot for standard calls. Lately I've
mainly been using SQL databases from Object-Oriented programs,
and there I think 90% of the accesses are simple CRUD (Create,
Retrieve, Update, Delete) operations, and it seems to me
that it would be fairly simple to write a little program that
would auto-generate the C or C++ code needed to make these
Content-Type: text/x-vcard; charset=us-ascii;
Content-Description: Card for Magnus Lycka
X-MIME-Autoconverted: from 8bit to quoted-printable by texas.it-center.se id f1QHlSU14368
tel;cell:+46(0)705 82 80 65
tel;fax:+46(0)706 12 80 65
adr:;;Alvans vag 99, 1tr;Umea;;907 50;Sweden
title:SW Developer / Consultant