odoousers2014 / bots

Automatically exported from code.google.com/p/bots
0 stars 0 forks source link

bug: query's in GUI without index #289

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
in web-server sometimes the right index was not used, but child was used.
this is quite slow, as there is no index on child.
query's are rewritten.
in bots-engine it already worked that way.
eg:
was: parent = models.ta.objects.filter(child=ta_object.idta)
is: parent = 
models.ta.objects.filter(idta__range=(ta_object.script,ta_object.idta),child=ta_
object.idta)

Original issue reported on code.google.com by hjebb...@gmail.com on 13 Feb 2014 at 1:32

GoogleCodeExporter commented 9 years ago

Original comment by hjebb...@gmail.com on 10 Sep 2014 at 2:53