Blob stream out of memory.

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
sfxcc
Senior Boarder
Senior Boarder
Posts: 95
Joined: 13.05.2010, 18:48

Blob stream out of memory.

Post by sfxcc »

I triend to save a blob stream from loadfromfile() of 500 MB.

I just Outof memory! Why ??? Can you solve this.

Why using Blob stream takes a Lot to load a file of ex 60 MB ... ???? can it be faster ????
where's the code ..
klchin
Senior Boarder
Senior Boarder
Posts: 65
Joined: 02.09.2005, 06:27

Post by klchin »

Hi!

Why you insert a BLOB with that high capacity?
guidoaerts
Senior Boarder
Senior Boarder
Posts: 93
Joined: 01.07.2009, 16:07

Post by guidoaerts »

Maximum blob size is (according to Operation Guide):
1Kb page size => 64 Mb
2Kb page size => 512 Mb
4Kb page size => 4 Gb
8Kb page size => 32 Gb

so, if you want to load larger blobs, adjust the page size of your fb database.
guido
Post Reply