Posted by Ben-Nes Yonatan on 02/07/05 13:05

> Richard Lynch wrote:
>>>At the other hand i did find some huge mistake at my side... only the
>>>download of the file require 28MB (god knows why! but i wont start to
>>>bother
>>>u folks about it now) the upload need 16MB so clearly u were correct but
>>>im
>>>sorry to admit that i didnt understand y its getting tripled... after all
>>>the result $res is a result of an INSERT not a SELECT therfore it doesnt
>>>return all the data but just an identification if the action went
>>>succesful
>>>or not... or maybe im wrong here also?
>>
>>
>> PHP probably has to create an extra big chunk of text somewhere in the
>> process of sending the data to PostgreSQL.
>
> or it was simpler to write :)
>
>>
>>
>>>About the mysql's function... well its mysql and im using postgresql... i
>>>tried to search for something that could help uploading files data to the
>>>server but didnt find anything useful.
>>
>>
>> Sorry. I suspect they operate the same internally anyway, in terms of
>> transferring data to/from the database, and buffering the query.
>
> no, load_file() is mysql internal function. the file is read by mysql
> server, so it completely bypass php and also client libraries. you need to
> have file priviledge.
>

Hi and thanks again Richard and Marek,

Finally I found the solution that I craved for which is large objects at
postgresql, I can upload and d/l files with memory consuming of just alittle
bit more of the file size itself.
Actually I have to admit that I saw that option before but I thought that
its quite useless for my needs because they wrote there that after version
7.1 of postgresql the large objects interface is partially obsolete and
they also wrote that one of the remaining beneifits of using it is that it
can hold up to 2GB!! instead of the new TOAST of 1GB!! so I thought that I
dont need it at all if anyway I can get to 1GB.... but apprantly they didnt
wrote anywhere about the memory consumption diffrence... or maybe I dont
control the english language as I wish to :)
The large objects manual -
http://www.postgresql.org/docs/7.4/interactive/largeobjects.html (for ver
7.4)

Thanks alot again,
Ben-Nes Yonatan

[Back to original message]