<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 70.85pt 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=NO-BOK link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US>Hi,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>In a NetBeans Platform application based on PuzzleGIS and geotoolkit, there is at the startup of the application (in an Installer for the module) this statement: <o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US> //force loading/creating epsg database.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> try {<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> CRS.decode("EPSG:3395"); // BOTTLENECK 14 % of startup<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US> </span><span lang=FR>} catch (Exception ex) {<o:p></o:p></span></p><p class=MsoNormal><span lang=FR> Exceptions.printStackTrace(ex);<o:p></o:p></span></p><p class=MsoNormal><span lang=FR> </span><span lang=EN-US>}<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>The first time the database containing the EPSG-codes and the coordinatesystem parameters is loaded from a resource in one of the geotoolkit’s libraries and installed on the user’s computer. Using the statement above each time the application starts it takes about one minute to do this operation.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Is there a way to check if the EPSG derby database is already installed on the user’s computer and consequently spare some computer time ?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Best Regards<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US>Trond Westgård<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Senior Engineer<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US>Institute of Marine Research<o:p></o:p></span></p><p class=MsoNormal>Bergen, Norway<o:p></o:p></p><p class=MsoNormal>trondwe@imr.no<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>