Received: from FESTER.MLHS.ORG (fester.mlhs.org [192.104.254.69]) by mail.postgresql.org (8.11.3/8.11.1) with ESMTP id f2JHcoN07168 for ; Mon, 19 Mar 2001 12:38:50 -0500 (EST) (envelope-from bmatzelle@yahoo.com) Message-Id: <200103191738.f2JHcoN07168@mail.postgresql.org> Received: from ML-MATZEB (ML-MATZEB.mdc.mlhs.org [10.101.23.143]) by FESTER.MLHS.ORG with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id HH5B6JNX; Mon, 19 Mar 2001 12:30:38 -0500 Date: Mon, 19 Mar 2001 12:29:37 -0500 To: pgsql-php@postgresql.org From: "Brent R. Matzelle" Subject: Re: faster way to display jpg-blobs? X-Mailer: Opera 5.02 build 855 X-Priority: 3 (Normal) Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Archive-Number: 200103/27 X-Sequence-Number: 211 3/18/2001 7:22:35 AM, Knut Suebert 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 src='pic_N.jpg'> instead of . 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