Re: faster way to display jpg-blobs? - Mailing list pgsql-php

From Brent R. Matzelle
Subject Re: faster way to display jpg-blobs?
Date
Msg-id 200103191738.f2JHcoN07168@mail.postgresql.org
Whole thread Raw
In response to faster way to display jpg-blobs?  (Knut Suebert <knut.suebert@web.de>)
List pgsql-php
3/18/2001 7:22:35 AM, Knut Suebert <knut.suebert@web.de> wrote:
>Because of the begin/end every picture on a page is loaded one after the
>other, I fear. Not simultaneous as if there would be a direct <img
>src='pic_N.jpg'> instead of <img src='pic.php?id=N'>.

You can put a BEGIN/END around multiple queries to place all queries into one
transaction block and thus rid yourself of some overhead.  Otherwise I do not
know of any _faster_ way to download binary data from a database.  I would
suggest that you place the images on the fs instead and provide a (VARCHAR)
path to the file, but that option is dependent upon your web system.

Brent


pgsql-php by date:

Previous
From: Knut Suebert
Date:
Subject: Re: faster way to display jpg-blobs?
Next
From: "Martin A. Marques"
Date:
Subject: php, postgres, ssl