exist icon indicating copy to clipboard operation
exist copied to clipboard

Published 20 hours ago • verified publisher icon eXist-db

util:expand is very slow on large documents

Open merenyics opened this issue 6 months ago • 3 comments

I have successfully configured lucene indexes on some relatively large collections (~50M and ~200M of XML ). Running queries on both of these works like a charm, ft:query returns hits as expected in no time at all, so I assume that the index is configured correctly.

However, using util:expand on the hits takes EXTREMELY long. Returning a few dozen hits takes minutes. In Exide, the results show up in the results panel one at a time, seconds passing between two hits.

I came across a similar problem in the mailing list, reported years ago, but there was no reply.

Monex profiling seems to indicate that the majority of the time is indeed spent in util:expand.

Using the demo data set (Shakespeare plays), expand seems to work much faster, so I assume the problem might be related to collection size, or maybe the length of the indexed elements(?), which in my case seem to be larger, but not by orders of magnitude, they are just paragraphs of normal text.

It appears to me that unless this issue is resolved I simply cannot use Existdb to develop a search tool for our large corpora, where match highlighting would be an essential feature.

Maybe I am missing something obvious. Please advise, and consider this a bug report if this is really an issue with existdb.

merenyics avatar May 13 '25 19:05 merenyics

Just adding some detail: although the collection sizes are not extremely large, maybe the document sizes are a little unusual. The 50M collection is just a single document. Can this be an issue?

merenyics avatar May 13 '25 19:05 merenyics

I did some further research, with somewhat promising results.

  • The good news is: if I split my data into really small documents, util:expand (and kwic in general) starts to work acceptably. So this is a good workaround.
  • The bad news is: it seems the problem is indeed in the implementation of util:expand, which works much much (even exponentially?) slower on large documents. This probably needs some optimization, so I think the issue should remain open as a bug.

If anyone is aware of other workarounds, any comment would be much appreciated.

merenyics avatar May 13 '25 20:05 merenyics

Thanks for your issue report. We are, in fact, aware of that and another member of the community has analysed the performance of util:expand in detail. We will share this here or in a separate issue and reference to this one.

line-o avatar May 15 '25 09:05 line-o

If util:expand() is applied to the resulting hits, i.e. using util:expand($hits), it takes many times longer to expand the found strings than to return XML without highlighted hits.

I've done some benchmarks with dictionary data Damen Conversations Lexikon, 1834 (CC BY 4.0) taken from TEI Publisher repository: expanding hits can be 10 times slower when the search returns only one root element, and 100 times slower when the returned elements are 25.

Example of the content:

<entry xml:id="d3e734DamenConvLex-1834" xml:lang="de">
  <form type="lemma">
    <orth>Aachner Bäder</orth>
  </form>
</entry>

Lucene index:

<collection xmlns="http://exist-db.org/collection-config/1.0">
  <index xmlns:tei="http://www.tei-c.org/ns/1.0" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:dbk="http://docbook.org/ns/docbook">
    <fulltext default="none" attributes="false"/>
    <lucene>
      <analyzer class="org.apache.lucene.analysis.standard.StandardAnalyzer">
        <param name="stopwords" type="org.apache.lucene.analysis.util.CharArraySet"><value /></param>
      </analyzer>
      <text qname="tei:entry">
        <field name="text" expression="normalize-space()" />
        <field name="lemma" expression=".//tei:form[@type=('lemma', 'variant')]/tei:orth/(., tei:orth/@expand)"/>
      </text>
    </lucene>
  </index>
</collection>

In my scenario, I use the Lucene index, full-text search for lemmas, and return <entry> elements containing at least one occurrence of the search term: the exact word or part of the word, represented in the query by a prefix with an asterisk.

For the benchmarks, I use a collection with lexicographic data (with headwords starting only with letter A) and a simple XQeury module to process a query with multiple parameters, including an expanding of the matches found. I use BenchmarkDotNet to send queries via HTTP against the eXist-db 6.4.0 instance (in Docker) measure response times, and compute all metrics.

I created set of collections by reducing or multiplying dictionary data. Collections are stored as separate subcollections in main data collection.

Collection Entries Size (KB) Collection path Indexing (ms) min
Small 10 16.5 /db/apps/test-expand/data/10 313
Medium 100 40.9 /db/apps/test-expand/data/100 403
Large 1,000 258.0 /db/apps/test-expand/data/1000 4,441
ExtraLarge 14,198 3,235.8 /db/apps/test-expand/data/10000 767,898 12.8
DoubleExtraLarge 21,297 4,865.1 /db/apps/test-expand/data/100000 1,652,214 27.5

Uploading the same data second time to the empty database:

Collection Entries Size (KB) Collection path Indexing (ms) min
Small 10 16.5 /db/apps/test-expand/data/10 191
Medium 100 40.9 /db/apps/test-expand/data/100 342
Large 1,000 258.0 /db/apps/test-expand/data/1000 4,394
ExtraLarge 14,198 3,235.8 /db/apps/test-expand/data/10000 778,583 13.0
DoubleExtraLarge 21,297 4,865.1 /db/apps/test-expand/data/100000 1,783,511 29.7

Omitted collection in the benchmark means use of parent collection as the root for a search, i.e. /db/apps/test-expand/data.

Attached metrics use following parameters (in columns):

  • StartPage = start page for on returned subset of found/taken XML fragments (always 1)
  • PerPage = subset of XML fragments (i.e. <entry> elements) taken from the results of full-text query (before returning): subsequence($hits, $start-page, $per-page); (always 1)
  • Database = database used for storing and retrieving data
  • Query = represents number of XML fragments returned by full-text query: 1, 2, 5, thousands (Prefix = a*)
  • Format = format of returned data (always Xml)
  • Items = method used for getting data (UseFulltext = ft:query, other values tei:entry[position() le $get-items])

Description of methods (in rows):

  • WithoutExpand = only source XML data returned, without expansion: $hits
  • ExpandOnly = source XML data returned with expansion: util:expand($hits)
  • ExpandSkipXIncludeHighlightNone = util:expand($hits, 'expand-xincludes=no highlight-matches=no')
  • ExpandSkipXInclude = util:expand($hits, 'expand-xincludes=no')
  • ExpandSkipXIncludeHighlightElements = util:expand($hits, 'expand-xincludes=no highlight-matches=elements')
  • ExpandSkipXIncludeHighlightAttributes = util:expand($hits, 'expand-xincludes=no highlight-matches=attributes')
    • ExpandSkipXIncludeHighlightBoth = util:expand($hits, 'expand-xincludes=no highlight-matches=both')

Main parts of the query looks like this:

let $expand-options := if(not($expand) or (empty($expand-xincludes) and empty($highlight-matches))) 
    then ()
    else string-join(
        (
        (if(empty($expand-xincludes)) then "" else "expand-xincludes=" || $expand-xincludes),
        (if(empty($highlight-matches)) then "" else "highlight-matches=" || $highlight-matches)
        ), " "
        )

let $hits := if($get-items = 0)
    then collection("/db/apps/test-expand/data" || $collection)//tei:entry[not(parent::tei:entry)]
    [ft:query(., "(" || $field || ":" || $query || ")", $query-options)]
    else
    collection("/db/apps/test-expand/data" || $collection)//tei:entry[position() le $get-items]
let $hits := subsequence($hits, $start-page, $per-page)
let $hits := if($expand) then 
    if(empty($expand-options)) then
            util:expand($hits)
        else
            util:expand($hits, $expand-options)
    else $hits

Source code of test application and data is available on my GitHub. C# code for benchmarks will follow.

And the results are...

daliboris avatar Jul 21 '25 17:07 daliboris 


BenchmarkDotNet v0.15.2, Windows 10 (10.0.19045.6216/22H2/2022Update)
Intel Core i7-9750H CPU 2.60GHz (Max: 2.59GHz), 1 CPU, 12 logical and 6 physical cores
.NET SDK 9.0.304
  [Host]    : .NET 8.0.19 (8.0.1925.36514), X64 RyuJIT AVX2 [AttachedDebugger]
  QuickTest : .NET 8.0.19 (8.0.1925.36514), X64 RyuJIT AVX2

Job=QuickTest  IterationCount=20  LaunchCount=1  
RunStrategy=Monitoring  WarmupCount=1
Method StartPage PerPage Database DbCollection Query Format Items Mean Error StdDev Median Ratio RatioSD Rank
WithoutExpand 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 2.555 ms 0.4771 ms 0.5494 ms 2.369 ms 1.03 0.27 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 1,052.425 ms 61.7411 ms 71.1011 ms 1,027.658 ms 425.08 71.26 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 2.779 ms 0.4898 ms 0.5641 ms 2.620 ms 1.12 0.28 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 1,039.323 ms 57.2321 ms 65.9085 ms 1,037.406 ms 419.79 69.71 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 1,018.508 ms 47.3643 ms 54.5448 ms 1,007.669 ms 411.38 66.91 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted Prefix Xml UseFulltext 1,057.932 ms 59.9130 ms 68.9959 ms 1,036.378 ms 427.31 71.25 **
WithoutExpand 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 20.819 ms 2.2258 ms 2.5632 ms 20.427 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 23.143 ms 3.9922 ms 4.5975 ms 21.821 ms 1.12 0.24 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 22.817 ms 2.8353 ms 3.2652 ms 21.917 ms 1.11 0.18 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 18.878 ms 1.7617 ms 2.0288 ms 18.515 ms 0.92 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 19.284 ms 2.2395 ms 2.5790 ms 18.600 ms 0.94 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwentyEntries 19.114 ms 1.4669 ms 1.6893 ms 18.992 ms 0.93 0.12 *
WithoutExpand 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 18.626 ms 2.5210 ms 2.9031 ms 17.580 ms 1.02 0.20 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 21.667 ms 2.9341 ms 3.3789 ms 20.566 ms 1.18 0.23 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 19.798 ms 1.9276 ms 2.2198 ms 19.297 ms 1.08 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 18.339 ms 1.5997 ms 1.8422 ms 17.893 ms 1.00 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 19.324 ms 2.7082 ms 3.1188 ms 18.169 ms 1.06 0.21 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted Prefix Xml TakeOneEntry 20.033 ms 2.1675 ms 2.4960 ms 19.295 ms 1.09 0.19 *
WithoutExpand 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 19.324 ms 2.3784 ms 2.7389 ms 18.656 ms 1.02 0.18 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 18.554 ms 2.5892 ms 2.9817 ms 17.337 ms 0.98 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 20.207 ms 2.9104 ms 3.3516 ms 19.560 ms 1.06 0.21 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 19.642 ms 2.7132 ms 3.1245 ms 18.259 ms 1.03 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 18.517 ms 1.7448 ms 2.0093 ms 17.960 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted Prefix Xml TakeTwoEntries 18.175 ms 1.7517 ms 2.0172 ms 17.412 ms 0.96 0.15 *
WithoutExpand 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 18.984 ms 1.4985 ms 1.7257 ms 18.643 ms 1.01 0.12 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 21.550 ms 2.3090 ms 2.6590 ms 21.015 ms 1.14 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 20.072 ms 1.5088 ms 1.7376 ms 19.524 ms 1.06 0.12 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 19.358 ms 1.7614 ms 2.0284 ms 18.947 ms 1.03 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 19.459 ms 2.1832 ms 2.5142 ms 18.863 ms 1.03 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted Prefix Xml TakeFiveEntries 18.440 ms 1.4810 ms 1.7055 ms 18.116 ms 0.98 0.12 *
WithoutExpand 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 4.066 ms 1.8458 ms 2.1256 ms 3.374 ms 1.17 0.72 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 1,044.350 ms 39.0114 ms 44.9255 ms 1,034.842 ms 299.86 93.56 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 3.077 ms 0.5254 ms 0.6051 ms 2.840 ms 0.88 0.33 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 1,018.782 ms 44.6314 ms 51.3975 ms 1,005.120 ms 292.52 91.61 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 1,027.900 ms 65.3419 ms 75.2478 ms 1,005.313 ms 295.14 93.80 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted OneEntry Xml UseFulltext 1,037.146 ms 60.1044 ms 69.2163 ms 1,012.351 ms 297.79 94.20 **
WithoutExpand 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 20.725 ms 2.6698 ms 3.0745 ms 19.586 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 29.045 ms 14.1872 ms 16.3380 ms 22.315 ms 1.43 0.81 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 19.283 ms 1.7160 ms 1.9761 ms 18.602 ms 0.95 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 19.849 ms 2.4571 ms 2.8296 ms 18.757 ms 0.97 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 20.441 ms 2.4413 ms 2.8114 ms 20.012 ms 1.00 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwentyEntries 20.476 ms 2.5989 ms 2.9929 ms 19.554 ms 1.00 0.19 *
WithoutExpand 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 18.257 ms 1.8549 ms 2.1361 ms 17.549 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 18.561 ms 1.5573 ms 1.7933 ms 17.880 ms 1.03 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 18.348 ms 1.3864 ms 1.5966 ms 18.185 ms 1.02 0.13 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 19.898 ms 2.8456 ms 3.2770 ms 19.098 ms 1.10 0.21 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 20.344 ms 3.1835 ms 3.6661 ms 19.814 ms 1.13 0.23 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeOneEntry 18.763 ms 1.8410 ms 2.1201 ms 18.505 ms 1.04 0.15 *
WithoutExpand 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 19.412 ms 2.3831 ms 2.7444 ms 18.660 ms 1.01 0.18 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 19.337 ms 1.8325 ms 2.1103 ms 18.794 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 26.574 ms 11.3311 ms 13.0489 ms 20.668 ms 1.39 0.69 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 17.928 ms 1.5203 ms 1.7508 ms 17.505 ms 0.94 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 18.726 ms 1.8766 ms 2.1611 ms 18.091 ms 0.98 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeTwoEntries 20.863 ms 2.3052 ms 2.6546 ms 19.991 ms 1.09 0.18 *
WithoutExpand 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 20.490 ms 2.6297 ms 3.0283 ms 19.342 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 18.831 ms 2.4915 ms 2.8692 ms 17.832 ms 0.94 0.18 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 18.510 ms 2.0226 ms 2.3292 ms 17.455 ms 0.92 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 18.518 ms 1.3071 ms 1.5053 ms 18.488 ms 0.92 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 18.932 ms 2.2930 ms 2.6406 ms 18.038 ms 0.94 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted OneEntry Xml TakeFiveEntries 19.163 ms 1.4326 ms 1.6498 ms 18.921 ms 0.95 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 2.798 ms 0.4214 ms 0.4853 ms 2.739 ms 1.03 0.24 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 1,054.154 ms 76.4591 ms 88.0505 ms 1,025.516 ms 387.29 71.13 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 2.556 ms 0.3941 ms 0.4539 ms 2.532 ms 0.94 0.23 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 1,026.853 ms 61.8351 ms 71.2094 ms 993.347 ms 377.26 67.08 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 1,042.487 ms 75.8834 ms 87.3874 ms 1,008.608 ms 383.01 70.40 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted TwoEntries Xml UseFulltext 1,026.806 ms 49.2354 ms 56.6996 ms 1,002.148 ms 377.24 65.23 **
WithoutExpand 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 19.640 ms 2.6148 ms 3.0112 ms 18.726 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 18.993 ms 1.7777 ms 2.0472 ms 18.367 ms 0.98 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 20.178 ms 3.4700 ms 3.9960 ms 18.973 ms 1.04 0.24 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 20.229 ms 2.2130 ms 2.5485 ms 19.591 ms 1.05 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 19.250 ms 1.8082 ms 2.0823 ms 18.921 ms 1.00 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwentyEntries 18.889 ms 1.4616 ms 1.6832 ms 18.502 ms 0.98 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 18.735 ms 2.3974 ms 2.7609 ms 17.876 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 20.499 ms 3.1021 ms 3.5723 ms 19.479 ms 1.11 0.23 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 20.089 ms 2.5493 ms 2.9358 ms 19.014 ms 1.09 0.20 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 18.380 ms 1.8362 ms 2.1146 ms 17.919 ms 1.00 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 21.308 ms 2.8364 ms 3.2664 ms 20.142 ms 1.16 0.22 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeOneEntry 18.533 ms 2.0395 ms 2.3487 ms 18.010 ms 1.01 0.17 *
WithoutExpand 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 18.742 ms 1.9362 ms 2.2298 ms 18.119 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 18.300 ms 2.3378 ms 2.6922 ms 17.513 ms 0.99 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 19.803 ms 1.7997 ms 2.0725 ms 19.098 ms 1.07 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 18.390 ms 1.6969 ms 1.9541 ms 17.744 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 19.432 ms 2.8416 ms 3.2724 ms 18.602 ms 1.05 0.20 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeTwoEntries 23.062 ms 11.8845 ms 13.6863 ms 18.793 ms 1.24 0.73 *
WithoutExpand 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 19.014 ms 2.0412 ms 2.3506 ms 18.686 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 20.043 ms 2.5253 ms 2.9081 ms 19.217 ms 1.07 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 26.212 ms 4.4634 ms 5.1401 ms 24.847 ms 1.40 0.30 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 20.747 ms 2.7691 ms 3.1889 ms 19.850 ms 1.10 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 19.639 ms 2.2699 ms 2.6140 ms 19.431 ms 1.05 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted TwoEntries Xml TakeFiveEntries 18.502 ms 1.7319 ms 1.9945 ms 17.755 ms 0.99 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 2.273 ms 0.5020 ms 0.5781 ms 2.046 ms 1.05 0.33 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 1,035.199 ms 56.8241 ms 65.4387 ms 1,020.306 ms 476.75 93.49 ***
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 2.974 ms 0.3294 ms 0.3793 ms 2.880 ms 1.37 0.31 **
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 1,035.588 ms 61.3961 ms 70.7038 ms 1,010.732 ms 476.93 94.32 ***
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 1,037.080 ms 57.0964 ms 65.7523 ms 1,004.562 ms 477.61 93.69 ***
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted FiveEntries Xml UseFulltext 1,033.651 ms 61.6051 ms 70.9445 ms 997.104 ms 476.04 94.20 ***
WithoutExpand 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 22.396 ms 2.4181 ms 2.7847 ms 21.913 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 18.613 ms 1.9029 ms 2.1914 ms 17.975 ms 0.84 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 20.300 ms 2.1785 ms 2.5088 ms 19.452 ms 0.92 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 19.172 ms 1.7930 ms 2.0649 ms 18.792 ms 0.87 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 18.921 ms 2.1534 ms 2.4798 ms 18.088 ms 0.86 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwentyEntries 19.868 ms 2.4011 ms 2.7651 ms 19.149 ms 0.90 0.16 *
WithoutExpand 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 18.384 ms 1.4285 ms 1.6451 ms 18.321 ms 1.01 0.12 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 24.596 ms 12.9649 ms 14.9304 ms 18.025 ms 1.35 0.81 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 18.894 ms 1.6330 ms 1.8805 ms 18.589 ms 1.03 0.13 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 18.201 ms 1.4644 ms 1.6864 ms 17.784 ms 1.00 0.12 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 19.530 ms 2.3774 ms 2.7379 ms 19.114 ms 1.07 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeOneEntry 20.765 ms 3.0316 ms 3.4912 ms 19.464 ms 1.14 0.21 *
WithoutExpand 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.641 ms 1.9932 ms 2.2954 ms 18.071 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.424 ms 1.7573 ms 2.0238 ms 18.152 ms 1.00 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.548 ms 2.1301 ms 2.4530 ms 18.030 ms 1.01 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.471 ms 2.1093 ms 2.4291 ms 17.744 ms 1.00 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.067 ms 2.3936 ms 2.7565 ms 17.062 ms 0.98 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeTwoEntries 18.786 ms 1.6114 ms 1.8556 ms 18.291 ms 1.02 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 18.758 ms 2.2114 ms 2.5466 ms 17.870 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 17.853 ms 1.3033 ms 1.5008 ms 17.420 ms 0.97 0.13 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 18.660 ms 1.9273 ms 2.2195 ms 18.080 ms 1.01 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 18.235 ms 1.5238 ms 1.7548 ms 18.020 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 18.466 ms 2.3483 ms 2.7043 ms 17.361 ms 1.00 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Omitted FiveEntries Xml TakeFiveEntries 18.321 ms 1.2057 ms 1.3885 ms 17.980 ms 0.99 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 2.375 ms 0.4120 ms 0.4745 ms 2.113 ms 1.04 0.27 *****
ExpandOnly 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 1,020.698 ms 43.9189 ms 50.5771 ms 1,006.646 ms 444.80 81.30 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 2.710 ms 0.6502 ms 0.7488 ms 2.380 ms 1.18 0.38 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 1,056.563 ms 80.1937 ms 92.3512 ms 1,023.838 ms 460.43 90.34 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 1,001.177 ms 41.2273 ms 47.4774 ms 987.634 ms 436.29 79.50 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small Prefix Xml UseFulltext 1,025.342 ms 53.8258 ms 61.9859 ms 997.018 ms 446.82 83.09 **
WithoutExpand 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 19.099 ms 2.0965 ms 2.4143 ms 18.721 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 19.582 ms 2.2097 ms 2.5447 ms 19.075 ms 1.04 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 20.569 ms 3.0328 ms 3.4926 ms 19.383 ms 1.09 0.21 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 21.095 ms 2.6341 ms 3.0334 ms 20.350 ms 1.12 0.19 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 19.037 ms 1.6304 ms 1.8776 ms 18.726 ms 1.01 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small Prefix Xml TakeTwentyEntries 18.959 ms 2.0233 ms 2.3301 ms 18.388 ms 1.00 0.16 *
WithoutExpand 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 18.239 ms 1.9923 ms 2.2944 ms 17.630 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 18.123 ms 1.7665 ms 2.0344 ms 17.718 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 17.402 ms 1.6907 ms 1.9470 ms 16.723 ms 0.97 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 18.762 ms 2.2013 ms 2.5350 ms 17.860 ms 1.04 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 17.408 ms 1.4100 ms 1.6238 ms 16.839 ms 0.97 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small Prefix Xml TakeOneEntry 17.764 ms 1.6989 ms 1.9565 ms 17.087 ms 0.99 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 17.745 ms 1.5588 ms 1.7951 ms 17.154 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 19.583 ms 4.2097 ms 4.8479 ms 17.660 ms 1.11 0.28 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 18.507 ms 1.8686 ms 2.1519 ms 17.903 ms 1.05 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 21.297 ms 3.2889 ms 3.7875 ms 19.881 ms 1.21 0.23 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 23.523 ms 4.2551 ms 4.9001 ms 21.012 ms 1.34 0.29 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small Prefix Xml TakeTwoEntries 19.751 ms 2.9157 ms 3.3578 ms 18.357 ms 1.12 0.21 *
WithoutExpand 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 18.939 ms 2.2913 ms 2.6387 ms 18.031 ms 1.02 0.18 *****
ExpandOnly 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 18.836 ms 1.5252 ms 1.7564 ms 18.141 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 18.569 ms 1.4202 ms 1.6355 ms 18.393 ms 1.00 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 18.660 ms 2.1444 ms 2.4695 ms 17.777 ms 1.00 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 18.284 ms 1.9489 ms 2.2444 ms 17.743 ms 0.98 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small Prefix Xml TakeFiveEntries 24.880 ms 3.2732 ms 3.7694 ms 24.444 ms 1.33 0.25 **
WithoutExpand 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 3.057 ms 0.3538 ms 0.4074 ms 3.096 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 1,039.939 ms 47.2517 ms 54.4152 ms 1,023.721 ms 345.78 47.43 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 2.600 ms 0.3194 ms 0.3679 ms 2.595 ms 0.86 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 1,042.928 ms 62.6610 ms 72.1605 ms 1,019.725 ms 346.77 50.01 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 1,062.200 ms 67.5059 ms 77.7398 ms 1,034.221 ms 353.18 51.60 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small OneEntry Xml UseFulltext 1,052.574 ms 52.1835 ms 60.0945 ms 1,024.352 ms 349.98 48.64 **
WithoutExpand 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 18.876 ms 2.0026 ms 2.3061 ms 18.133 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 25.235 ms 13.4668 ms 15.5084 ms 19.144 ms 1.35 0.83 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 22.216 ms 2.1924 ms 2.5248 ms 21.956 ms 1.19 0.18 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 19.618 ms 2.2639 ms 2.6071 ms 18.587 ms 1.05 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 18.962 ms 1.6853 ms 1.9408 ms 18.456 ms 1.02 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwentyEntries 21.600 ms 3.8120 ms 4.3899 ms 20.291 ms 1.16 0.26 *
WithoutExpand 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 18.433 ms 2.1251 ms 2.4473 ms 17.750 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 19.351 ms 1.7520 ms 2.0176 ms 19.239 ms 1.06 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 18.678 ms 1.6280 ms 1.8748 ms 18.408 ms 1.03 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 18.883 ms 1.7547 ms 2.0207 ms 18.310 ms 1.04 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 18.353 ms 2.2323 ms 2.5707 ms 17.262 ms 1.01 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small OneEntry Xml TakeOneEntry 19.079 ms 2.1240 ms 2.4460 ms 18.399 ms 1.05 0.17 *
WithoutExpand 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 18.313 ms 1.5645 ms 1.8017 ms 18.194 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 18.379 ms 1.8451 ms 2.1248 ms 18.264 ms 1.01 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 19.338 ms 2.6484 ms 3.0499 ms 18.752 ms 1.06 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 19.163 ms 2.5668 ms 2.9559 ms 18.458 ms 1.05 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 18.478 ms 1.9316 ms 2.2244 ms 17.605 ms 1.02 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small OneEntry Xml TakeTwoEntries 18.686 ms 2.1602 ms 2.4877 ms 18.208 ms 1.03 0.16 *
WithoutExpand 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 20.426 ms 3.1211 ms 3.5943 ms 18.951 ms 1.03 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 19.585 ms 2.1970 ms 2.5300 ms 18.723 ms 0.98 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 18.326 ms 1.5328 ms 1.7651 ms 17.631 ms 0.92 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 19.951 ms 2.3653 ms 2.7239 ms 19.506 ms 1.00 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 19.049 ms 2.1966 ms 2.5296 ms 18.213 ms 0.96 0.19 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small OneEntry Xml TakeFiveEntries 18.896 ms 1.7251 ms 1.9866 ms 18.805 ms 0.95 0.17 *
WithoutExpand 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 2.242 ms 0.4255 ms 0.4900 ms 2.025 ms 1.04 0.28 *****
ExpandOnly 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 1,052.054 ms 53.1832 ms 61.2459 ms 1,056.370 ms 486.45 86.27 ***
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 2.875 ms 0.5220 ms 0.6011 ms 2.709 ms 1.33 0.35 **
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 1,016.473 ms 43.4221 ms 50.0049 ms 997.487 ms 470.00 82.08 ***
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 1,009.060 ms 59.3187 ms 68.3115 ms 982.926 ms 466.57 84.26 ***
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small TwoEntries Xml UseFulltext 1,042.223 ms 64.6901 ms 74.4972 ms 1,012.617 ms 481.91 87.72 ***
WithoutExpand 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 19.333 ms 2.1095 ms 2.4293 ms 18.864 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 19.150 ms 1.8929 ms 2.1799 ms 18.760 ms 1.00 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 19.454 ms 1.7393 ms 2.0030 ms 19.176 ms 1.02 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 19.627 ms 2.4420 ms 2.8122 ms 18.727 ms 1.03 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 19.476 ms 1.6953 ms 1.9523 ms 19.199 ms 1.02 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwentyEntries 20.006 ms 1.6377 ms 1.8860 ms 19.363 ms 1.05 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 25.727 ms 12.9365 ms 14.8977 ms 19.960 ms 1.18 0.77 *****
ExpandOnly 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 19.095 ms 2.0809 ms 2.3964 ms 18.349 ms 0.88 0.28 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 18.366 ms 1.5722 ms 1.8106 ms 17.764 ms 0.84 0.26 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 18.795 ms 1.4701 ms 1.6930 ms 18.501 ms 0.86 0.26 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 19.877 ms 2.2043 ms 2.5385 ms 19.145 ms 0.91 0.29 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small TwoEntries Xml TakeOneEntry 17.934 ms 2.0624 ms 2.3751 ms 17.336 ms 0.82 0.26 *
WithoutExpand 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 18.994 ms 1.6281 ms 1.8750 ms 18.571 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 18.369 ms 2.1070 ms 2.4264 ms 17.579 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 19.506 ms 2.3816 ms 2.7427 ms 18.701 ms 1.04 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 20.232 ms 3.0496 ms 3.5119 ms 19.250 ms 1.07 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 19.389 ms 2.3451 ms 2.7007 ms 18.682 ms 1.03 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small TwoEntries Xml TakeTwoEntries 18.277 ms 1.5775 ms 1.8167 ms 17.849 ms 0.97 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 20.434 ms 2.1097 ms 2.4296 ms 19.499 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 22.573 ms 3.4259 ms 3.9452 ms 20.858 ms 1.12 0.23 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 19.059 ms 2.0430 ms 2.3527 ms 18.853 ms 0.94 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 18.756 ms 1.7750 ms 2.0441 ms 17.898 ms 0.93 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 19.574 ms 1.8741 ms 2.1583 ms 19.523 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small TwoEntries Xml TakeFiveEntries 21.067 ms 3.2640 ms 3.7588 ms 19.977 ms 1.04 0.21 *
WithoutExpand 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 2.519 ms 0.4849 ms 0.5584 ms 2.443 ms 1.03 0.28 *****
ExpandOnly 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 1,015.337 ms 45.7844 ms 52.7254 ms 1,003.238 ms 416.88 70.41 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 2.499 ms 0.3882 ms 0.4471 ms 2.338 ms 1.03 0.25 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 1,041.796 ms 70.4515 ms 81.1321 ms 1,020.097 ms 427.75 76.30 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 1,030.522 ms 48.7085 ms 56.0927 ms 1,021.878 ms 423.12 71.79 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small FiveEntries Xml UseFulltext 1,005.740 ms 41.0921 ms 47.3217 ms 1,002.528 ms 412.94 69.16 **
WithoutExpand 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 18.402 ms 1.7556 ms 2.0217 ms 17.846 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 21.841 ms 3.2407 ms 3.7320 ms 20.913 ms 1.20 0.23 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 22.548 ms 3.4160 ms 3.9339 ms 21.619 ms 1.24 0.24 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 20.710 ms 3.4208 ms 3.9394 ms 18.946 ms 1.14 0.23 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 20.256 ms 2.4312 ms 2.7997 ms 19.139 ms 1.11 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwentyEntries 20.031 ms 2.2720 ms 2.6164 ms 19.054 ms 1.10 0.17 *
WithoutExpand 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 21.588 ms 4.3096 ms 4.9629 ms 20.689 ms 1.03 0.28 *****
ExpandOnly 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 19.265 ms 1.9788 ms 2.2788 ms 18.370 ms 0.92 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 18.409 ms 1.6048 ms 1.8481 ms 18.101 ms 0.88 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 18.400 ms 1.7091 ms 1.9682 ms 17.861 ms 0.88 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 19.040 ms 2.1848 ms 2.5161 ms 18.730 ms 0.91 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small FiveEntries Xml TakeOneEntry 24.326 ms 11.7030 ms 13.4771 ms 18.657 ms 1.16 0.66 *
WithoutExpand 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 19.027 ms 2.6989 ms 3.1081 ms 17.972 ms 1.02 0.21 *****
ExpandOnly 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 18.144 ms 1.8279 ms 2.1050 ms 17.714 ms 0.97 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 18.835 ms 2.4644 ms 2.8380 ms 17.974 ms 1.01 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 19.719 ms 2.5795 ms 2.9706 ms 18.720 ms 1.06 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 17.533 ms 1.5025 ms 1.7303 ms 17.043 ms 0.94 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small FiveEntries Xml TakeTwoEntries 17.570 ms 1.6549 ms 1.9057 ms 17.267 ms 0.94 0.15 *
WithoutExpand 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 18.636 ms 1.3640 ms 1.5708 ms 18.147 ms 1.01 0.11 *****
ExpandOnly 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 18.201 ms 1.8553 ms 2.1366 ms 17.505 ms 0.98 0.13 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 19.805 ms 2.1320 ms 2.4552 ms 19.002 ms 1.07 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 19.027 ms 2.3772 ms 2.7376 ms 17.912 ms 1.03 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 19.657 ms 1.8409 ms 2.1199 ms 19.121 ms 1.06 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Small FiveEntries Xml TakeFiveEntries 19.737 ms 1.8737 ms 2.1577 ms 18.885 ms 1.07 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 2.513 ms 0.3789 ms 0.4364 ms 2.396 ms 1.02 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 1,037.084 ms 55.4253 ms 63.8279 ms 1,005.367 ms 422.69 65.75 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 2.332 ms 0.4191 ms 0.4827 ms 2.062 ms 0.95 0.24 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 1,013.278 ms 49.0318 ms 56.4651 ms 993.239 ms 412.99 63.35 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 1,038.132 ms 59.1412 ms 68.1071 ms 1,009.959 ms 423.12 66.49 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large Prefix Xml UseFulltext 1,029.556 ms 59.4266 ms 68.4357 ms 1,004.084 ms 419.62 66.09 **
WithoutExpand 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 18.952 ms 2.7191 ms 3.1313 ms 17.731 ms 1.02 0.21 *****
ExpandOnly 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 19.108 ms 2.3344 ms 2.6883 ms 18.183 ms 1.03 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 25.750 ms 13.5618 ms 15.6178 ms 19.143 ms 1.39 0.84 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 18.604 ms 1.7745 ms 2.0435 ms 18.057 ms 1.00 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 19.395 ms 2.8665 ms 3.3010 ms 18.315 ms 1.04 0.22 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large Prefix Xml TakeTwentyEntries 20.296 ms 2.3011 ms 2.6499 ms 19.663 ms 1.09 0.19 *
WithoutExpand 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 20.831 ms 3.8218 ms 4.4012 ms 18.641 ms 1.04 0.28 *****
ExpandOnly 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 18.589 ms 2.2938 ms 2.6415 ms 17.955 ms 0.92 0.21 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 17.723 ms 1.5220 ms 1.7527 ms 17.231 ms 0.88 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 17.875 ms 2.2540 ms 2.5957 ms 16.825 ms 0.89 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 18.100 ms 1.4709 ms 1.6939 ms 17.900 ms 0.90 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large Prefix Xml TakeOneEntry 18.488 ms 1.6232 ms 1.8692 ms 17.816 ms 0.92 0.18 *
WithoutExpand 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 17.407 ms 1.5594 ms 1.7958 ms 17.068 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 18.501 ms 1.7340 ms 1.9968 ms 18.176 ms 1.07 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 17.834 ms 1.7765 ms 2.0458 ms 17.259 ms 1.03 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 18.007 ms 1.3325 ms 1.5345 ms 18.116 ms 1.04 0.12 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 18.821 ms 1.4526 ms 1.6728 ms 18.626 ms 1.09 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large Prefix Xml TakeTwoEntries 18.321 ms 1.4843 ms 1.7094 ms 18.075 ms 1.06 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 19.612 ms 2.3147 ms 2.6657 ms 18.910 ms 1.02 0.18 *****
ExpandOnly 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 19.303 ms 2.8125 ms 3.2388 ms 18.300 ms 1.00 0.20 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 19.161 ms 1.9352 ms 2.2285 ms 18.680 ms 0.99 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 18.405 ms 1.4997 ms 1.7271 ms 18.084 ms 0.95 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 18.441 ms 1.8277 ms 2.1047 ms 17.821 ms 0.96 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large Prefix Xml TakeFiveEntries 18.198 ms 1.9049 ms 2.1937 ms 17.406 ms 0.94 0.16 *
WithoutExpand 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 2.171 ms 0.4850 ms 0.5585 ms 1.934 ms 1.04 0.32 *****
ExpandOnly 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 1,032.723 ms 65.1050 ms 74.9750 ms 1,011.608 ms 497.05 95.07 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 2.582 ms 0.3881 ms 0.4469 ms 2.426 ms 1.24 0.31 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 1,030.675 ms 59.9549 ms 69.0441 ms 1,005.209 ms 496.06 93.88 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 1,035.832 ms 45.9473 ms 52.9130 ms 1,013.233 ms 498.54 91.89 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large OneEntry Xml UseFulltext 1,034.263 ms 63.1205 ms 72.6897 ms 1,010.162 ms 497.79 94.79 **
WithoutExpand 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 20.362 ms 3.8615 ms 4.4469 ms 18.872 ms 1.03 0.28 *****
ExpandOnly 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 18.857 ms 1.8176 ms 2.0932 ms 18.625 ms 0.96 0.18 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 19.596 ms 1.9807 ms 2.2810 ms 18.773 ms 1.00 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 18.794 ms 1.8477 ms 2.1278 ms 17.950 ms 0.95 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 19.033 ms 2.0181 ms 2.3241 ms 18.505 ms 0.97 0.19 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwentyEntries 18.898 ms 2.0458 ms 2.3559 ms 18.585 ms 0.96 0.19 *
WithoutExpand 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 25.856 ms 9.0849 ms 10.4622 ms 22.374 ms 1.09 0.51 *****
ExpandOnly 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 18.059 ms 1.5263 ms 1.7577 ms 17.554 ms 0.76 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 18.811 ms 1.5609 ms 1.7975 ms 18.353 ms 0.80 0.20 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 20.887 ms 3.1686 ms 3.6489 ms 19.949 ms 0.88 0.26 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 21.302 ms 3.3715 ms 3.8826 ms 19.919 ms 0.90 0.27 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large OneEntry Xml TakeOneEntry 19.182 ms 3.0313 ms 3.4908 ms 18.119 ms 0.81 0.24 *
WithoutExpand 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 17.785 ms 1.4396 ms 1.6579 ms 17.166 ms 1.01 0.12 *****
ExpandOnly 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 17.808 ms 1.6386 ms 1.8870 ms 17.282 ms 1.01 0.13 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 18.450 ms 1.8898 ms 2.1763 ms 17.914 ms 1.04 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 17.462 ms 1.4209 ms 1.6364 ms 16.773 ms 0.99 0.12 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 18.124 ms 1.8778 ms 2.1625 ms 17.504 ms 1.03 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large OneEntry Xml TakeTwoEntries 18.397 ms 1.6313 ms 1.8786 ms 18.010 ms 1.04 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 18.020 ms 1.5291 ms 1.7609 ms 17.400 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 19.155 ms 1.8127 ms 2.0875 ms 19.153 ms 1.07 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 18.562 ms 1.5641 ms 1.8012 ms 18.205 ms 1.04 0.13 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 19.285 ms 2.2509 ms 2.5922 ms 18.916 ms 1.08 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 18.150 ms 1.7052 ms 1.9637 ms 17.386 ms 1.01 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large OneEntry Xml TakeFiveEntries 20.743 ms 2.7683 ms 3.1879 ms 19.453 ms 1.16 0.20 *
WithoutExpand 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 2.394 ms 0.3418 ms 0.3936 ms 2.219 ms 1.02 0.21 *****
ExpandOnly 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 1,018.483 ms 57.6612 ms 66.4028 ms 990.752 ms 434.47 63.29 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 2.232 ms 0.5770 ms 0.6645 ms 1.996 ms 0.95 0.31 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 1,024.550 ms 51.7638 ms 59.6113 ms 997.926 ms 437.06 62.39 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 1,022.850 ms 46.2324 ms 53.2413 ms 994.699 ms 436.33 61.28 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large TwoEntries Xml UseFulltext 1,028.074 ms 46.0942 ms 53.0822 ms 1,004.783 ms 438.56 61.53 **
WithoutExpand 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 18.025 ms 1.9309 ms 2.2236 ms 17.509 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 19.277 ms 1.6978 ms 1.9552 ms 18.782 ms 1.08 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 20.545 ms 2.8618 ms 3.2957 ms 19.483 ms 1.15 0.21 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 20.662 ms 3.7604 ms 4.3305 ms 19.053 ms 1.16 0.26 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 18.122 ms 1.6696 ms 1.9228 ms 17.427 ms 1.02 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwentyEntries 18.377 ms 1.6191 ms 1.8646 ms 17.980 ms 1.03 0.14 *
WithoutExpand 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 20.867 ms 4.0600 ms 4.6755 ms 19.227 ms 1.04 0.29 *****
ExpandOnly 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 18.108 ms 2.4532 ms 2.8251 ms 17.032 ms 0.90 0.20 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 18.608 ms 2.1002 ms 2.4186 ms 18.016 ms 0.92 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 18.348 ms 1.8137 ms 2.0886 ms 17.851 ms 0.91 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 17.424 ms 1.5713 ms 1.8095 ms 16.859 ms 0.87 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large TwoEntries Xml TakeOneEntry 24.780 ms 11.3801 ms 13.1054 ms 18.381 ms 1.23 0.68 *
WithoutExpand 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 18.704 ms 1.8322 ms 2.1100 ms 18.514 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 19.813 ms 1.9843 ms 2.2851 ms 18.941 ms 1.07 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 17.968 ms 1.8338 ms 2.1118 ms 17.519 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 19.865 ms 1.8009 ms 2.0740 ms 19.616 ms 1.07 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 17.594 ms 1.4967 ms 1.7236 ms 17.187 ms 0.95 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large TwoEntries Xml TakeTwoEntries 17.758 ms 1.5502 ms 1.7853 ms 17.308 ms 0.96 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 18.767 ms 2.1654 ms 2.4937 ms 17.940 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 18.424 ms 1.2264 ms 1.4123 ms 18.335 ms 0.99 0.13 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 20.886 ms 3.6522 ms 4.2059 ms 18.540 ms 1.13 0.25 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 20.430 ms 2.0496 ms 2.3603 ms 20.013 ms 1.10 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 20.303 ms 2.0039 ms 2.3077 ms 19.900 ms 1.10 0.17 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large TwoEntries Xml TakeFiveEntries 20.762 ms 2.2985 ms 2.6469 ms 19.752 ms 1.12 0.18 *
WithoutExpand 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 2.757 ms 1.2151 ms 1.3993 ms 2.270 ms 1.11 0.61 *****
ExpandOnly 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 1,018.390 ms 52.3531 ms 60.2899 ms 992.180 ms 409.74 93.03 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 2.258 ms 0.3463 ms 0.3988 ms 2.074 ms 0.91 0.26 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 1,021.338 ms 46.5152 ms 53.5670 ms 998.864 ms 410.93 92.62 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 1,023.195 ms 66.6615 ms 76.7674 ms 994.689 ms 411.67 95.38 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large FiveEntries Xml UseFulltext 1,018.912 ms 43.2412 ms 49.7967 ms 1,007.473 ms 409.95 92.07 **
WithoutExpand 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 19.705 ms 2.3618 ms 2.7199 ms 18.896 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 18.201 ms 1.6749 ms 1.9289 ms 17.757 ms 0.94 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 19.783 ms 2.0350 ms 2.3436 ms 19.434 ms 1.02 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 24.641 ms 11.1753 ms 12.8695 ms 19.624 ms 1.27 0.66 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 18.509 ms 1.7954 ms 2.0676 ms 17.950 ms 0.95 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwentyEntries 19.125 ms 2.0335 ms 2.3417 ms 18.735 ms 0.98 0.15 *
WithoutExpand 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 17.479 ms 1.5181 ms 1.7482 ms 17.090 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 20.262 ms 2.6274 ms 3.0257 ms 19.170 ms 1.17 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 17.743 ms 2.2624 ms 2.6053 ms 16.862 ms 1.02 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 18.496 ms 1.6545 ms 1.9054 ms 18.206 ms 1.07 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 18.085 ms 1.9574 ms 2.2541 ms 17.620 ms 1.04 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large FiveEntries Xml TakeOneEntry 19.297 ms 1.9447 ms 2.2396 ms 18.721 ms 1.11 0.15 *
WithoutExpand 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 20.721 ms 2.2266 ms 2.5642 ms 20.225 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 20.015 ms 2.0921 ms 2.4092 ms 19.320 ms 0.98 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 19.503 ms 3.1138 ms 3.5858 ms 18.398 ms 0.95 0.20 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 18.096 ms 1.6886 ms 1.9446 ms 17.294 ms 0.88 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 24.797 ms 10.3791 ms 11.9526 ms 20.574 ms 1.21 0.59 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large FiveEntries Xml TakeTwoEntries 18.088 ms 1.6919 ms 1.9484 ms 17.742 ms 0.88 0.13 *
WithoutExpand 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 18.826 ms 1.4044 ms 1.6173 ms 18.659 ms 1.01 0.11 *****
ExpandOnly 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 18.059 ms 1.4137 ms 1.6280 ms 17.389 ms 0.97 0.11 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 20.390 ms 2.5092 ms 2.8896 ms 19.635 ms 1.09 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 19.110 ms 1.7284 ms 1.9904 ms 18.820 ms 1.02 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 18.850 ms 1.4040 ms 1.6168 ms 18.602 ms 1.01 0.11 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 Large FiveEntries Xml TakeFiveEntries 18.188 ms 1.5401 ms 1.7736 ms 17.585 ms 0.97 0.12 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 2.271 ms 0.4693 ms 0.5404 ms 2.102 ms 1.05 0.32 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 1,041.129 ms 47.9009 ms 55.1628 ms 1,038.575 ms 479.40 95.55 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 2.648 ms 0.4912 ms 0.5657 ms 2.413 ms 1.22 0.35 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 1,019.053 ms 50.9365 ms 58.6585 ms 997.453 ms 469.23 94.11 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 1,039.734 ms 72.0827 ms 83.0105 ms 1,010.711 ms 478.76 99.56 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge Prefix Xml UseFulltext 1,059.976 ms 122.1179 ms 140.6311 ms 1,018.746 ms 488.08 113.77 **
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 18.646 ms 2.0261 ms 2.3332 ms 17.808 ms 1.01 0.16 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 18.577 ms 1.8777 ms 2.1624 ms 17.956 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 19.367 ms 1.7661 ms 2.0338 ms 18.955 ms 1.05 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 18.308 ms 2.2490 ms 2.5899 ms 17.620 ms 0.99 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 18.540 ms 1.4871 ms 1.7126 ms 18.010 ms 1.01 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwentyEntries 19.062 ms 1.3204 ms 1.5205 ms 18.683 ms 1.03 0.13 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 17.820 ms 1.5744 ms 1.8131 ms 17.305 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 18.666 ms 2.6173 ms 3.0141 ms 17.619 ms 1.06 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 18.230 ms 1.9721 ms 2.2711 ms 17.487 ms 1.03 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 19.616 ms 3.9113 ms 4.5043 ms 17.732 ms 1.11 0.27 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 20.177 ms 2.5852 ms 2.9771 ms 19.613 ms 1.14 0.19 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeOneEntry 18.214 ms 1.5460 ms 1.7804 ms 17.899 ms 1.03 0.13 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 18.167 ms 1.6783 ms 1.9327 ms 17.685 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 18.089 ms 2.0267 ms 2.3340 ms 17.484 ms 1.00 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 18.466 ms 2.1026 ms 2.4213 ms 17.672 ms 1.02 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 18.418 ms 1.7303 ms 1.9926 ms 18.045 ms 1.02 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 18.198 ms 1.8622 ms 2.1445 ms 17.570 ms 1.01 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeTwoEntries 19.023 ms 2.5629 ms 2.9514 ms 18.154 ms 1.06 0.18 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 18.446 ms 1.6346 ms 1.8824 ms 18.097 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 18.102 ms 1.8924 ms 2.1792 ms 17.488 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 25.757 ms 11.6855 ms 13.4571 ms 21.541 ms 1.41 0.73 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 19.308 ms 1.3853 ms 1.5954 ms 19.041 ms 1.05 0.12 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 18.632 ms 2.0690 ms 2.3826 ms 17.728 ms 1.02 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge Prefix Xml TakeFiveEntries 18.566 ms 1.5846 ms 1.8248 ms 18.333 ms 1.01 0.13 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 2.524 ms 0.3958 ms 0.4558 ms 2.412 ms 1.02 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 1,025.619 ms 64.0205 ms 73.7261 ms 992.787 ms 415.75 61.62 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 2.199 ms 0.4583 ms 0.5278 ms 1.971 ms 0.89 0.24 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 1,044.651 ms 88.0496 ms 101.3980 ms 1,006.500 ms 423.47 68.40 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 1,011.926 ms 47.5552 ms 54.7647 ms 995.201 ms 410.20 57.72 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml UseFulltext 1,028.777 ms 69.0654 ms 79.5358 ms 1,000.007 ms 417.03 62.91 **
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 19.368 ms 2.2208 ms 2.5575 ms 18.811 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 19.225 ms 2.0341 ms 2.3425 ms 18.553 ms 1.01 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 20.457 ms 1.8924 ms 2.1793 ms 19.601 ms 1.07 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 18.761 ms 1.5825 ms 1.8225 ms 18.069 ms 0.98 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 18.987 ms 1.9752 ms 2.2746 ms 18.505 ms 0.99 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwentyEntries 19.077 ms 1.7011 ms 1.9590 ms 18.581 ms 1.00 0.14 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 17.820 ms 1.5078 ms 1.7364 ms 17.506 ms 1.01 0.12 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 18.437 ms 1.8507 ms 2.1313 ms 17.993 ms 1.04 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 18.469 ms 2.6560 ms 3.0586 ms 17.496 ms 1.04 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 17.510 ms 1.4434 ms 1.6623 ms 17.022 ms 0.99 0.12 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 18.959 ms 2.1170 ms 2.4379 ms 17.822 ms 1.07 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeOneEntry 19.281 ms 1.8268 ms 2.1038 ms 18.795 ms 1.09 0.14 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 25.430 ms 11.5761 ms 13.3311 ms 19.369 ms 1.17 0.72 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 17.857 ms 1.1726 ms 1.3504 ms 17.662 ms 0.82 0.26 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 19.568 ms 1.8590 ms 2.1408 ms 18.990 ms 0.90 0.29 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 18.003 ms 1.6173 ms 1.8625 ms 17.505 ms 0.83 0.27 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 19.990 ms 2.7814 ms 3.2030 ms 19.286 ms 0.92 0.32 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeTwoEntries 19.733 ms 2.2396 ms 2.5791 ms 19.291 ms 0.91 0.30 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 23.781 ms 3.6504 ms 4.2038 ms 22.262 ms 1.02 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 22.210 ms 3.1959 ms 3.6804 ms 21.410 ms 0.96 0.21 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 19.549 ms 2.2828 ms 2.6289 ms 18.894 ms 0.84 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 20.041 ms 2.0596 ms 2.3718 ms 19.392 ms 0.86 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 21.726 ms 3.3839 ms 3.8969 ms 20.343 ms 0.94 0.21 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge OneEntry Xml TakeFiveEntries 20.624 ms 2.3333 ms 2.6870 ms 19.552 ms 0.89 0.17 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 2.484 ms 0.4890 ms 0.5631 ms 2.246 ms 1.04 0.30 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 991.655 ms 32.4182 ms 37.3329 ms 982.437 ms 415.94 78.74 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 2.321 ms 0.3046 ms 0.3508 ms 2.229 ms 0.97 0.23 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 1,027.136 ms 69.5063 ms 80.0435 ms 1,004.886 ms 430.82 86.61 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 1,044.838 ms 69.1465 ms 79.6292 ms 996.392 ms 438.25 87.82 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml UseFulltext 1,002.469 ms 41.3028 ms 47.5644 ms 984.929 ms 420.47 80.50 **
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 18.965 ms 2.4946 ms 2.8728 ms 18.191 ms 1.02 0.19 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 24.014 ms 5.0028 ms 5.7612 ms 22.777 ms 1.29 0.33 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 20.810 ms 2.2313 ms 2.5696 ms 20.114 ms 1.11 0.18 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 19.166 ms 1.9466 ms 2.2417 ms 18.565 ms 1.03 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 25.419 ms 10.5509 ms 12.1504 ms 21.138 ms 1.36 0.65 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwentyEntries 23.489 ms 3.4740 ms 4.0006 ms 21.868 ms 1.26 0.25 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 20.768 ms 3.0262 ms 3.4850 ms 19.504 ms 1.02 0.22 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 20.468 ms 2.8063 ms 3.2318 ms 18.908 ms 1.01 0.21 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 18.599 ms 1.9772 ms 2.2770 ms 17.986 ms 0.92 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 17.929 ms 1.6434 ms 1.8925 ms 17.535 ms 0.88 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 18.270 ms 1.7190 ms 1.9796 ms 17.795 ms 0.90 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeOneEntry 17.742 ms 1.7594 ms 2.0262 ms 17.090 ms 0.87 0.16 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 18.215 ms 1.6868 ms 1.9425 ms 17.859 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 17.760 ms 1.9658 ms 2.2638 ms 17.033 ms 0.98 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 18.619 ms 1.5393 ms 1.7727 ms 18.335 ms 1.03 0.13 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 17.906 ms 1.8768 ms 2.1613 ms 17.427 ms 0.99 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 18.122 ms 1.5789 ms 1.8182 ms 17.587 ms 1.00 0.13 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeTwoEntries 18.378 ms 1.9655 ms 2.2634 ms 17.408 ms 1.02 0.15 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 18.243 ms 1.5030 ms 1.7309 ms 17.867 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 19.271 ms 2.2585 ms 2.6009 ms 18.197 ms 1.06 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 19.114 ms 1.9199 ms 2.2109 ms 17.976 ms 1.06 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 20.623 ms 2.0776 ms 2.3925 ms 20.186 ms 1.14 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 19.781 ms 1.7298 ms 1.9921 ms 19.135 ms 1.09 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge TwoEntries Xml TakeFiveEntries 18.302 ms 2.1837 ms 2.5147 ms 17.789 ms 1.01 0.16 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 2.185 ms 0.3115 ms 0.3587 ms 2.131 ms 1.02 0.22 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 1,024.689 ms 67.0632 ms 77.2300 ms 996.214 ms 480.02 78.63 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 2.687 ms 0.4452 ms 0.5127 ms 2.577 ms 1.26 0.30 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 992.123 ms 40.3113 ms 46.4225 ms 978.608 ms 464.77 71.15 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 1,015.199 ms 70.3224 ms 80.9834 ms 990.965 ms 475.58 78.86 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml UseFulltext 1,028.136 ms 67.3935 ms 77.6105 ms 1,001.276 ms 481.64 78.92 **
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 18.938 ms 2.5935 ms 2.9866 ms 18.042 ms 1.02 0.20 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 20.966 ms 3.0112 ms 3.4677 ms 19.415 ms 1.13 0.22 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 18.927 ms 1.9551 ms 2.2515 ms 18.267 ms 1.02 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 18.981 ms 2.3228 ms 2.6750 ms 18.103 ms 1.02 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 18.653 ms 1.5667 ms 1.8042 ms 18.271 ms 1.00 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwentyEntries 19.018 ms 2.1722 ms 2.5016 ms 18.386 ms 1.02 0.18 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 17.560 ms 1.5476 ms 1.7822 ms 17.069 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 18.531 ms 1.5994 ms 1.8419 ms 18.104 ms 1.06 0.13 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 18.228 ms 2.0767 ms 2.3915 ms 17.568 ms 1.05 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 19.296 ms 1.6744 ms 1.9282 ms 18.859 ms 1.11 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 18.452 ms 2.0262 ms 2.3333 ms 17.764 ms 1.06 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeOneEntry 18.204 ms 1.4647 ms 1.6867 ms 17.593 ms 1.04 0.13 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 18.213 ms 1.6974 ms 1.9547 ms 17.555 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 18.278 ms 1.6798 ms 1.9345 ms 17.879 ms 1.01 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 19.452 ms 1.7279 ms 1.9899 ms 19.025 ms 1.08 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 19.796 ms 2.2559 ms 2.5978 ms 19.162 ms 1.10 0.17 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 17.987 ms 1.4104 ms 1.6242 ms 17.687 ms 1.00 0.12 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeTwoEntries 18.177 ms 2.0737 ms 2.3880 ms 17.759 ms 1.01 0.16 *
WithoutExpand 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 19.370 ms 2.3694 ms 2.7286 ms 18.821 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 18.483 ms 1.8376 ms 2.1161 ms 17.671 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 18.478 ms 1.8107 ms 2.0852 ms 17.654 ms 0.97 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 18.489 ms 1.8427 ms 2.1220 ms 17.720 ms 0.97 0.15 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 18.386 ms 1.3405 ms 1.5438 ms 18.126 ms 0.96 0.12 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 ExtraLarge FiveEntries Xml TakeFiveEntries 18.717 ms 1.8473 ms 2.1273 ms 18.171 ms 0.98 0.15 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 2.286 ms 0.4283 ms 0.4932 ms 2.215 ms 1.04 0.29 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 1,010.819 ms 52.2815 ms 60.2075 ms 989.863 ms 459.64 89.05 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 2.294 ms 0.3603 ms 0.4149 ms 2.140 ms 1.04 0.27 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 1,055.062 ms 98.0996 ms 112.9716 ms 987.063 ms 479.76 102.15 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 1,111.930 ms 68.4656 ms 78.8451 ms 1,092.866 ms 505.62 99.84 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml UseFulltext 1,010.060 ms 51.9350 ms 59.8084 ms 983.869 ms 459.30 88.94 **
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 26.929 ms 11.7126 ms 13.4883 ms 19.908 ms 1.16 0.68 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 19.311 ms 2.6063 ms 3.0014 ms 18.133 ms 0.83 0.28 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 19.879 ms 2.1379 ms 2.4620 ms 19.532 ms 0.86 0.27 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 18.427 ms 1.3464 ms 1.5505 ms 17.721 ms 0.79 0.24 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 20.578 ms 3.2632 ms 3.7579 ms 19.233 ms 0.89 0.31 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwentyEntries 23.116 ms 4.3481 ms 5.0073 ms 21.818 ms 1.00 0.36 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 17.744 ms 1.8372 ms 2.1157 ms 17.238 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 19.678 ms 1.8986 ms 2.1865 ms 19.054 ms 1.12 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 22.790 ms 3.1720 ms 3.6529 ms 21.410 ms 1.30 0.23 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 18.269 ms 1.6774 ms 1.9318 ms 17.571 ms 1.04 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 18.138 ms 2.0266 ms 2.3338 ms 17.495 ms 1.03 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeOneEntry 18.490 ms 1.7391 ms 2.0028 ms 17.809 ms 1.05 0.14 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 17.974 ms 2.2197 ms 2.5562 ms 17.267 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 23.722 ms 10.7805 ms 12.4148 ms 18.610 ms 1.34 0.70 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 18.388 ms 1.6613 ms 1.9131 ms 18.000 ms 1.04 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 18.137 ms 1.9649 ms 2.2628 ms 17.328 ms 1.02 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 18.791 ms 1.8673 ms 2.1503 ms 18.372 ms 1.06 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeTwoEntries 20.470 ms 3.2862 ms 3.7844 ms 19.297 ms 1.15 0.24 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 18.482 ms 1.7261 ms 1.9878 ms 17.774 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 19.101 ms 1.8385 ms 2.1172 ms 18.516 ms 1.04 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 19.192 ms 1.8221 ms 2.0983 ms 18.576 ms 1.05 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 18.160 ms 1.6976 ms 1.9549 ms 17.595 ms 0.99 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 20.624 ms 2.5591 ms 2.9471 ms 19.906 ms 1.13 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge Prefix Xml TakeFiveEntries 20.418 ms 2.1468 ms 2.4723 ms 19.440 ms 1.11 0.16 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 2.384 ms 0.3647 ms 0.4200 ms 2.330 ms 1.02 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 1,024.817 ms 58.1048 ms 66.9136 ms 995.540 ms 440.06 67.90 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 2.781 ms 0.4305 ms 0.4958 ms 2.711 ms 1.19 0.27 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 1,008.039 ms 48.8514 ms 56.2574 ms 992.932 ms 432.86 65.21 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 1,039.374 ms 55.3811 ms 63.7769 ms 1,020.938 ms 446.31 68.16 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml UseFulltext 1,026.287 ms 48.5543 ms 55.9151 ms 999.660 ms 440.69 66.18 **
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 18.305 ms 1.7892 ms 2.0605 ms 17.617 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 19.621 ms 1.7815 ms 2.0515 ms 18.797 ms 1.08 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 19.186 ms 1.7958 ms 2.0681 ms 18.638 ms 1.06 0.14 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 19.681 ms 1.6652 ms 1.9176 ms 19.111 ms 1.09 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 19.208 ms 1.6814 ms 1.9363 ms 18.819 ms 1.06 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwentyEntries 26.091 ms 12.6888 ms 14.6124 ms 19.959 ms 1.44 0.80 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 18.316 ms 1.6802 ms 1.9349 ms 17.568 ms 1.01 0.14 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 18.764 ms 2.8635 ms 3.2976 ms 18.117 ms 1.03 0.20 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 18.397 ms 1.5799 ms 1.8194 ms 18.012 ms 1.01 0.13 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 21.421 ms 2.9223 ms 3.3653 ms 20.755 ms 1.18 0.21 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 17.890 ms 1.6688 ms 1.9218 ms 17.250 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeOneEntry 18.160 ms 1.4802 ms 1.7046 ms 17.745 ms 1.00 0.13 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 18.563 ms 2.1837 ms 2.5147 ms 17.816 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 18.058 ms 1.5798 ms 1.8192 ms 17.479 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 18.366 ms 1.9102 ms 2.1998 ms 17.718 ms 1.00 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 19.262 ms 2.7732 ms 3.1936 ms 17.733 ms 1.05 0.20 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 18.063 ms 1.5671 ms 1.8047 ms 17.470 ms 0.99 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeTwoEntries 17.784 ms 1.6256 ms 1.8721 ms 17.075 ms 0.97 0.14 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 19.609 ms 1.6866 ms 1.9423 ms 19.333 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 25.361 ms 10.3489 ms 11.9178 ms 20.338 ms 1.30 0.61 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 19.157 ms 2.4892 ms 2.8666 ms 18.061 ms 0.99 0.17 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 19.464 ms 2.2913 ms 2.6387 ms 18.737 ms 1.00 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 19.374 ms 1.7840 ms 2.0545 ms 18.887 ms 1.00 0.14 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge OneEntry Xml TakeFiveEntries 19.977 ms 2.3362 ms 2.6904 ms 19.186 ms 1.03 0.16 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 2.138 ms 0.3475 ms 0.4002 ms 2.091 ms 1.02 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 1,037.062 ms 63.5678 ms 73.2048 ms 1,008.363 ms 496.75 74.36 ***
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 2.734 ms 0.2905 ms 0.3345 ms 2.635 ms 1.31 0.23 **
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 1,028.056 ms 51.3594 ms 59.1456 ms 1,002.110 ms 492.43 71.00 ***
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 1,023.507 ms 41.5595 ms 47.8600 ms 1,007.906 ms 490.25 68.81 ***
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml UseFulltext 1,044.259 ms 75.9121 ms 87.4205 ms 1,027.694 ms 500.19 78.09 ***
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 20.430 ms 3.1625 ms 3.6420 ms 19.234 ms 1.02 0.22 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 19.519 ms 1.8762 ms 2.1606 ms 19.052 ms 0.98 0.16 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 19.311 ms 1.8710 ms 2.1546 ms 18.707 ms 0.97 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 20.034 ms 2.1691 ms 2.4979 ms 19.421 ms 1.00 0.18 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 19.555 ms 2.2415 ms 2.5814 ms 19.002 ms 0.98 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwentyEntries 18.782 ms 1.7706 ms 2.0391 ms 18.442 ms 0.94 0.16 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 18.057 ms 1.6565 ms 1.9076 ms 17.512 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 18.552 ms 2.3298 ms 2.6831 ms 17.714 ms 1.04 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 18.301 ms 2.1731 ms 2.5026 ms 17.431 ms 1.02 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 20.767 ms 2.6463 ms 3.0475 ms 19.721 ms 1.16 0.19 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 21.961 ms 7.5695 ms 8.7171 ms 18.661 ms 1.23 0.49 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeOneEntry 18.569 ms 1.8457 ms 2.1256 ms 18.083 ms 1.04 0.15 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 17.524 ms 1.4082 ms 1.6217 ms 17.110 ms 1.01 0.12 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 21.699 ms 3.7781 ms 4.3509 ms 20.361 ms 1.25 0.26 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 23.373 ms 4.0163 ms 4.6252 ms 22.055 ms 1.34 0.28 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 19.212 ms 1.6756 ms 1.9296 ms 18.691 ms 1.10 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 18.946 ms 3.9945 ms 4.6001 ms 17.465 ms 1.09 0.27 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeTwoEntries 19.022 ms 1.6816 ms 1.9365 ms 18.604 ms 1.09 0.13 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 19.397 ms 1.8619 ms 2.1441 ms 18.771 ms 1.01 0.15 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 19.372 ms 1.8349 ms 2.1131 ms 19.009 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 18.959 ms 2.0374 ms 2.3463 ms 17.852 ms 0.99 0.15 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 19.558 ms 2.0465 ms 2.3568 ms 19.235 ms 1.02 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 19.294 ms 1.8564 ms 2.1379 ms 18.765 ms 1.01 0.15 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge TwoEntries Xml TakeFiveEntries 26.179 ms 9.0330 ms 10.4024 ms 22.053 ms 1.36 0.55 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 2.279 ms 0.3428 ms 0.3948 ms 2.142 ms 1.03 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 1,095.572 ms 187.9893 ms 216.4887 ms 1,036.265 ms 492.75 120.62 **
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 2.779 ms 0.3635 ms 0.4186 ms 2.665 ms 1.25 0.26 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 1,051.923 ms 58.9965 ms 67.9405 ms 1,033.631 ms 473.12 76.26 **
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 1,099.100 ms 74.5289 ms 85.8276 ms 1,061.619 ms 494.34 82.51 **
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml UseFulltext 1,080.250 ms 51.6627 ms 59.4949 ms 1,064.455 ms 485.86 76.63 **
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 20.858 ms 2.3759 ms 2.7361 ms 19.873 ms 1.01 0.17 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 20.088 ms 1.9366 ms 2.2302 ms 19.344 ms 0.98 0.15 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 20.308 ms 2.0077 ms 2.3121 ms 19.848 ms 0.99 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 19.603 ms 2.1480 ms 2.4737 ms 18.909 ms 0.95 0.16 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 20.366 ms 2.6255 ms 3.0236 ms 19.733 ms 0.99 0.18 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwentyEntries 19.803 ms 2.0791 ms 2.3943 ms 19.277 ms 0.96 0.16 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 18.905 ms 1.7504 ms 2.0158 ms 18.418 ms 1.01 0.13 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 18.873 ms 1.8939 ms 2.1810 ms 18.388 ms 1.01 0.14 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 26.944 ms 13.1130 ms 15.1009 ms 21.072 ms 1.44 0.80 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 20.010 ms 1.4987 ms 1.7259 ms 19.449 ms 1.07 0.13 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 20.101 ms 3.5178 ms 4.0511 ms 18.341 ms 1.07 0.23 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeOneEntry 19.356 ms 2.1693 ms 2.4981 ms 18.871 ms 1.03 0.16 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 22.889 ms 3.4718 ms 3.9982 ms 21.517 ms 1.03 0.23 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 20.693 ms 1.8479 ms 2.1280 ms 19.867 ms 0.93 0.17 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 18.904 ms 2.7209 ms 3.1334 ms 17.929 ms 0.85 0.19 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 18.698 ms 1.4359 ms 1.6536 ms 18.250 ms 0.84 0.14 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 19.456 ms 2.0164 ms 2.3220 ms 18.581 ms 0.87 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeTwoEntries 21.810 ms 2.4769 ms 2.8524 ms 21.282 ms 0.98 0.19 *
WithoutExpand 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 23.398 ms 4.3046 ms 4.9571 ms 20.742 ms 1.03 0.27 *****
ExpandOnly 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 20.854 ms 2.4266 ms 2.7945 ms 19.677 ms 0.92 0.19 *
ExpandSkipXIncludeHighlightNone 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 19.392 ms 1.6302 ms 1.8773 ms 19.049 ms 0.86 0.16 *
ExpandSkipXIncludeHighlightElements 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 24.040 ms 11.1061 ms 12.7898 ms 19.088 ms 1.06 0.58 *
ExpandSkipXIncludeHighlightAttributes 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 18.673 ms 1.9144 ms 2.2047 ms 18.021 ms 0.83 0.16 *
ExpandSkipXIncludeHighlightBoth 1 1 ExistDbVersion640 DoubleExtraLarge FiveEntries Xml TakeFiveEntries 18.206 ms 1.4967 ms 1.7236 ms 17.887 ms 0.80 0.15 *

daliboris avatar Sep 01 '25 16:09 daliboris