I'll show you the magic incantations for MS-SQL:
ALTER DATABASE MyDatabase SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE MyDatabase SET READ_COMMITTED_SNAPSHOT ON
background:
http://msdn.microsoft.com/en-us/library/ms175095.aspx
also going to add these to the docs (note to pycon sprinters...going to load up
on documentation items for people)
On Feb 24, 2011, at 3:47 AM, Viktor Nagy wrote:
> hi,
>
> we've developed an app with sqlalchemy that should run both with MSSQL
> and PostgreSQL (the client is moving from MS to Postgres). The
> application runs fine on Postgres, but the tables are locked when we
> run it with MSSQL, thus only one application instance can be used with
> the database.
>
> There is one session instance defined that we use (almost) everywhere,
> and this session runs session.commit at the end of code blocks when
> necessary.
>
> Is this the proposed way to do it? Do you have any idea about the problem?
>
> thanks, Viktor
>
> --
> 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.
