* http://www.sqlalchemy.org/docs/orm/session.html#sqlalchemy.orm.session.Session.close * Not too sure if there is a pre-written or easy way to do caching, or if you'd have to write it yourself.
-----Original Message----- From: sqlalchemy@googlegroups.com [mailto:sqlalchemy@googlegroups.com] On Behalf Of Sana Sent: Sunday, 22 January 2012 7:58 PM To: sqlalchemy Subject: [sqlalchemy]Close database connection in SQLAlchemy Hi All, I have a few queries regarding SQLAlchemy. I have a pre existing mysl database and I wanted to use SQLAlchemy on it so I have used SQLSoup to connect to the existing database. * How to close the connection once the query is done as apps become slow after a few hits to the database * On page load im displaying data from the database each time the page is refreshed the query hits the database to retrieve the data there by taking long time for the page to load is thr any way by which the query hit the table oly for new request and for the same request access data from the cache Thank you Sana -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en. ------------------------------------------------------------------------- DISCLAIMER: This e-mail transmission and any documents, files and previous e-mail messages attached to it are private and confidential. They may contain proprietary or copyright material or information that is subject to legal professional privilege. They are for the use of the intended recipient only. Any unauthorised viewing, use, disclosure, copying, alteration, storage or distribution of, or reliance on, this message is strictly prohibited. No part may be reproduced, adapted or transmitted without the written permission of the owner. If you have received this transmission in error, or are not an authorised recipient, please immediately notify the sender by return email, delete this message and all copies from your e-mail system, and destroy any printed copies. Receipt by anyone other than the intended recipient should not be deemed a waiver of any privilege or protection. Thales Australia does not warrant or represent that this e-mail or any documents, files and previous e-mail messages attached are error or virus free. ------------------------------------------------------------------------- -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.