[postgis-devel] Faster option to get an image
mateusz at loskot.net
Tue Feb 15 07:37:27 PST 2011
On 14/02/11 16:18, cesius wrote:
> What is the faster option to get the image which contains one point given
> it's lat-long?
> Option 1:
> - Store all images in the DB.
> - Make a query that returns the image that contains the point.
> Option 2:
> - Store all images on the hard disk.
> - Save in the DB the bounding box (is this term correct?) of each image
> along with the path that indicates where it's stored.
> - Make a query to obtain the path.
> - Get the image from the disk.
Regarding spatial query, Option 1 is equivalent to Option 2.
Regarding disk and image I/O operation, Option 2 is potentially slower.
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org
More information about the postgis-devel