<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Dear IPT mailing list, <div><br></div><div>This afternoon we conducted a little test to see whether the IPT2 can handle publishing a big dataset from a database.</div><div><br></div><div>In the test we used a MySQL database, and successfully generated an archive with 24.000.000 records in about 50 minutes! This was run on a Tomcat server with 256MB memory. </div><div><br></div><div><a href="http://ipt.gbif.org/resource.do?r=bigdbtest">http://ipt.gbif.org/resource.do?r=bigdbtest</a></div><div><br></div><div>Previously IPT1 had serious problems with such large datasets, but during IPT2 development special care was taken to be ensure that they could be handled gracefully. The way it is done now, is that the result sets from the database are streamed to the file system where they are written (about a 1000 records per result set) so there is no memory burden at all. This is one of the reasons why the IPT2 is not as feature rich as the IPT1 was. </div><div><br></div><div>Best wishes,</div><div><br></div><div><span class="Apple-style-span" style="font-size: 12px; ">Kyle Braak </span></div><div apple-content-edited="true"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; font-size: medium; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div>Programmer</div><div>Global Biodiversity Information Facility Secretariat</div><div>Universitetsparken 15, DK-2100 Copenhagen, Denmark</div><div>Tel: +45-35321479 Fax: +45-35321480</div><div><a href="http://community.gbif.org/pg/profile/kbraak">http://community.gbif.org/pg/profile/kbraak</a></div><div>URL: <a href="http://www.gbif.org/">http://www.gbif.org</a></div><div><br></div><div><img height="363" width="561" apple-width="yes" apple-height="yes" src="cid:155E5729-329A-4BFB-BF70-68407E70108C@gbif.org"></div><div><br></div></div></span></div></span> </div><br></body></html>