Re: Performance of MDB and BDB Please suggest?

[Howard Chu <hyc@symas.com>]

Yajuvendra Singh wrote:
> Hi,
> 
> I feel search is indexed, last time in one of your replies you had mentioned
> mdb_stat tool and i think the indexes are present.

What you feel is irrelevant. Give us facts.

What is the actual search request? What filter is in the request? You post no
useful information in any of your emails.

In the slapd.conf you posted previously, some of your index directives were
commented out. It sounds like you actually have no idea what is or isn't indexed.


> 
> Regards,
> Yajuvendra
> 
> 
> On Fri, Aug 31, 2012 at 11:05 AM, Howard Chu <hyc@symas.com
> <mailto:hyc@symas.com>> wrote:
> 
>     Yajuvendra Singh wrote:
>     > Hi,
>     >
>     > I did some profiling on the 2.4.32 build and the output of callgrind is
>     > attached as graph.
>     >
>     > below four functions are coming as bottleneck while searching
>     >
>     > mdb_cursor_set
>     > mdb_entry_decode
>     > mdb_i2dl_insert
>     > mdb_i2dl_search
>     >
>     > Can anyone help why below functions are taking too much CPU. Why
>     > mdb_entry_decode mdb_cursor_set and mdb_i2dl_search are taking all most
>     all CPU.
> 
>     Looks like your search is not indexed.

-- 
  -- Howard Chu
  CTO, Symas Corp.           http://www.symas.com
  Director, Highland Sun     http://highlandsun.com/hyc/
  Chief Architect, OpenLDAP  http://www.openldap.org/project/