sitefaqlet
SiteDocClan
<!-- 2004-01-28 - jdporter - update, regularize -->
<!-- 2003-05-22 - Mr. Muskrat - added link back to PerlMonks FAQ -->
<h2>Why are Categorized Questions and Answers displayed separately from the rest of my writeups?</h2>
<p>
It may seem strange, but it is actually a very natural consequence of the
way the PerlMonks database is arranged. You see,
the [id://1843] are "owned" by [QandAEditors],
regardless of who actually wrote the text.
</p>
<p>
Consequently, to show you the [id://1843|Q&A] nodes you wrote, the PerlMonks engine
has to scan for nodes owned by [QandAEditors]* but written by you; whereas, to
show you all your other nodes, the engine simply scans for nodes owned
by you. Written separately, the two queries are simple and fast.
If they had to be combined, it would result in an ugly, inefficient mess.
</p>
<p>
So, in a nutshell, it is done this way because it is better for PerlMonks,
even if not better for <i>you</i>. Sorry!
</p>
<p>
See also: [id://656697]
</p>
<p><small>
* (Having [id://1843] "owned" by [QandAEditors]
gives them the editorial control over that section that they really need.
See [id://20059])
</small></p>
<!-- previous content:
<p>
The short answer is "Because displaying them separately requires a small
fraction of the resources that would be required to display them together".
</p>
<p>
If we used separate queries to display both sets of your write-ups
in a single view, then the web process would have to fetch both
full lists, merge the two sorted lists together, and then select
the subset to be displayed on the current page. This would be
much less efficient than using mySQL's "LIMIT" keyword to have
the database return only the information to be displayed
(which is what we do).
</p>
-->
<hr/><i>Back to the [PerlMonks FAQ]</i>