search

tubackkhoa / gbif-dataportal

Automatically exported from code.google.com/p/gbif-dataportal
0 stars 1 forks source link

Search never returns on search for Cerambycidae #5

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
The search for Cerambycidae never returns.

http://data.gbif.org/occurrences/searchWithMap.htm?c[0].s=0&c[0].p=0&c[0].o=cera
mbycidae

The problem seems to be the DB query being made because it returns after a
huge amount of time.

(select occurrence0_.cell_id as col_0_0_, count(occurrence0_.id) as
col_1_0_ from occurrence_record occurrence0_ where (occurrence0_.cell_id is
not null) and (occurrence0_.class_concept_id=18717260 or
occurrence0_.family_concept_id=13142811 or
occurrence0_.family_concept_id=18718014 or
occurrence0_.family_concept_id=18731024 or
occurrence0_.genus_concept_id=16280365 or
occurrence0_.order_concept_id=16188427 or
occurrence0_.order_concept_id=18717626) group by occurrence0_.cell_id limit
64801)

Original issue reported on code.google.com by josecua...@gmail.com on 31 Jul 2009 at 8:35

GoogleCodeExporter commented 8 years ago

Original comment by josecua...@gmail.com on 12 Mar 2010 at 3:44