[Tutor] Python+CGI+MySQL performance
Lloyd Kvam
lkvam@venix.com
Sat, 26 Jan 2002 14:47:21 -0500
I am looking at ZOPE. The issues for this site are:
it basically works OK as is
it was developed years ago (by others)
first in Mac AppleScript
then in Perl CGI on Linux
it may not be generating enough revenue to pay for another major reorganization
the current hosting ISP does not support Zope or Python
changes to the site are difficult due to dependancies between scripts and html
My role is primarily one of script mechanic: adjusting scripts when changes are made.
My point in the earlier posting was simply that lots of short connections could
work OK.
Stephan Richter wrote:
> 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
>
>
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
>
--
Lloyd Kvam
Venix Corp.
1 Court Street, Suite 378
Lebanon, NH 03766-1358
voice:
603-443-6155
fax:
801-459-9582