[postgis-devel] Faster option to get an image

[Mateusz Loskot]

On 14/02/11 16:18, cesius wrote:
>
> Hello,
>
> 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.

Best regards,
-- 
Mateusz Loskot, http://mateusz.loskot.net
Charter Member of OSGeo, http://osgeo.org
Member of ACCU, http://accu.org