search

gaiaresources / ala-citizenscience

Automatically exported from code.google.com/p/ala-citizenscience
1 stars 4 forks source link

Taxon attribute has regressed advanced review performance considerably #293

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1. Find a project with surveys with a decent number of attributes and records.
2. Open the advanced review sightings page.

What is the expected output? What do you see instead?
Before the introduction of the taxon attributes, performance was ok.  Now it is 
worse again.
For example, in the alcw site (alcw.ala.org.au), the TaxonGroupFacet accounts 
for 75% of the time taken to render the page and get the records via an AJAX 
query, bringing the total from less than a second back to 4 seconds.

This appears to be due primarily to the RecordDAOImp.getDistinctTaxonGroups 
query which incidentally doesn't need to be executed for the ajax portion but 
is.

Please use labels and text to provide additional information.

Original issue reported on code.google.com by chris.go...@gmail.com on 15 Jun 2012 at 7:18