I have a project where I need to store multiple records within one document in order to reduced the size of the Db, it is growing exponentially. The design I inherited has a document for each row, I want to collaspe all row documents into one document or possibly into the parent document.
Around about year 2000 or so , there was an database floating around called something lightweight NAB that stored multiple person records in one document. It was published either by Lotus or possibly a view article. I have been unable to find this Db.
Does anyone have a copy of this Db or it’s whereabouts.
Also Does anyone have any other sample Dbs that handle Multiple records.
thanks in advance
Arshad
Subject: Multiple records in one document - there used be a NAB example
Hello,
You can create a copy of the Condensed Directory Catalog (aka Lightweight NAB / LNAB) any time you like. Just create a new database from the template named dircat5.ntf.
The way the CDC stays at a minimum size is as follows:
It only has one real view ($Users) the visible view is virtual.
It aggregates only certain, user-specified fields from a source db.
It multiplexes multiple notes from the source db into one note.
It does a lot of tricky stuff. You’re welcome to try and figure out/emulate what you can see publicly in the View-selection formulas inside the CDC.
Good luck!
-Josh
Subject: thanks - dircat5 looks like the Db I was looking for
Hi Doug,
Thanks, dircat5.ntf seems to be the Db I was looking for. It condenses multiple person records to a single document. I’m going to disect it.
Regards Arshad
Subject: Multiple records in one document - there used be a NAB example
I’m not sure I follow your logic. Reducing the number of document will decrease some of the overhead in the db, but it’s the document content that typically causes the problem. We have a template that is used by a number of production dbs and one of these dbs got huge, very fast. As it happens, the number of documents was similar to several other dbs but this one db contained a TON of attached images…add 20 meg of pics to every doc and, guess what? The db goes huge, fast.
I’d try and figure out why the db is getting so big and address the underlying issue.
Just for grins, how many docs are in the db? What’s the growth rate per (day/week/month) as measured in documents and bytes?
HTH
Doug
Subject: RE: Multiple records in one document - there used be a NAB example
It is no of child records that is causing the Db size to increase, each parent can have 10 to 40 child records, the child records actually only has 4 fields, the rest are 10 calculations fields.
I know that design format I require, I used it about 8 years ago but have since lost the db in question between company moves. I based the design on lightweight NAB example. I’m hoping to locate this sample Db and use it as a starting point, rather than reinventing the wheel.
Subject: Multiple records in one document - there used be a NAB example
yes you can do . open the document in read and write mode . you have to creat a new field every time whenever you exist from field with yes and no options.
Subject: Multiple records in one document - there used be a NAB example
Perhaps you are refering into an embedded view in a form wherein you can view selected/particular documents in a document. There is a property in an embedded view wherein in you can only show the category or group of documents you want. You can set that in Show Single Category in the Object pane, left of Programmer’s pane.