Databases Reference
In-Depth Information
Figure 9-10.
Sample table containing documents in one database
Both records come from the database; you can see this by looking at the database GUID, which is similar for both
records. However, if you move the second record to another SQL Database instance, the average execution time drops
to about 1.8 seconds. Figure
9-11
shows the result of the same statement that executed in 1.4 seconds (you can see
that the database GUIDs are now different). This is half the execution time of the first result.
Figure 9-11.
Sample table containing documents in two databases
You can execute this statement much more quickly because almost the entire time is spent returning the
Document field. Figure
9-12
tells you that returning all the fields against both databases without the Document
field takes only 103 milliseconds. This shows that using a shard can provide performance benefits even if there is a
