Very slow bytea data extraction

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi all,
I'm using Postgresql 8.2.3 on a Windows XP system.

I need to 
write and retrieve bytea data from a table.
The problem is that, while 
data insertion is quite fast, bytea extraction is very slow.
I'm trying 
to store a 250KB image into the bytea field.
A simple select query on a 
36-row table takes more than one minute to execute.

Any help would be 
very appreciated

Thanks in advance

Massimo



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux