The front page of our GN 2.4.2 deployment (Ubuntu, Tomcat 6, MySQL) takes over 30 seconds to load - much longer than any subsequent searches (thanks AJAX!).
We figured out where a 22 second slow-down is occurring during page load but don't know what is causing it.
What is happening between the "Regions" and the "Featured map" DB query (see log snippet)?
Ciao, Wolfgang
<snip>
2009-11-13 22:27:37,683 DEBUG [jeeves.dbms.select] - Query : SELECT * FROM Regions
2009-11-13 22:27:37,751 DEBUG [jeeves.dbms.select] - Found 289 records in 0.067 secs
<22 seconds of unknown stuff>
2009-11-13 22:27:59,878 DEBUG [jeeves.dbms.select] - Query : SELECT * FROM Metadata WHERE id = ?
2009-11-13 22:27:59,878 DEBUG [jeeves.dbms.select] - Args : 2079
2009-11-13 22:27:59,879 DEBUG [jeeves.dbms.select] - Found 1 records in 0.0010 secs
<snip>
--
_______________________________
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
hi Wolfgang,
this doesn’t answer your question, but I’d like to point out to you that for GeoNetwork usage, you could have a free license of the Yourkit Java profiler. If you’re interested in receiving one you should contact Simon Pigot.
Kind regards
Heikki Doeleman
On Sat, Nov 14, 2009 at 12:03 AM, Wolfgang Grunberg <wgrunberg@anonymised.com> wrote:
The front page of our GN 2.4.2 deployment (Ubuntu, Tomcat 6, MySQL)
takes over 30 seconds to load - much longer than any subsequent searches
(thanks AJAX!).
We figured out where a 22 second slow-down is occurring during page load
but don’t know what is causing it.
What is happening between the “Regions” and the “Featured map” DB query
(see log snippet)?
Ciao, Wolfgang
2009-11-13 22:27:37,683 DEBUG [jeeves.dbms.select] - Query : SELECT *
FROM Regions
2009-11-13 22:27:37,751 DEBUG [jeeves.dbms.select] - Found 289 records
in 0.067 secs
<22 seconds of unknown stuff>
2009-11-13 22:27:59,878 DEBUG [jeeves.dbms.select] - Query : SELECT *
FROM Metadata WHERE id = ?
2009-11-13 22:27:59,878 DEBUG [jeeves.dbms.select] - Args : 2079
2009-11-13 22:27:59,879 DEBUG [jeeves.dbms.select] - Found 1 records in
0.0010 secs
–
Wolfgang Grunberg
Arizona Geological Survey
wgrunberg@anonymised.com
520-770-3500
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what’s new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
GeoNetwork-devel mailing list
GeoNetwork-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-devel
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork
We've finally tracked down the cause of the long delay. While loading the
frontpage, a query against the lucene index is performed in order to
populate the frontpage with a "Featured Map". I found that some aspect of
the query was taking a long time. Here's an excerpt from the log file. Note
the timestamps that indicate a significant delay between the "Hits found"
lines:
2010-01-26 22:11:57,173 DEBUG [geonetwork.search] - Lucene Query:
+eastBL:[181 TO 540] +westBL:[180 TO 539] +northBL:[271 TO 450]
+southBL:[270 TO 449] +_op6:1 +_op0:1 +_isTemplate:n
2010-01-26 22:11:57,173 DEBUG [geonetwork.search] - Sorting by : relevance
2010-01-26 22:11:57,173 DEBUG [geonetwork.search] - Sorting by :
[relevance,true]
2010-01-26 22:11:58,613 DEBUG [geonetwork.search] - Hits found : 8583
2010-01-26 22:12:13,333 DEBUG [geonetwork.search] - Hits found : 8583
2010-01-26 22:12:27,696 DEBUG [jeeves.dbms.select] - Query : SELECT * FROM
Metadata WHERE id = ?
The workaround for us was to simply disable the "Featured Map" aspect of the
frontpage by commenting out the <call name="featured"> section of the
/geonetwork/web/geonetwork/WEB-INF/config.xml.
I also found that changing the bounding coordinates of the query within that
same <call name="featured"> section helped to speed things up.
Our database currently has about 8900 records, many of which have very small
bounding rectangles. As you can see above, the query called to populate the
"Featured Map" part of the homepage was returning and sorting 8583 records.
We have a workaround for us now, I just thought I would bring this to the
developer's attention, and to anyone else's who might experience similar
issues.
--
View this message in context: http://n2.nabble.com/Mysterious-22-second-delay-in-front-page-loading-tp4002051p4463718.html
Sent from the GeoNetwork developer mailing list archive at Nabble.com.