Changes between Initial Version and Version 3 of Ticket #29577
- Timestamp:
- Jul 18, 2018, 10:24:10 PM (6 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #29577
- Property Summary Generated SQL for exists filter does Exists(...)=true. Having just Exists(...) without "true" is faster by nearly 50% in many of my queries → Generated SQL in PostGres for exists filter does Exists(...)=true. Having just Exists(...) without "true" is faster by nearly 50% in many of my queries
-
Ticket #29577 – Description
initial v3 23 23 24 24 25 **Edit** 26 Poked around some of the annotation source code and got a work around 27 28 To remove the annotations from my selects and thus drastically increase the count(*) query speed, I just did products.query.annotation_select.pop('fits_vehicle'). This correctly filters without actually selecting, big improvement in speed! 29