Re: Dynamic Styles and Cut&Paste

Author

Message

Alan McDonald

Posted: 02/19/2005 3:58:24

Further to this.. I just ran a routine thru the db issuing a

deleteunusedstyles(true, true, true) on all the fields in question but it

did not get rid of the enormous bloat I've somehow acquired.

When I view in hex, the blobs in question I see the enormous style gumph in

there but I don't know how to strip it all back to just the text and

relevant styles without deleteing thew lot and starting again.

Alan

"Alan McDonald" <[email protected]> wrote in message

> Sergey,

> I have a client I gave a test version of an app to - they are using 38

> records x 4 RVF fields to create prompts for the rest of the application.

> The fields are dynamic style only, and use the rvaction list.

> Now they gave me back the database today after telling me that it's really

> slow... I notice that some of the RVF fields are >6Mb of binary content

with

> only a few k of text visible. Total db size is 142Mb when it really should

> be about 6 Mb.

> I know that they have been copying and pasting text from word as well as

> from one field to another.

> Question:

> in the light of dynamic styles, I assume that my problem stems from styles

> not merging but simply duplicating over and over resultsing in a 3 k block

> of text being supported by 6Mb of style and para information.

> How do I get around this?

> I assume I need to constantly deleteunusedstyles? is there any other

> technique I need to utilise?

> thanks

> Alan