Project

General

Profile

Actions

Refactor #4329

open

refactor with_taxonomy_scope to optimize SQL

Added by Joseph Magen about 10 years ago. Updated almost 9 years ago.

Status:
New
Priority:
Normal
Assignee:
-
Category:
Organizations and Locations
Target version:
-
Difficulty:
Triaged:
Fixed in Releases:
Found in Releases:

Description

per Marek's comment on PR 1105

so we find all records within specific location, the find the same for specific organization and then combine these ids which we use in third query? sounds like work for SQL instead of ruby? I understand it's not that easy using ancestry but this does not feel right to me, what do others think?

Actions #1

Updated by Dominic Cleal about 10 years ago

  • Category set to Organizations and Locations
Actions #2

Updated by Dominic Cleal about 10 years ago

and remove the explicit reference to the User class.

Actions #3

Updated by Eric Helms over 9 years ago

  • Bugzilla link set to 1123965
Actions #4

Updated by Marek Hulán almost 9 years ago

  • Description updated (diff)
Actions

Also available in: Atom PDF