From: | "Brent R(dot) Matzelle" <bmatzelle(at)yahoo(dot)com> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | Re: faster way to display jpg-blobs? |
Date: | 2001-03-19 17:29:37 |
Message-ID: | 200103191738.f2JHcoN07168@mail.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
3/18/2001 7:22:35 AM, Knut Suebert <knut(dot)suebert(at)web(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Martin A. Marques | 2001-03-20 21:43:34 | php, postgres, ssl |
Previous Message | Knut Suebert | 2001-03-18 07:11:44 | Re: faster way to display jpg-blobs? |