Hello. ORM is certainly slower. How much depends A LOT on your workload. For example bulk operations with ORM are an order of magnitude slower than raw SQL. On the other hand, SQLAlchemy Core let's you write generative SQL queries without ORM features which are as performant as raw SQL. Overall SQLAlchemy is an excellent library to work with!
For some numbers, see: http://docs.sqlalchemy.org/en/latest/faq/performance.html http://docs.sqlalchemy.org/en/latest/orm/examples.html#examples-performance HTH, Ladislav Lenart On 7.8.2015 11:16, kk wrote: > Dear all, > I am planning to totally revamp my rdbms model and totally migrate to > sqlalchemy. > Right now we have a lot of stored procedurs for obvious performance > benefits. However it is becoming more and more difficult to maintain > the system and also difficult to migrate existing users when there are > major changes to our software. > Basically our stored procedures get created when the database is created > in the deploy phase. > So I wish to know how much performance I will loos if I totally switch > to using ORM, specifically SQLAlchemy. > I am also planning to use some thing like json columns in postgresql > tables, so will it really matter with an ORM? > Happy hacking. > Krishnakant. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.