Hello, I have a query in sqlalchemy like below where I lookup contract# in mssql. How do I enforce the varchar instead of nvarchar? I tried converting my field to "str(mycurrent)" but that didn't do anything. Is there some other spot to force VARCHAR to be sent?
You can find that the query that uses NVARCHAR does an index scan has 30,909 logical reads on the dbo.P table. It also uses 890 ms of CPU and has a total elapsed time of 938 ms. The query that uses VARCHAR does an index seek and has 7 logical reads on the dbo.P table. It uses 0 ms of CPU and has a total elapsed time of 11 ms. p=*session.execute*("select PZ.p_id,PZ.pimage_num from dbo.P with(nolock) inner join dbo.PZ PZ with(nolock) on PZ.p_id = p.p_id inner join dbo.D D with(nolock) on D.p_id = p.p_id AND D.pimage_num=PZ.pimage_num where p.current=:mycurrent and D.srtype_id =5",params={'mycurrent':str(mycurrent)}).fetchall() [image: Inline image 1] Thank you Lucas -- http://lucasmanual.com/ <http://lucasmanual.com/blog/> -- SQLAlchemy - The Python SQL Toolkit and Object Relational Mapper http://www.sqlalchemy.org/ To post example code, please provide an MCVE: Minimal, Complete, and Verifiable Example. See http://stackoverflow.com/help/mcve for a full description. --- 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 https://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.