[Tutor] Formatting String for SQL Insert

[Alan Gauld]

> > I do have a question, why other than say a web application would
one
> > resort to using python and/or perl to process database data when
one
> > could call stored procedures?
>
> of your choice.  Some DB's (such as MySQL) do not have stored
procedures.

Also if your server is maxed out of CPU stored procedures will be a
big resource hog. If the procedure is doing a lot of processing on a
relatively small amount of data (so the network doesn't die!) then
it is more efficient to move the processing out of the server to
the PC client.

Client/Server computing design is full of these kinds of compromise
choices. Working out which functions to build on the sever vv the
client.
IN an ideal world business logic which should be applied to all
applications should go on the server. Beyond that things which act
on a lot of data(and thus kill the network) should also be done on
the server. Application logic which heavily processes a small
amount of data should go on the client. Anything which straddles
boundaries, or where hardware/network limitations are non ideal
requires some designer intelligence.

Alan g