A question about performance:
After how many metadata entries will GeoNetwork connected to a commercial database ( possibly MS SQL-Server) suffer from performance issues? Are there any numbers? We are envisaging on the order of 100000 to 1000000 (one hundred thousand to one million).
--
Jean-François Meunier
Intélec Géomatique
696, av. Ste-Croix, bureau 200
Saint-Laurent (Québec)
H4L 3Y2
Tél. : 514-744-2029
Téléc. : 514-744-4495
Hi Jean Francois,
GeoNetwork uses Lucene indexes for searching and presenting results. This does not require connecting to the database, and therefor the search performance depends on the speed of the Lucene indexes. Lucene is known to handle millions of records, you should be able to find tests on the web that analyze its performance.
Only when presenting full metadata will GeoNetwork retrieve the record from the DB.
Hope this helps, ciao,
Jeroen
On Nov 9, 2007, at 10:42 PM, Jean-François Meunier wrote:
A question about performance:
After how many metadata entries will GeoNetwork connected to a
commercial database ( possibly MS SQL-Server) suffer from performance
issues? Are there any numbers? We are envisaging on the order of 100000
to 1000000 (one hundred thousand to one million).--
Jean-François Meunier
Intélec Géomatique
696, av. Ste-Croix, bureau 200
Saint-Laurent (Québec)
H4L 3Y2
Tél. : 514-744-2029
Téléc. : 514-744-4495-------------------------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc.
Still grepping through log files to find problems? Stop.
Now Search log events and configuration files using AJAX and a browser.
Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
geonetwork-users List Signup and Options
GeoNetwork OpenSource is maintained at GeoNetwork - Geographic Metadata Catalog download | SourceForge.net