docsroot.github.io/Architect---how-to-sort-objects-by-multiple-criterias.html at master · docsroot/docsroot.github.io · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta name="viewport" content="width=device-width" />

    <title>Architect - how to sort objects by multiple criterias</title>

    <meta name="twitter:title" property="og:title" content="Architect - how to sort objects by multiple criterias">
    <meta name="twitter:description" property="og:description">
    <meta property="og:url" content="https://docsroot.github.io/Architect---how-to-sort-objects-by-multiple-criterias.html">
    <meta property="og:type" content="website">
    <meta property="og:site_name" content="DocsRoot">

    <meta name="author" content="hu****hd@gmail.com" />
    <meta name="creator" content="docsroot" />

    <style type="text/css">
        blockquote {
            border-left: 5px solid green;
            margin: 10px;
            padding: 10px;
        }

        img {
            max-width: 100%;
            height: auto;
        }

        footer {
            position: fixed;
            left: 0;
            bottom: 0;
            width: 100%;
            background-color: #DDD;
            text-align: center;
            height: 22px;
            line-height: 22px;
        }
    </style>
</head>
<body>
    <!--Heading of the page-->
    <h1>Architect - how to sort objects by multiple criterias</h1>


    <!--The body part: what you put into RTE-->
    <p>In my application, I want to sort a list of objects by multiple aspects like the creation time / update time; number of views on it (how pupular it is); quality of content on it...</p><p>Below are options I <i>think</i> of for the sorting.</p><p>1/ Join multiple tables</p><p>If there are two or more tables, the sort can be done by joining tables for the query then order by one ore several fields</p><p>Disadvantage of this is the query becomes more complex for less value (just ordering) and performance could be impact</p><p>2/ Creating dedicated field / table for ordering</p><p>Maybe a new table contains of some fields like ObjectId (Type + Id), Order could be an option. But we need a background task to calculate and update the field.</p><p>Then the query can just join with one table to take the Order value</p><p><br></p><p><br></p>


    <footer>
        By <a href="http://docsroot.devcovery.com/Listing/ViewBy?author=1" target="_blank">hu****hd@gmail.com</a> at 1/4/2019 3:58:16 AM. <a href="https://docsroot.github.io/Architect---how-to-sort-objects-by-multiple-criterias.html" target="_blank">View online</a>. Built with &hearts; by <a href="http://docsroot.devcovery.com" target="_blank">docsroot</a>
    </footer>
</body>
</html>