Thank you for the document .
im currently using SQLSoup to connect to my database like
this SqlSoup('mysql://@localhost:portnumbr/databasename')
How can i achieve the same using SQLAlchemy?
On Mon, Jan 23, 2012 at 4:37 AM, Jackson, Cameron <
[email protected]> wrote:
> *
> 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: [email protected] [mailto:[email protected]] 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> 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 [email protected].
> To unsubscribe from this group, send email to
> [email protected].
> For more options, visit this group at
> http://groups.google.com/group/sqlalchemy?hl=en.
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
