Search hangs when searching in two (or more) protected areas

Search hangs when searching in two protected areas.

The SQL query hangs and never returns the results. SQL query needs to be
modified somehow.

(select occurrence0_.id as col_0_0_, taxonname4_.canonical as col_1_0_,
dataresour5_.display_name as col_2_0_, dataprovid6_.name as col_3_0_,
cataloguen1_.id as id10_1_, collection2_.id as id9_2_, institutio3_.id as
id8_3_, occurrence0_.id as id7_0_, cataloguen1_.id as id10_1_,
collection2_.id as id9_2_, institutio3_.id as id8_3_,
occurrence0_.data_provider_id as data2_7_0_, occurrence0_.data_resource_id
as data3_7_0_, occurrence0_.institution_code_id as institut4_7_0_,
occurrence0_.collection_code_id as collection5_7_0_,
occurrence0_.catalogue_number_id as catalogue6_7_0_,
occurrence0_.taxon_concept_id as taxon7_7_0_, occurrence0_.taxon_name_id as
taxon8_7_0_, occurrence0_.kingdom_concept_id as kingdom9_7_0_,
occurrence0_.phylum_concept_id as phylum10_7_0_,
occurrence0_.class_concept_id as class11_7_0_,
occurrence0_.order_concept_id as order12_7_0_,
occurrence0_.family_concept_id as family13_7_0_,
occurrence0_.genus_concept_id as genus14_7_0_,
occurrence0_.species_concept_id as species15_7_0_,
occurrence0_.nub_concept_id as nub16_7_0_, occurrence0_.iso_country_code as
iso17_7_0_, occurrence0_.latitude as latitude7_0_, occurrence0_.longitude
as longitude7_0_, occurrence0_.altitude_metres as altitude20_7_0_,
occurrence0_.depth_centimetres as depth21_7_0_, occurrence0_.cell_id as
cell22_7_0_, occurrence0_.centi_cell_id as centi23_7_0_,
occurrence0_.mod360_cell_id as mod24_7_0_, occurrence0_.year as year7_0_,
occurrence0_.month as month7_0_, occurrence0_.occurrence_date as
occurrence27_7_0_, occurrence0_.basis_of_record as basis28_7_0_,
occurrence0_.taxonomic_issue as taxonomic29_7_0_, occurrence0_.other_issue
as other30_7_0_, occurrence0_.geospatial_issue as geospatial31_7_0_,
occurrence0_.deleted as deleted7_0_, cataloguen1_.code as code10_1_,
collection2_.code as code9_2_, institutio3_.code as code8_3_ from
occurrence_record occurrence0_ inner join catalogue_number cataloguen1_ on
occurrence0_.catalogue_number_id=cataloguen1_.id inner join collection_code
collection2_ on occurrence0_.collection_code_id=collection2_.id inner join
institution_code institutio3_ on
occurrence0_.institution_code_id=institutio3_.id, taxon_name taxonname4_,
data_resource dataresour5_, data_provider dataprovid6_, geo_mapping
geomapping7_, geo_mapping geomapping8_ where
occurrence0_.id=geomapping8_.occurrence_id and
occurrence0_.id=geomapping7_.occurrence_id and
occurrence0_.data_provider_id=dataprovid6_.id and
occurrence0_.data_resource_id=dataresour5_.id and
occurrence0_.taxon_name_id=taxonname4_.id and
(geomapping7_.geo_region_id=151252 or geomapping8_.geo_region_id=151253)
limit 6)
Original issue reported on code.google.com by josecua...@gmail.com on 31 Jul 2009 at 9:28
tubackkhoa / gbif-dataportal

Search hangs when searching in two (or more) protected areas #9
