logo       
Google Custom Search
    AddThis Social Bookmark Button

Binary retrieval - *Best practice* recommendations...: msg#00156

Subject: Binary retrieval - *Best practice* recommendations...
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


---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
     joining column's datatypes do not match




Try Searching:
servers, voip, java, networking, microsoft ...
<Prev in Thread] Current Thread [Next in Thread>