# Not that I'm complaining, but how come "User CP" doesn't count as a search?

**URL:** <https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336>\
**Category:** About This Message Board\
**Created:** [November 11, 2014, 12:29pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336 "2014-11-11T12:29:18Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Grrr](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/grrr/32/146_2.png) [@Grrr](https://boards.straightdope.com/u/Grrr)\
**Post date:** [November 11, 2014, 12:29pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/1 "2014-11-11T12:29:18Z")

</div>

When you click on “User CP” doesn’t the board have to search for your subscribed threads the same way it would for “New Posts”?  
Again, just curious, not complaining. 🙂

---

<div class="post-metadata">

**Author:** ![Telemark](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/telemark/32/372_2.png) [@Telemark](https://boards.straightdope.com/u/Telemark)\
**Post date:** [November 11, 2014, 1:07pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/2 "2014-11-11T13:07:53Z")

</div>

It probably doesn’t have to search for your subscribed threads, instead they’re kept in a table associated with your user ID. Not knowing how vB implements it but that would be my guess.

---

<div class="post-metadata">

**Author:** ![kayT](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kayt/32/3633_2.png) [@kayT](https://boards.straightdope.com/u/kayT)\
**Post date:** [November 11, 2014, 2:04pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/3 "2014-11-11T14:04:27Z")

</div>

Apparently what **Telemark** says is true because when you go to “Quick Links” and click on Subscribed Threads, that doesn’t count as a search either. For which I am eternally grateful. (Hint: [del]if[/del] WHEN the stupid board resets your last visited time so that CP says you have no new threads, you can go to quick links and look at all the subscribed threads that have new stuff in them.)

---

<div class="post-metadata">

**Author:** ![Irishman](https://avatars.discourse-cdn.com/v4/letter/i/b487fb/32.png) [@Irishman](https://boards.straightdope.com/u/Irishman)\
**Post date:** [November 12, 2014, 4:33am UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/4 "2014-11-12T04:33:48Z")

</div>

> [@kayT](#):
>
> (Hint: [del]if[/del] WHEN the stupid board resets your last visited time so that CP says you have no new threads, you can go to quick links and look at all the subscribed threads that have new stuff in them.)

I’ve never looked in quick links, so that’s helpful to know it’s there.

If you use CP and don’t get any new threads, there’s a link at the bottom that says “show all subscribed threads”. Easier than Quick Links.

---

<div class="post-metadata">

**Author:** ![filmore](https://avatars.discourse-cdn.com/v4/letter/f/7993a0/32.png) [@filmore](https://boards.straightdope.com/u/filmore)\
**Post date:** [November 12, 2014, 4:42am UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/5 "2014-11-12T04:42:19Z")

</div>

It’s probably because it’s a very quick database lookup. There is likely a table which contains a column for thread id and another column for subscriber. Doing a lookup like “Find all entries in Subscriptions where Subscriber=Shakes” is relatively quick.

When you search for threads using a text search, that is much slower. You are looking for substrings. A query like “Find all threads which contain the word ‘Jupiter’” takes much longer since much more information needs to be searched and the substrings searches take longer.

---

<div class="post-metadata">

**Author:** ![kayT](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/kayt/32/3633_2.png) [@kayT](https://boards.straightdope.com/u/kayT)\
**Post date:** [November 12, 2014, 4:12pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/6 "2014-11-12T16:12:31Z")

</div>

Thanks to you, **Irishman** ; I never saw that subscribed link down there. Now we both learned something this week.

---

<div class="post-metadata">

**Author:** ![Chronos](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/chronos/32/134_2.png) [@Chronos](https://boards.straightdope.com/u/Chronos)\
**Post date:** [November 12, 2014, 6:01pm UTC](https://boards.straightdope.com/t/not-that-im-complaining-but-how-come-user-cp-doesnt-count-as-a-search/704336/7 "2014-11-12T18:01:43Z")

</div>

On the other hand, the “find all new posts” button is implemented via a search, even though that one could be done by a quick, efficient lookup, too.
