
The data files and index files referenced by the query’s ECL code are made available in one of these ways, depending on the configuration of the Roxie cluster.
Two configuration settings in Configuration Manager determine how this works:
copyResources
Copies necessary data and key files from the current location when the query is published.
useRemoteResources
Loads necessary data and key files from the current location when the query is published.
These options may appear to be mutually exclusive, but the chart below shows what each possible combination means.
--------------------------------------------------------------------
copyResources T
useRemoteResources T
Directs the Roxie cluster to use the remote copy of the data until it can copy the data locally. This allows a query to be available immediately using the remote data until the copy completes.
--------------------------------------------------------------------
copyResources T
useRemoteResources F
Directs the Roxie cluster to copy the data locally. The query cannot be
executed until the data copy completes. This ensures optimum performance but
may delay the query's availability until the file copy completes.
--------------------------------------------------------------------
copyResources F
useRemoteResources T
Directs the Roxie cluster to load the data from a remote location and never copy locally. The query can be executed immediately, but performance is
limited by network bandwidth.
This allows queries to run without using any Roxie node disk space, but reduces its throughput capabilities. This is the default for a single node because Thor and Roxie are on the same node and share the same disk drives.
--------------------------------------------------------------------
copyResources F
useRemoteResources F
Will use data and indexes previously loaded but will not copy or read
remote data.