What type of index to create?

We have just moved to the novell ldap and are having sloooow lookup times (>20 secs).  This is most 
noticeable in netscape messenger and pinpoint addressing.  We think the issue is the attribute 
mapping of (NDS)fullname to (LDAP) cn.  Now my questions:

Should an index be created for fullname on this ldap server?
if yes:
What should be the type? (Substring -- because of pinpoint?)

Extra info:
Using ldap proxy user to limit search "area"
Full search on cn=* returns 1000 objects
Server 500mhz w/700M ram running only a small apache site with minimal traffic.  (can easily move 
this to a 900mhz server w/1.2G ram)
I've tried same search on the 900Mhz server and get similar (~20sec) response times.

Thank You
wes

0
Wes
5/20/2006 4:09:46 PM
novell.edirectory.netware 7858 articles. 0 followers. Follow

9 Replies
367 Views

Similar Articles

[PageSpeed] 40
Get it on Google Play
Get it on Apple App Store

Depends on the type of searches being done; if it's a search of the form
"ch*", then a value index is sufficient; if it's a search of the form
"*ch*", then a substring index is needed.

If you have searches of both types, substring will do well, but there's
nothing that prevents you from creating both types.

But > 20s search times tells me that it may not be an index issue - how
many objects (and how deep is the tree structure) are there?

Jim

-- 
 Jim Henderson, CNA6, CDE, CNI, LPIC-1
 Novell Training Services

0
Jim
5/20/2006 7:56:45 PM
Jim Henderson wrote:
> Depends on the type of searches being done; if it's a search of the form
> "ch*", then a value index is sufficient; if it's a search of the form
> "*ch*", then a substring index is needed.
> 
> If you have searches of both types, substring will do well, but there's
> nothing that prevents you from creating both types.
> 
> But > 20s search times tells me that it may not be an index issue - how
> many objects (and how deep is the tree structure) are there?
> 
> Jim
> 
 From what I can tell from the packet capture Netscape is doing a 
(|(cn=we)(mail=we)(sn=we))  with input of "we" (no double qoutes) on the 
mail addressing line.  The search will be across 4 first level ou's then 
down one more level.  If I remember correctly a cn=* search returns 
~1000 objects with the proxy user. Did want the total objects in the tree?

I've created full name and email address (value) indexes but that does 
not seem to improve search times.

Please disregard the times for the 900Mhz server there is some other 
issue with this server.

Forgot to add in my last post these are network 6.5 sp 4 servers.


Thanks
wes
0
wes
5/20/2006 11:25:29 PM
wes wrote:

> From what I can tell from the packet capture Netscape is doing a
> (|(cn=we)(mail=we)(sn=we))  with input of "we" (no double qoutes) on
> the mail addressing line.  The search will be across 4 first level
> ou's then down one more level.  If I remember correctly a cn=* search
> returns ~1000 objects with the proxy user. Did want the total objects
> in the tree?

Is "we" a username or part of a surname ?

-- 
Cheers,
Edward
0
Edward
5/21/2006 9:51:09 AM
Edward van der Maas wrote:
> wes wrote:
> 
>> From what I can tell from the packet capture Netscape is doing a
>> (|(cn=we)(mail=we)(sn=we))  with input of "we" (no double qoutes) on
>> the mail addressing line.  The search will be across 4 first level
>> ou's then down one more level.  If I remember correctly a cn=* search
>> returns ~1000 objects with the proxy user. Did want the total objects
>> in the tree?
> 
> Is "we" a username or part of a surname ?
> 
first 2 letters of my name. So that would make we return for the 
cn(fullname - Wes LastName) and  mail (wes@blah.blah).  I'll check today 
but I think surname is the last name.
0
wes
5/21/2006 10:20:59 AM
I found my problem.  I added and index on the email address property BUT the NDS<->LDAP mapping was 
on Internet Email Address.  After 2 days of looking at this I feel like a "schmuck".

I GOING FOR A DRINK!!!

Thanks to everyone that answered.

wes

Wes Hall wrote:
> We have just moved to the novell ldap and are having sloooow lookup 
> times (>20 secs).  This is most noticeable in netscape messenger and 
> pinpoint addressing.  We think the issue is the attribute mapping of 
> (NDS)fullname to (LDAP) cn.  Now my questions:
> 
> Should an index be created for fullname on this ldap server?
> if yes:
> What should be the type? (Substring -- because of pinpoint?)
> 
> Extra info:
> Using ldap proxy user to limit search "area"
> Full search on cn=* returns 1000 objects
> Server 500mhz w/700M ram running only a small apache site with minimal 
> traffic.  (can easily move this to a 900mhz server w/1.2G ram)
> I've tried same search on the 900Mhz server and get similar (~20sec) 
> response times.
> 
> Thank You
> wes
> 
0
Wes
5/21/2006 8:23:44 PM
Wes Hall wrote:

> I found my problem.  I added and index on the email address property
> BUT the NDS<->LDAP mapping was on Internet Email Address.  After 2
> days of looking at this I feel like a "schmuck".

Welldone. Thanks for the feedback.

-- 
Cheers,
Edward
0
Edward
5/21/2006 8:42:17 PM
Wes Hall wrote:

> After 2 days of looking at this I feel like a "schmuck".
>
> I GOING FOR A DRINK!!!

A good stiff drink will cure that!

-- 


Peter
eDirectory Rules!
0
Peter
5/21/2006 10:29:21 PM
I see you've got it resolved - well done. :-)

Jim

-- 
 Jim Henderson, CNA6, CDE, CNI, LPIC-1
 Novell Training Services

0
Jim
5/22/2006 4:50:23 AM
On Sat, 20 May 2006 23:25:29 GMT, wes <wes@mail.armstrong.edu> wrote:

> From what I can tell from the packet capture Netscape is doing a 
>(|(cn=we)(mail=we)(sn=we))  with input of "we" (no double qoutes) on the 
>mail addressing line.

Don't bother with packet captures, use dstrace with the ldap trace options for
this. It'll show you exactly what's being asked for.


---------------------------------------------------------------------------
 David Gersic                                            dgersic_@_niu.edu

 I'm tired of receiving rubbish in my mailbox, so the E-mail address is
 munged to foil the junkmail bots. Humans will figure it out on their own.
0
dgersic_
5/22/2006 8:22:26 PM
Reply:

Similar Artilces:

BTrieve
Hi Has anyone used the create index/ create supplemental index function in btrieve with powerbuilder 7.0? I have set up my file specifications & key specifications correctly but i keep getting a return code = 29 (Invalid key length) My key length is specified as 255. I believe I have set up everything correctly but keep getting a rc = 29. If anyone can help please do asap. Could you please send me the format for the Btreive call for Create Supplemental Index/ create index. I think I don't have the latest book on btrieve. The call I have used is op = 31 rc=BTRCALL(op,...

Create homeDirectory (NetWare) in eDirectory
I have 2 eDirectory Drivers in two different trees(TreeA & TreeB). These are working fine. Now I have to create homeDirectory in TreeB. What are the steps required to create a homeDirectory ? I was trying by add one policy in creation apart from ScemaMapping & addition of homeDirectory inFilter: <do-add-dest-attr-value class-name="User" name="Object Class"> <arg-value type="string"> <token-text xml:space="preserve">posixAccount</token-text> </arg-value> </do-add-dest-attr-value> ...

Creating just a Typed DataTable without createing a Typed DataSet?
I have tried out to to a typed dataset in the designer, and i love it!.Great work, now i dont have to write my own typed collections at all.But, just one thing!, sometimes i just want to create 1 typed datatable, and i dont want to create a whole big dataset just for that.Is there a way to create a typed datatable without having to create a typed dataset first?.If there isnt, maybe the ADO.NET team could consider adding it to VS 2005 before they ship it?.That would be super-great!....

Netware 5.0 to Netware 6.5 eDirectory failed during eDirectory migration
Hello, Does anyone have a recommendation for fixing a failed eDirectory Acrross the wire migration? The file migration went fine, the backup of trustess went fine. During the eDirectory migration when it downed the source server and tried to finish up with the destination server it did not complete. It told me to copy the autoexec.mig to autoexec.ncg if it did not complete. It also had some other files to copy over as well, but I don't know what they are. Help In what state server stays? Can you get it up and running that you could run commands like dsrepair? I run i...

Create statistics and create index
Using ASA 9.0.2.3044 on WinXp sp1. We are moving data between databases with unload and load. Create statics is then called, and later on indexes may be created. (I know load may create statistics on it's own, but thats different matter). So, does it have any effect on the optimizer, that indexes are created after create statistics? I other words, would the optimizer benefit from knowing about indexes when I call create statistics? regards/Peter Simonsen No, create statistics itself does not benefit from having indexes around. BTW, create index will also create stat...

To Index or Not To Index or How To Index
Hello, I was wondering if someone knows a better way to explain how different indexes work. Such as, is it better to have an index with int type or char or varchar etc? Is it better to have composite indexes or indexes with individual columns? How does optimizer handle different indexes and what can we do help it? Indexes are very efficient most of the time but they can be quite detrimental to server's performance, if abused. Perhaps you know of a good article about indexing that you could share with us. Or, perhaps Mr. Rob Verschoor would like to issue an article in his very usefu...

How To Deduce Indexes From Auto Created Indexes
Hopefully the title is self explanatory but, using the syscatalog, I've been trying to find ways of finding out which, of those indexes shown in SYSINDEX, SYSINDEXES or SYSIXCOL are made because of a primary key or foreign key declaration (ie automatically made), and which have been made 'manually' (ie via a CREATE INDEX instruction). Anyone know how to do this? For those interested, I'm trying to write an app that deduces differences between databases and it's imperative that I know which indexes are created automatically and which manually. TIA Derek Dav...

superreview granted: [Bug 277434] Setting .type property on <object> element doesn't create an HTML attribute type : [Attachment 187457] Make setting .type change the type attr
Peter Van der Beken <peterv@propagandism.org> has granted Johnny Stenback <jst@mozilla.org>'s request for superreview: Bug 277434: Setting .type property on <object> element doesn't create an HTML attribute type https://bugzilla.mozilla.org/show_bug.cgi?id=277434 Attachment 187457: Make setting .type change the type attr https://bugzilla.mozilla.org/attachment.cgi?id=187457&action=edit ------- Additional Comments from Peter Van der Beken <peterv@propagandism.org> Yeah, switch to nsACString, also maybe rename mType to mActualType. ...

superreview requested: [Bug 277434] Setting .type property on <object> element doesn't create an HTML attribute type : [Attachment 187457] Make setting .type change the type attr
Johnny Stenback <jst@mozilla.org> has asked Peter Van der Beken <peterv@propagandism.org> for superreview: Bug 277434: Setting .type property on <object> element doesn't create an HTML attribute type https://bugzilla.mozilla.org/show_bug.cgi?id=277434 Attachment 187457: Make setting .type change the type attr https://bugzilla.mozilla.org/attachment.cgi?id=187457&action=edit ------- Additional Comments from Johnny Stenback <jst@mozilla.org> This implements what I talked about in my previous comment. ...

The designer must create an instance of type '<type name>' but it cannot because the type is declared as abstract.
I am getting this error when I try to view a component I've created in the designer.  It inherits an abstract component class, but I'm not going to make it non-abstract to please the designer ...  I ran across this thread in the VS 2002/2003 forum saying it was a limitation of the designer --> http://forums.asp.net/thread/310810.aspx. Is there no way around this in VS 2005? John Rummell There is a simple workaround: make the base type concrete. Then add documentation that states that you'll break the fingers of any developer that instantiates an instance of the base ...

Adding typed tableadapter after the typed datatable has been created
Hello, why cant i create a typed table adapter AFTER i have created my typed datatable...

When I Create a reference the FK Index Does not get created
We have just moved to PowerDesigner 7.5.0.739 from 6.0.0 and I have notice a few good things and what I think are a few bad things. What I am having trouble with is when I create a Reference from one table to another. In PD6 it used to Automatically create the Foreign Key Index for you, Now (as far as I can Tell) You have to Manually create the FK Index when adding a reference. Is there a setting somewhere to get it to do this for me automatically? -- Thanks... Cayce ps. I have already found the Auto-Migrate option, and it works as it should I think the procedure in 7.5...

Clustured Index ? how can i create clustured index ?
hello friends My code is below. and it is stored producure. my table1 name is urunlistesi. Below code is give me error. What should i do ? Cheers  ALTER PROCEDURE dbo.StoredProcedure1 (@kategori char(23), @kategori1 char(48), @kategori2 char(55)) AS SET Statistics io ON CREATE TABLE #urunlistesi(urunnumarasi int not null) INSERT #urunlistesi SELECT urunnumarasi, onsıra, prorenk, prokalın, aktifilan, kategori, kategori1, kategori2, resim1, baslik, tfiyat, fiyat, sure, garantidurumu, kargoucreti, sifirikinciel, ilanbaslangictarihi, sehir, ilce from urunlistesi WHERE kategori = @k...

superreview granted: [Bug 248638] HTMLInputElement.type doesn't return the "type of control created" : [Attachment 151711] Always return the actual type
Peter Van der Beken <peterv@propagandism.org> has granted Johnny Stenback <jst@mozilla.jstenback.com>'s request for superreview: Bug 248638: HTMLInputElement.type doesn't return the "type of control created" http://bugzilla.mozilla.org/show_bug.cgi?id=248638 Attachment 151711: Always return the actual type http://bugzilla.mozilla.org/attachment.cgi?id=151711&action=edit ...

Web resources about - What type of index to create? - novell.edirectory.netware

iRobot Create - Wikipedia, the free encyclopedia
iRobot Create is a hobbyist robot manufactured by iRobot that is based on the Roomba platform and was introduced in 2007. However, iRobot Create ...

The Knot Creates Facebook Page To Help Hurricane Sandy Victims Salvage Their Weddings
The damage in the wake of Hurricane Sandy included some 2,300 weddings that had to be postponed or rescheduled, according to wedding portal The ...

You can now create Skype meetings right from Microsoft Outlook for iOS
... noteworthy of the two new features that have just been added to Outlook for iOS is Skype integration in the apps calendar. Now, when you create ...

David Bowie’s ISP, as remembered by the guy who helped create “BowieNet”
David Bowie. (credit: davidbowie.com ) When David Bowie became an Internet service provider in 1998, a man named Ron Roy helped him start the ...

Create and share your CV in minutes with Kickresume
Did you wake up on January 1st full of plans to change your life, get a new job, maybe a whole new career? Only to find that, somehow, your enthusiasm ...

Illumina creates Grail for cancer blood test - Business Insider
Catching cancer early is an incredible challenge, but a new way to detect it in the blood may totally revolutionize cancer treatment in just ...

Cabinet Said to Create Body to Coordinate Affairs of Financial Regulators
... the central bank and main financial regulators, people close to matter say (Beijing) – The general office of the State Council has created a ...

Main Street plans to create more jobs
More employers on Main Street are feeling optimistic about near-term business prospects and plan to add new positions.

Seagate inhales, uses helium to create 10TB HDD
... in cloud-based data centers. The HDD contains seven platters and 14 read/write heads. It uses a hermetically sealed case and helium to create ...


Resources last updated: 1/14/2016 7:56:40 PM