Closed (fixed)
Project:
Extractor
Version:
6.x-1.0-alpha3
Component:
Code
Priority:
Normal
Category:
Feature request
Assigned:
Issue tags:
Reporter:
Created:
5 Aug 2010 at 21:11 UTC
Updated:
3 Jan 2014 at 01:42 UTC
Jump to comment: Most recent, Most recent file
Comments
Comment #1
Will White commentedPatch attached.
Comment #2
alex_b commenteddouble quotes (") in SQL statements don't conform to the standard, this would throw off PGSQL.
Have you done any performance testing on the
WHERE v.module = "%s"query? The number of selected items overall is high, while the number of vocabularies is usually very slow. I guess we are fine - unless the overall number of selected items requires an index no matter how low the number of items of the table we join to and filter by is (vocabulary)...Comment #3
Will White commentedNew patch fixes the double-quotes issue. Still needs a performance review.
Comment #4
alex_b commentedTo be released with alpha 4.
Comment #5
alex_b commentedAddressed performance issue by resolving the vid before using it in the query.
Comment #6
alex_b commentedCommitted, thank you.