I would say make it a configurable server/engine variable for whatever mechanism is chosen, no reason to have such strong limits (it's not long before 64k seems small and we wish it were 256K). Also, each application usage may have it's own sweet spot.
-Eric On Mon, Nov 10, 2008 at 04:30:01PM -0800, Eric Bergen wrote: > I would say > 65536 just based on the current varchar and using two > bytes to record the length. I'm sure the line drawn where something > becomes "large" will be pushed further over time. > > On Mon, Nov 10, 2008 at 4:19 PM, Jeremy Zawodny <[EMAIL PROTECTED]> wrote: > > Just so we're clear, what's the magic number that make a BOB into a BLOB? > > In other words, what's "large" in this context? > > > > 256? > > 516? > > 4096? > > 32768? > > ...? > > > > Jeremy > > > > On 11/10/08, Brian Aker <[EMAIL PROTECTED]> wrote: > >> > >> Hi! > >> > >> On Nov 10, 2008, at 8:45 PM, Paul McCullagh wrote: > >> > >>> Engines call the BLOB streaming engine's "server-side" streaming API in > >>> order to support this functionality. Consistency between databases tables > >>> and the repository is maintained using reference counting calls in the > >>> API. > >> > >> > >> I am for a blob API where blob storage is offloaded from the engines. This > >> has always been a bit of a back burner wish for me (I am not fond of > >> storing > >> large blobs in the database). As long as it fit into the plugin API so that > >> anyone could implement one... its sounds good to me. > >> > >> Cheers, > >> -Brian > >> > >> -- > >> _______________________________________________________ > >> Brian "Krow" Aker, brian at tangent.org > >> Seattle, Washington > >> http://krow.net/ <-- Me > >> http://tangent.org/ <-- Software > >> _______________________________________________________ > >> You can't grep a dead tree. > >> > >> > >> > >> > >> _______________________________________________ > >> Mailing list: https://launchpad.net/~drizzle-discuss > >> Post to : [email protected] > >> Unsubscribe : https://launchpad.net/~drizzle-discuss > >> More help : https://help.launchpad.net/ListHelp > > > > > > _______________________________________________ > > Mailing list: https://launchpad.net/~drizzle-discuss > > Post to : [email protected] > > Unsubscribe : https://launchpad.net/~drizzle-discuss > > More help : https://help.launchpad.net/ListHelp > > > > > > > > -- > Eric Bergen > [EMAIL PROTECTED] > http://www.provenscaling.com > > _______________________________________________ > Mailing list: https://launchpad.net/~drizzle-discuss > Post to : [email protected] > Unsubscribe : https://launchpad.net/~drizzle-discuss > More help : https://help.launchpad.net/ListHelp _______________________________________________ Mailing list: https://launchpad.net/~drizzle-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~drizzle-discuss More help : https://help.launchpad.net/ListHelp
