<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">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 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); ">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">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">Fedora-directory-users@redhat.com</a><br><a href="https://www.redhat.com/mailman/listinfo/fedora-directory-users">https://www.redhat.com/mailman/listinfo/fedora-directory-users</a><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>