Project

General

Profile

« Previous | Next » 

Revision 8794602e

Added by Andreas Müller about 4 years ago

improve performance for author loading in E+M

View differences:

app-import/src/main/java/eu/etaxonomy/cdm/io/berlinModel/in/BerlinModelAuthorImport.java
56 56

  
57 57
	@Override
58 58
	protected String getIdQuery(BerlinModelImportState state) {
59
		String result = " SELECT authorId FROM " + getTableName();
59
	      if (state.getConfig().isEuroMed() && state.getConfig().getAuthorFilter() != null ){
60
	          //for performance reasons we do not use a subquery
61
	          return " SELECT authorId "
62
	                 + " FROM v_cdm_exp_authorsAll "
63
	                 + " ORDER BY authorId "
64
	                 ;
65
	        }
66

  
67
	    String result = " SELECT authorId FROM " + getTableName();
60 68
		if (StringUtils.isNotBlank(state.getConfig().getAuthorFilter())){
61 69
			result += " WHERE " +  state.getConfig().getAuthorFilter();
62 70
		}

Also available in: Unified diff