On 05/04/2012 07:44 AM, Diego Woitasen wrote:
On Fri, May 4, 2012 at 10:24 AM, Rich Megginson<rmeggins@xxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxxxxxx
https://admin.fedoraproject.org/mailman/listinfo/389-users
