<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">if your queries are something like<div><br class="webkit-block-placeholder"></div><div>ldapsearch '(&(uid=%)(cn=%*)(objectClass=account))' then you would want to make sure uid, cn are indexed. maybe even objectClass. It depends on what you are searching those are the attributes that you index.</div><div><br class="webkit-block-placeholder"></div><div>Read up in Indexing. It's very much like a database, you have to index the attributes you search often. </div><div><a href="http://www.redhat.com/docs/manuals/dir-server/ag/7.1/index1.html#996824">http://www.redhat.com/docs/manuals/dir-server/ag/7.1/index1.html#996824</a></div><div><br class="webkit-block-placeholder"></div><div>Sellers</div><div><br><div><div>On Dec 13, 2007, at 3:04 PM, Jared B. Griffith wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="font-family: Arial; font-size: 8pt; color: rgb(0, 0, 0); "><br>Here are the specs on the server:<br>2 x 2.0Ghz Intel Dual Core Xeon<span class="Apple-converted-space"> </span><br>4 x 1Gb Registered ECC RAM<br>2 x 74Gb Western Digital Raptors<br>Given that, the hardware issue should be more than sufficient.<br>Network connections are Gigabit full duplex throughout our cage network.<br><br>How would we go about indexing the attributes?<br><br>Me and another sys admin have a distinct feeling that it is an issue with the query, but they are going to point blame at us, so we want to make sure that we are golden before saying it's the code.<br><br><br><br><br><br><br><br>----- Original Message -----<br>From: "Chris G. Sellers" <<a href="mailto:chris.sellers@nitle.org">chris.sellers@nitle.org</a>><br>To: "Jared B. Griffith" <<a href="mailto:jared.griffith@farheap.com">jared.griffith@farheap.com</a>>, "General discussion list for the Fedora Directory server project." <<a href="mailto:fedora-directory-users@redhat.com">fedora-directory-users@redhat.com</a>><br>Sent: Thursday, December 13, 2007 11:47:35 AM (GMT-0800) America/Los_Angeles<br>Subject: Re: [Fedora-directory-users] LDAP Accounts for large website<br><br><div>Performance is often impacted greatly by<div><br class="webkit-block-placeholder"></div><div>1) Memory on the LDAP server. Make sure you can store as much of your directory data store in RAM for fast access</div><div>2) Indexing. Make sure attributes that you search on freqently are indexed. Also, limit what fields you search on to avoid having a heavy indexing tax.</div><div>3) Make sure your network connections are stable, and your not connecting on a 100MB half duplex connection while your network equiptment is expecting a full duplex connection.</div><div><br class="webkit-block-placeholder"></div><div>Once you have auditing those situations, please check your performance again.</div><div><br class="webkit-block-placeholder"></div><div>Sellers</div><div><br class="webkit-block-placeholder"></div><div>50k accounts is not that much, and a 2GHz Pentium Class or 1.5GHz Core 2 system with 1GB-2GB of RAM should perform okay. </div><div><br class="webkit-block-placeholder"></div><div><br></div><div><div><div>On Dec 13, 2007, at 2:36 PM, Jared B. Griffith wrote:</div><br class="Apple-interchange-newline"><blockquote><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div style="font-family: Arial; font-size: 8pt; color: rgb(0, 0, 0); ">I was wondering if anyone here has ever used LDAP for a website, that will potentially have millions of LDAP accounts.<br>If so, are you experiencing slow query responses or other issues?<br>If you were experiencing slow query responses, and were able to rectify the issue, how did you do this?<br>We are currently using FDS for our main website for customer accounts. We currently have over 52,000 accounts in LDAP and have only been using this for 3 months. We are now experiencing extreme slow down in query response when getting customer data into and out of the LDAP servers.<br>Any help would be greatly appreciated.<br><br>--<span class="Apple-converted-space"> </span><br>- Thank you,<br>- Jared B. Griffith<br>- Farheap Solutions, Inc.<br>- Lead Systems Administrator<br>- California IT Department<br>- Email - <a href="mailto:jared.griffith@farheap.com" target="_blank">jared.griffith@farheap.com</a><br>- Phone - 949.417.1500 ext. 266<br>- Cell Phone - 949.910.6542<br>--<br>Fedora-directory-users mailing list<br><a href="mailto:Fedora-directory-users@redhat.com" target="_blank">Fedora-directory-users@redhat.com</a><br><a href="https://www.redhat.com/mailman/listinfo/fedora-directory-users" target="_blank">https://www.redhat.com/mailman/listinfo/fedora-directory-users</a><br></div></span></blockquote></div><br><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; "><div>______________________________________________<br class="Apple-interchange-newline">Chris G. Sellers<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span>NITLE Technology</div><div>734.661.2318<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:chris.sellers@nitle.org" target="_blank">chris.sellers@nitle.org</a></div><div>AIM: imthewherd<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span>GTalk:<span class="Apple-converted-space"> </span><a href="mailto:cgseller@gmail.com" target="_blank">cgseller@gmail.com</a></div></span></div></span></div><br></div></div><br><br>--<span class="Apple-converted-space"> </span><br>- Thank you,<br>- Jared B. Griffith<br>- Farheap Solutions, Inc.<br>- Lead Systems Administrator<br>- California IT Department<br>- Email - <a href="mailto:jared.griffith@farheap.com">jared.griffith@farheap.com</a><br>- Phone - 949.417.1500 ext. 266<br>- Cell Phone - 949.910.6542<br></div></span></blockquote></div><br><div apple-content-edited="true"> <span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-align: auto; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0; "><div style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><span class="Apple-style-span" style="border-collapse: separate; color: rgb(0, 0, 0); font-family: Helvetica; font-size: 12px; font-style: normal; font-variant: normal; font-weight: normal; letter-spacing: normal; line-height: normal; orphans: 2; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-border-horizontal-spacing: 0px; -webkit-border-vertical-spacing: 0px; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; "><div>______________________________________________<br class="Apple-interchange-newline">Chris G. Sellers<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span>NITLE Technology</div><div>734.661.2318<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span><a href="mailto:chris.sellers@nitle.org">chris.sellers@nitle.org</a></div><div>AIM: imthewherd<span class="Apple-tab-span" style="white-space: pre; "> </span>|<span class="Apple-tab-span" style="white-space: pre; "> </span>GTalk: <a href="mailto:cgseller@gmail.com">cgseller@gmail.com</a></div></span></div></span> </div><br></div></body></html>