Rich,
Thanks for the info. I still don't understand the splitting, as the db uses
a text field which can hold up to 2 gigs, since it's just a pointer to a
location on the disk anyway (SQLServer). The only thing I could think of
was that it was make sure it worked across different DBMS's or to keep down
collection sizes from indexing objects. I'll look into your paper/script
and think about changing my export scripts.
Thanks,
S
"Richard Ragan"
<Richard.R.Ragan@syn To: Spectra-Talk
<[EMAIL PROTECTED]>
tegra.com> cc:
Subject: Re: Object Size
11/26/2001 12:45 PM
Please respond to
spectra-talk
DB servers and the default CF config limit DB records to around 64K
so objects have to be split to stay below this size. You are likely to
get in some sort of trouble by "unsplitting" them.
FYI, there is a script/whitepaper I did for migrating content from staging
to production that is on the Macromedia site. Don't have a URL handy
right this instant but it takes care of migrating split objects.
Rich
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: "Spectra-Talk" <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 9:35 AM
Subject: Object Size
> I'm doing migration of objects from a staging server to production. What
> I've noticed is any object that has OBJECTDATA larger than 31999
characters
> stores anything above that in the extendeddata table. I just put together
> what is in OBJECTDATA with what is in the extendeddata table and push the
> whole thing and insert the record on the other end. Does anyone know if
> there is some practical reason for the objects being split like that?
And,
> by me inserting the whole thing the wrong approach?
>
> Thanks,
>
> Shawn Gorrell
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
------------------------------------------------------------------------------
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/spectra_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
