Hello
In my program, I was trying to guess why so many SQL queries were sent
while some could have been avoided with the help of the identity map.
So, I reduced my program to what is below and wrote 3 times the same
query.get call and 3 SQL queries were sent to the database server.
Why does SQLAlchemy send 3 times the SQL while it could have done it only 1
time for the first call and use the identity map for the 2 last calls?
from sqlalchemy import *
from sqlalchemy.orm import *
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
_descriptiontype_table = Table('descriptiontype', Base.metadata,
Column('id', Integer, primary_key=True),
Column('refno', Integer),
Column('sortindex', Integer),
Column('designation', String),
schema='botany'
)
class Descriptiontype(Base):
__table__ = _descriptiontype_table
if __name__ == '__main__':
engine = create_engine('postgresql://user@localhost:5432/mydatabase')
Session = sessionmaker(bind=engine)
session = Session()
session.query(Descriptiontype).get(-2147483648)
session.query(Descriptiontype).get(-2147483648)
session.query(Descriptiontype).get(-2147483648)
--
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?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
