Project

General

Profile

Revision 31e71264

ID31e712642d109647469487a1568471af07204cca
Parent a5e9dc2f
Child 1ff3a9d2

Added by Andreas Müller about 2 years ago

ref #7799 improve performance of authorteam loading

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/app/berlinModelImport/EuroMedActivator.java
183 183
	static String occurrenceSourceFilter = " occurrenceFk IN ( SELECT occurrenceId FROM v_cdm_exp_occurrenceAll )";
184 184
	static String commonNameFilter = " commonNameId IN ( SELECT commonNameId FROM v_cdm_exp_commonNamesAll )";
185 185
	static String webMarkerFilter = " TableNameFk <> 500 OR ( RIdentifierFk IN (SELECT RIdentifier FROM v_cdm_exp_taxaAll)) ";
186
	static String authorTeamFilter = null;  //*/ " authorTeamId IN (SELECT authorTeamId FROM v_cdm_exp_authorTeamsAll) ";
187
	static String authorFilter =  null;  //*/ " authorId IN (SELECT authorId FROM v_cdm_exp_authorsAll) ";
186
	static String authorTeamFilter =  " authorTeamId IN (SELECT drvTmp.authorTeamId FROM (SELECT authorTeamId FROM v_cdm_exp_authorTeamsAll) as drvTmp) ";
187
	static String authorFilter = null; //  " authorId IN (SELECT authorId FROM v_cdm_exp_authorsAll) ";
188 188

  
189 189

  
190 190

  

Also available in: Unified diff

Add picture from clipboard (Maximum size: 40 MB)