How fast the Turbo Extract DataRaptor really is

In this section, let’s compare the Turbo Extract DataRaptor with the regular Extract type DataRaptor. Turbo Extract places some limitations on functionality in exchange for offering better performance. Let’s put it to the test to see how much of a performance improvement we can expect and when it’s best to use it in our applications.

Let’s use the same sample object we used earlier in this chapter. It has 4 custom fields and 1,000 test records. Let’s create a regular Extract-type DataRaptor and a Turbo Extract-type DataRaptor and use them to retrieve the same set of data. We will search on indexed and non-indexed fields to rule out the query performance factors.

Here’s the regular Extract DataRaptor, filtering on an indexed Id field:

Figure 9.34 – An overview of Extract DataRaptor filtering on Id

And here’s the Output tab showing the four fields...