MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » July 2014

Re: IFS Save Issues - Save as CLOB's instead?



fixed

There was a similar thread a while back...search for


"massive document storage in the IFS - how to handle Mimix"

On 7/16/2014 3:31 PM, Charles Wilt wrote:
Interesting thought...though I assume you meant BLOB instead of CLOB...

Based on what little I know about how BLOBs are stored and the fact that
the OS backs up large objects faster than a bunch of small ones, I would
expect the answer to be yes.

But I don't know for sure. Might be worthwhile asking IBM about.

Charles


On Wed, Jul 16, 2014 at 12:40 AM, Roger Harman <roger_harman@xxxxxxxxxxx>
wrote:

After reading a number of posts over time about slow IFS save issues, I was
wondering..



Would there be any benefit to saving them as CLOB's in a table instead of
as
IFS objects?



I have no experience whatsoever with this but just wondering what are the
pro's & con's and if anyone has tried it.





Roger Harman

COMMON Certified Application Developer - ILE RPG on IBM i on Power

OCEAN User Group <http://www.ocean400.org/> - Vice-President, Membership
(2014)







--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.








Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact