[postgis-devel] Faster option to get an image
Emilio de Torres Fernández
emilio.detorres at fueca.es
Tue Feb 15 23:59:43 PST 2011
Thanks Mateusz, I'll try the first option.
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,
More information about the postgis-devel