[Tutor] Python+CGI+MySQL performance

Stephan Richter srichter@cbu.edu
Sat, 26 Jan 2002 12:29:09 -0600


At 12:38 PM 1/26/2002 -0500, Lloyd Kvam wrote:
>I am supporting a web site that uses "this approach" to accessing MySQL.
>(this approach == Each 'submit button click' does a new connection to MySQL.)
>The CGI scripts are written in Perl and the ISP is using mod_perl
>to minimize script startup time.  However, there is no reason to believe
>that Perl is any quicker than Python in this kind of application.
>
>User response time is fine, but the overall database load is light.  There are
>never more than a couple of sessions trying to access the database at
>the same time.

Well, why do you not look at Zope? It has a server and therefore keeps 
Python and the DB connections in memory. It also does much of the hard work 
for you, such as cookie and HTTP variables handling.

Regards,
Stephan

--
Stephan Richter
CBU - Physics and Chemistry Student
Web2k - Web Design/Development & Technical Project Management