Improving performance of cgi
Django and Pylons are both frameworks that solve this problem quite nicely, namely by abstracting the DB-frontend integration.  They are worth considering.
I have 5 python cgi pages. I can navigate from one page to another. All pages get their data from the same database table just that they use different queries.
The problem is that the application as a whole is slow. Though they connect to the same database, each page creates a new handle every time I visit it and handles are not shared by the pages.
I want to improve performance.
Can I do that by setting up sessions for the user?
Suggestions/Advices are welcome.
Thanks