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.)
Cheers, Marc _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives: <http://support.realsoftware.com/listarchives/lists.html>
