Kalador Tech Support <[EMAIL PROTECTED]> writes: > When run from a browser, accessing an Apache webserver, the results > displayed were:
> fetch time = 3.632ms, 296043 bytes > unescape time = 70625.518ms, 296043 bytes Is it possible that you are relying on an old (like 7.3) libpq? I find this in the CVS logs: 2003-06-11 21:17 momjian * src/interfaces/libpq/fe-exec.c: I found the libpq function PGunescapeBytea a little slow. It was taking a minute and a half to decode a 500Kb on a fairly fast machine. I think the culprit is sscanf. ... The new function is significantly faster on my machine with the JPEGs being decoded in less than a second. I attach a modified libpq example program that I used for my testing. Ben Lamb. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org