Re: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Smith, Michael ERDC-CRREL-NH
but for now I would like to keep my analysis on that very simple process of extracting a subset. Best regards, Ivan ---Original Message--- From: Paul Ramsey [EMAIL PROTECTED] Subject: Re: [OSGeo-Discuss] Raster data on RDBMS Sent: Oct 29 '08 05:00 The data is chunked

RE: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Sylvan Ascent Inc .
PROTECTED] From: [EMAIL PROTECTED] on behalf of Smith, Michael ERDC-CRREL-NH Sent: Wed 10/29/2008 10:13 AM To: Lucena, Ivan; OSGeo Discussions; Paul Ramsey Subject: Re: [OSGeo-Discuss] Raster data on RDBMS Ivan, Those numbers look impressive. We are just

RE: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Jason Birch
I find this stuff fascinating, but I believe that the Oracle EULA prohibits users from disclosing the results of benchmark tests. Be careful how you represent these results. Jason -Original Message- From: Lucena, Ivan Subject: [OSGeo-Discuss] Raster data on RDBMS I would like

RE: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Sylvan Ascent Inc.
] www.sylvanascent.com http://www.sylvanascent.com/ www.topodepot.com http://www.topodepot.com/ From: [EMAIL PROTECTED] on behalf of Frank Warmerdam Sent: Wed 10/29/2008 10:43 AM To: OSGeo Discussions Subject: Re: [OSGeo-Discuss] Raster data on RDBMS Sylvan Ascent Inc

Re: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Lucena, Ivan
Frank, My point is that a tile caching approach is really comparing tile caching performance to rendering-on-demand performance while I think the original point was that rendering-from-database and rendering-from-filesystem could have similar performance for input raster data. D'accord.

RE: [OSGeo-Discuss] Raster data on RDBMS

2008-10-29 Thread Lucena, Ivan
. Best regards, Ivan [1] - These names were mixed on purpose ;) ---Original Message--- From: Jason Birch [EMAIL PROTECTED] Subject: RE: [OSGeo-Discuss] Raster data on RDBMS Sent: Oct 29 '08 15:09 I find this stuff fascinating, but I believe that the Oracle EULA prohibits

[OSGeo-Discuss] Raster data on RDBMS

2008-10-28 Thread Lucena, Ivan
Hi There, I would like to return to a discussion that we had months ago about raster on RDBMS. But this time I would like to present some number. As long as I could recall there was basically two major arguments contrary to storing raster on RDBMS. One very pragmatical: Why waste precious

Re: [OSGeo-Discuss] Raster data on RDBMS

2008-10-28 Thread Paul Ramsey
The data is chunked in Oracle into tiles, so unless you tile the TIFF as well you aren't really doing a direct comparison. Even if you end up with the same numbers for both processes, I'll still be impressed, since I assumed Oracle would have a higher overhead. P. On Tue, Oct 28, 2008 at 9:54

Re: [OSGeo-Discuss] Raster data on RDBMS

2008-10-28 Thread Lucena, Ivan
a subset. Best regards, Ivan ---Original Message--- From: Paul Ramsey [EMAIL PROTECTED] Subject: Re: [OSGeo-Discuss] Raster data on RDBMS Sent: Oct 29 '08 05:00 The data is chunked in Oracle into tiles, so unless you tile the TIFF as well you aren't really doing a direct