| From: | beyaNet Consultancy <beyanet(at)ntlworld(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | pgsql-novice(at)postgresql(dot)org |
| Subject: | Binary retrieval - *Best practice* recommendations... |
| Date: | 2004-02-20 15:22:50 |
| Message-ID: | A5260E9A-63B8-11D8-9F4F-0003938366A4@ntlworld.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice pgsql-sql |
Hi,
I have a table in postgreSQL, ver. 7.4.1, which serves up image
data(JPEG) to users browsers. In various posts I have read there has
been a favour towards storing image data as bytea (byte[]) instead of
storing the filesystem location of the image, or whatever binary data
is, in the database. I have decided to store my images on the database
and wanted to know what *best practice* performance tweaks you suggest
I make to postgreSQL in terms of minimising the time it takes to serve
binary data to users?
many thanks in advance
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josh Berkus | 2004-02-20 18:53:36 | Re: Row counts/data changes. Any catalog table that has this info? |
| Previous Message | joseph speigle | 2004-02-20 15:00:25 | Re: commenting sql code |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | scott.marlowe | 2004-02-20 15:27:14 | Re: date format in 7.4 |
| Previous Message | Silke Trissl | 2004-02-20 14:58:10 | date format in 7.4 |