Deigo,
In the meantime, you should get a performance boost if your top "tree"
suffix(dc=company,dc=com) has the same attributes indexed as all the
other sub-suffixes(db's). Even if the db is empty, this will still help
when you search on the top node.
Mark
On 05/04/2012 10:15 AM, Rich Megginson wrote:
On 05/04/2012 07:44 AM, Diego Woitasen wrote:
> On Fri, May 4, 2012 at 10:24 AM, Rich Megginson<rmeggins(a)redhat.com>
> wrote:
>> On 05/04/2012 06:47 AM, Diego Woitasen wrote:
>>> I didn't know how to title this mail. I think this should be a feature
>>> request in Track when I want to discuss this here first.
>>>
>>> I have 389DS with 150 DBs with an structure similar to this:
>>>
>>> dc=company,dc=com
>>> ou=Headquarters,dc=company,dc=com
>>> ou=Branch1,dc=company,dc=com
>>> ou=Branch2,dc=company,dc=com
>>> .
>>> .
>>> .
>>> ou=Branch150,dc=company,dc=com
>>>
>>> Each one of this subtrees are in separate DBs because I have subtree
>>> replication between the 150 branches of the companies.
>>>
>>> 80% of the objects are in the ou=HeadQuarters. I've noticed that the
>>> performance is definetely better when I use base ou=Headquarters in my
>>> applications.
>>>
>>> I have indexes on each DB but I think that the problem is that 389DS
>>> doesn't have a master index or something to improve the searchs in
>>> scenarios like mine.
>>
>> Can you explain more about what you mean by "master index"?
> An index that includes all the DBs. May be "global index" is a better
> name. Right now, when you search for something, 389DS queries all the
> DBs, one by one and with 150 DBs is a problem. There should be a way
> to avoid that.
Ok, I see. Yes, might be useful too for doing simple paged searches,
server side sorting, vlv, etc. across multiple databases.
>
>
>>
>>> May be the solution is to implemen another replication code that
>>> doesn't required separate DBs for subtree replication.
>>>
>>> Shall I file a ticket? Or there is a solution now?
>>>
>>> Regards,
>>> Diego
>>>
>
>
--
389 users mailing list
389-users(a)lists.fedoraproject.org
https://admin.fedoraproject.org/mailman/listinfo/389-users