[DB-SIG] Python and static SQL

Magnus Lycka magnus@thinkware.se
Mon, 26 Feb 2001 18:40:32 +0100

This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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
CRUD operations.

Content-Type: text/x-vcard; charset=us-ascii;
Content-Description: Card for Magnus Lycka
Content-Disposition: attachment;
Content-Transfer-Encoding: quoted-printable
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
org:Thinkware AB
adr:;;Alvans vag 99, 1tr;Umea;;907 50;Sweden
title:SW Developer / Consultant
fn:Magnus Lyck=E5