The columns only contain address strings and not much more.
Okay I did some profiling for the customerorder plus two joins on
itemsbought and products:
1008030 function calls (968253 primitive calls) in 2.220 seconds
Ordered by: cumulative time
ncalls tottime percall cumtime
))
.all())
Hope that helps,
Simon
On 11 Sep 2014, at 20:54, Michael Bayer mike...@zzzcomputing.com wrote:
then it sounds like you have lazy loading happening, check echo=True
On Sep 11, 2014, at 3:12 PM, tatütata Okay rogersher...@googlemail.com
wrote:
Okay will try
Hey,
I got some shop tables like:
customerorders, itemsbought, products whole query with three joins takes
nothing on command line sql. When I trying to achieve same thing with ORM
and my relationship it takes 1 second, joining all three 3 tables 2 seconds?
May I come first up with my table and
for too many joins, you also want to look into EXPLAIN PLAN.
On Sep 11, 2014, at 12:57 PM, tatütata Okay rogersher...@googlemail.com
wrote:
Hey,
I got some shop tables like:
customerorders, itemsbought, products whole query with three joins takes
nothing on command line sql. When I
.
as far as why the relationship is faster, it might be doing something
different, check the echo=True output.
On Sep 11, 2014, at 2:35 PM, tatütata Okay rogersher...@googlemail.com
wrote:
Yeah that would have been my next steps. I hoped more for some hints if
the setup is correct more