Blob stream out of memory.

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

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

Blob stream out of memory.

Postby sfxcc » 17.06.2011, 18:11

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

Postby klchin » 20.06.2011, 09:24

Hi!

Why you insert a BLOB with that high capacity?

guidoaerts
Senior Boarder
Senior Boarder
Posts: 93
Joined: 01.07.2009, 16:07

Postby guidoaerts » 28.07.2011, 14:19

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


Return to “Firebird”

Who is online

Users browsing this forum: No registered users and 1 guest