[Metakit] Subviews and memory usage

[Andrew Maizels]

I have a little project that I'd love to use Metakit for (a 
blogging/webforum system).

The problem is I want to use subviews extensively.  My test database has 
24 subviews under the main view.  (If I was using SQL I'd have a 
nightmare of joins - which is one reason why I want to use Metakit).

The problem with that is it gobbles up all my memory.  With only one 
subview in place, my test program uses 43MB of memory (resident) while 
working on a 1.3GB database (100,000 rows, blocked - the rows are fairly 
large).

That's fine.  But with all 24 subviews, this balloons out to 840MB.  All 
I need to do is open the view, and *boom*.  (Well, not *boom*, since I 
have 2GB of memory.  But the production system will be a lot bigger - 
using multiple Metakit databases.)

Is there any way to avoid this?  Because that's pretty much fatal to my 
design.  And I have to have that view open, otherwise nothing works.

Using Metakit 2.4.9.3, Python 2.3.4, CentOS 4.0 x86_64.

Thanks,

Andrew