cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aristedes Maniatis <>
Subject Re: Blobs in the DataContext
Date Sat, 22 May 2010 03:47:41 GMT
On 22/05/10 7:27 AM, wrote:
> I'm using cayenne to store large files in BLOBs as a process runs.
>   The first step of the process is storing large files (~ 600MB)

I'm sure others will chime in with similar thoughts: ORMs are not really designed for this
type of workload. For that matter, nor are most databases. I'd even avoid ever turning these
things into Java objects at any point along the way. You might like to explore other ways
of storing these files on disk, keeping the metadata in the database controlled by Cayenne
(filename, size, created date, user, etc.).

If you must continue along the path you've chosen, you'll want to spend quite some time with
a Java profiler (like Yourkit or jprofiler) looking at all the places these objects end up,
and exactly how they get garbage collected. That's not just about Cayenne but everywhere from
the JDBC stack through to your import/export process.


Aristedes Maniatis
GPG fingerprint CBFB 84B4 738D 4E87 5E5C  5EFA EF6A 7D2E 3E49 102A

View raw message