[postgis-devel] Faster option to get an image

[Emilio de Torres Fernández]

Thanks Mateusz, I'll try the first option.

Best regards.

El mar, 15-02-2011 a las 15:37 +0000, Mateusz Loskot escribió:
> 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,