<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><div><div>On 21 Sep 2007, at 10:25, K J 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; ">What I meant was, suppose I have a Memached list of 1000 IDs. Now I want to search that list to see if ID 234 is in that list or not. My program logic would have to iterate through that entire list correct? Whereas MySQL would use its index to find it quickly.<span class="Apple-converted-space"> </span><br></span></blockquote></div><div><br class="webkit-block-placeholder"></div>Yes, but it's probably built in to your language and thus an awful lot faster to do an isset() / in_array() or array_key_exists() (PHP) on an array that you have in hand than to have a trip to the DB. In fact the language may index arrays internally anyway. MySQL with an index will be faster than MySQL without an index, but it will still be much slower than local array searching.<div><br class="webkit-block-placeholder"></div><div>Marcus<br><div> <span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; 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; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; 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; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><span class="Apple-style-span" style="border-collapse: separate; border-spacing: 0px 0px; 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; text-align: auto; -khtml-text-decorations-in-effect: none; text-indent: 0px; -apple-text-size-adjust: auto; text-transform: none; orphans: 2; white-space: normal; widows: 2; word-spacing: 0px; "><div><div style="">-- </div><div style="">Marcus Bointon</div><div style="">Synchromedia Limited: Creators of <a href="http://www.smartmessages.net">http://www.smartmessages.net</a>/</div><div style="">UK resellers of info@hand CRM solutions</div><div style="">marcus@synchromedia.co.uk | <a href="http://www.synchromedia.co.uk">http://www.synchromedia.co.uk</a>/</div></div><br class="Apple-interchange-newline"></span></span></span> </div><br></div></body></html>