I modified my program to store files larger than 100MB outside of the database. Now the problem is the database itself corrupts after adding so many entries. It doesn't corrupt on a specific entry either, it's never the same. It's generally between 10,000 and 20,000 entries. Any ideas?
"Jiri Cincura" <disk...@cincura.net> wrote in message news:d2fa8bfb0904231052r792548b4oa4fc320cb1bf7...@mail.gmail.com... > On Thu, Apr 23, 2009 at 18:11, Justin Sommercorn <jus...@paraben.com> > wrote: >> Ironically, the support forum pointed me here. =A0The thing that would >> re= > ally > > :) > >> help me out the most here is letting me know if there is a more efficient >> way of adding large amounts of data to a BLOB. =A0It seems that the >> appen= > ding >> to itself is not the best way to do it. > > I would first try this scenario in IBExpert or fsql, for instance. But > I still think it's unrelated to .net provider, the database file is > handled by server. > > OTOH there are some questions about this approach. > How you load the data if you store it using concatenating chunks? > Some under-average machine has about 1GB of RAM, probably half of this > available. Are you really storing such a big files? Do you really need > to store it in database? > Why you care about DB size? Even if there's some unused pages from > concatenation, it'll be used later. And today's high-end disk drives > for DB servers have decent GB/$ ratio. > > -- = > > Jiri {x2} Cincura (CTO x2develop.com) > http://blog.vyvojar.cz/jirka/ | http://www.ID3renamer.com > > ---------------------------------------------------------------------------= > --- > Crystal Reports - New Free Runtime and 30 Day Trial > Check out the new simplified licensign option that enables unlimited > royalty-free distribution of the report engine for externally facing = > > server and web deployment. > http://p.sf.net/sfu/businessobjects > _______________________________________________ > Firebird-net-provider mailing list > Firebird-net-provider@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/firebird-net-provider > ------------------------------------------------------------------------------ Crystal Reports - New Free Runtime and 30 Day Trial Check out the new simplified licensign option that enables unlimited royalty-free distribution of the report engine for externally facing server and web deployment. http://p.sf.net/sfu/businessobjects _______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
