On 2/13/07, Aliacta <[EMAIL PROTECTED]> wrote:
>Marc's classes require that large binary data BLOBs be escaped into
>ASCII; for me this takes a lot of time because I pass large iamge
>bitmaps back and forth from the postgreSQL DB.
Peter, do you use FETCH? Because it shouldn't take a lot of time,
only a lot of RAM.
Escaping the binary data and storing it should be fast enough, do you
have problems with that?
Retrieving the binary data with FETCH allows you to get it directly
in binary form and is therefore very fast as well. Do you use it?
(If you retrieve it with SELECT and unescape it then that might take
quite some time.)
(All of the above is done with the simple query protocol. The
extended query protocol would allow you to store the data without
escaping it in the first place and obviously to retrieve it in its
binary form as well.)
I don't use FETCH. Good tip. I will try and see how it improves. Thanks Marc.
P.
--
-------------------------------------------------------------------------------
Peter K. Stys, MD
Professor of Medicine(Neurology), Senior Scientist
Ottawa Health Research Institute, Div. of Neuroscience
Ottawa Hospital / University of Ottawa
Ontario, CANADA
tel: (613)761-5444
fax: (613)761-5330
http://www.ohri.ca/profiles/stys.asp
-------------------------------------------------------------------------------
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
