Textpattern CMS

#1 2010-01-05 12:22:05

Bongo-man

Member

Registered: 2009-03-18

Posts: 243

When a double sorting selection of articles to list, is really useful?

This night I tried to understand how the database think and make its sorting activity.
So, now I’ m wondering whether could be really useful to sort articles, for example, not only by category, but also by section.
In which cases it can be usefull?

If I select an article (in my case to print its permalink) also by section I probably take advantage if a certain article category is related only to a certain section. So I ask you if also the database make use of such thinking procedure.

But I have previously read someone that wrote the DB verifies only if a certain condition matches.
In this case if it need to find a certain category, I think, it wold compare a certain ‘text string’ with those of all the categories stored in the DB and then it would lists one or more articles.
If so the database searching also for the article section, it will do a double useless confrontation before starting a certain TAG and then I think could be more useful it sort article only related to a certain category (or a certain section), so that I would try to set in the web-site not too much categories and sections.

Can anyone confirm, or deny all this?

Another question: How do work custom fields and forms? Have they queries to DB, or are something like a SSI? Do they slow very much the blog system and/or how much their number affect all this?

Last edited by Bongo-man (2010-01-05 15:03:09)

#2 2010-01-06 02:10:35

rsilletti

Moderator

From: Spokane WA

Registered: 2004-04-28

Posts: 707

Re: When a double sorting selection of articles to list, is really useful?

TXP will filter an article list by both category and section this way,

http://yoursite.com/index.php?c=basics&s=article

by $_GET in the url, but this is done in publish.php, then on to the database. Rather than passing a sort parameter within the attributes.

On the chance that this is what you`re looking for?