U++ framework: U++ SQL » Acquiring large record

Home » U++ Library support » U++ SQL » Acquiring large record

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Acquiring large record [message #23027 is a reply to message #23017]

Tue, 08 September 2009 23:58

Mindtraveller
Messages: 917
Registered: August 2007
Location: Russia, Moscow rgn.

Experienced Contributor

The problem appears when one tries to hold/fetch i.e. large files in/from database. Not going into detail, the maximum allowed SQL transaction size is commonly no more than 1 MB.
Just in case someone needs to store large blobs in a database too, publishing a solution. The idea is to have separate table with blob column. So you divide your large file into ~512 KB pieces and keep them as records sequence in the table. Each time you need this big blob, you have to fetch it with many transactions, piece by piece.

Report message to a moderator

[Message index]

		Acquiring large record By: Mindtraveller on Tue, 08 September 2009 00:02
		Re: Acquiring large record By: Mindtraveller on Tue, 08 September 2009 23:58
		Re: Acquiring large record By: mirek on Thu, 10 September 2009 14:05

Previous Topic:	Postgres library improvements
Next Topic:	Postgres and CurrVal

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Wed Sep 16 23:59:13 GMT+2 2026

Total time taken to generate the page: 0.00534 seconds