Re: faster way to display jpg-blobs?

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

Browse pgsql-php by date

  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?