Bug 7185 - Feature request: Smaller LDB files - especially on >= 1000 objects
Summary: Feature request: Smaller LDB files - especially on >= 1000 objects
Status: NEW
Alias: None
Product: Samba 4.0
Classification: Unclassified
Component: AD: LDB/DSDB/SAMDB (show other bugs)
Version: unspecified
Hardware: Other Linux
: P3 enhancement (vote)
Target Milestone: ---
Assignee: Andrew Bartlett
QA Contact: samba4-qa@samba.org
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-02-25 14:20 UTC by Matthieu Patou
Modified: 2014-07-07 10:14 UTC (History)
3 users (show)

See Also:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Matthieu Patou 2010-02-25 14:20:58 UTC
A test with a 10 Mbytes LDIF import of 17000+ contacts yield a 300 Mbytes users partition file (DC=foo,DC=bar) (after ldbbackup otherwise the size is even bigger).
Part of the size is due to overduplication of SecurityDescriptor that accounts for 20% of the size (I made the calculation by coping the file and then removing the SD with a script), 
Gain can be done by doing as Windows (storing only different SD and having an link as explained at:
http://technet.microsoft.com/en-us/library/cc772829%28WS.10%29.aspx, The SD Table contains data that represents inherited security descriptors for each object. With the introduction of the SD table in Windows Server 2003, inherited security descriptors no longer have to be duplicated on each object that inherits security descriptors. Instead, inherited security descriptors are stored in the SD table and linked to the appropriate objects).
But clearly some big optimization have to be done somewhere else as we are mapping the whole database in memory which means that ~300/400 MB will be used for ~ 20 000 object shop.

For the same volume the whole Windows database (configuration and schema and users) use 65MB.
Comment 1 Matthias Dieter Wallnöfer 2010-02-25 16:11:29 UTC
Well ekacnet, I think this is not really a bug but a feature request. I'm marking it like this.
Comment 2 Matthieu Patou 2010-02-26 02:35:31 UTC
Mathias,
I don't think it's only a feature request. 20 000 real objects is not so much.
If you think that now when an object is deleted it is not really deleted but moved and kept x months (6 if I recall) a medium company might face the pb quite quickly or a least require much more memory than what we use to require for running samba.
Comment 3 Matthias Dieter Wallnöfer 2010-02-26 07:21:48 UTC
But it's not a real bug either. I will mark the problem with a higher severity.
Comment 4 Matthias Dieter Wallnöfer 2011-03-09 07:53:46 UTC
Feature requests are enhancements.