You can configure IDOL Server to identify fields that contain dates. When these fields are indexed, IDOL Server stores them in a fast look-up table in memory, so that it can quickly return the fields.
Note: You cannot configure a field with two numeric-based types concurrently. Numeric-based types include NumericType, NumericDateType, MatchType, ParametricRangeType, ReferenceMemoryMappedType, and ParametricType when the ParametricNumericMapping configuration parameter is set to True.
IDOL Server converts dates to numerical values (epoch seconds) and identifies the fields that contain the numerical date values.
Open the IDOL Server configuration file in a text editor.
List a process that identifies numeric date fields in the [FieldProcessing] section. For example:
[FieldProcessing] 0=MyFirstProcess 1=NumericDateFields
Create a section for each process that you listed, and in each section, create a property for the process (you define the property by setting one or more applicable configuration parameters). Identify the fields that you want to associate with the process.
Note: The properties that you create must not have the same name as the processes.
For example:
[MyFirstProcess] Property=MyProperty PropertyFieldCSVs=*/MyField,*/MyOtherField [NumericDateFields] Property=NumDate PropertyFieldCSVs=*/BIRTHDAY,*/STARTDATE
Create a section for the property in which you set the NumericDateType parameter to True. This enables IDOL Server to memory map the associated PropertyFieldCSVs fields, and identify them as fields that contain date values. For example:
[NumDate] NumericDateType=True
Save and close the configuration file. Restart IDOL Server for your changes to take effect.
If you now send a query for a specific value that is stored in the BIRTHDAY field, IDOL Server memory maps the range that this value is in, so that it can return results more quickly next time a value that lies in this range is queried.
For example:
http://12.3.4.56:4000/action=Query&FieldText=RANGE{01/01/1980,31/12/1980}:BIRTHDAY
The BIRTHDAY field must contain a numeric date value that is between 01/01/1980 and 31/12/1980 for this document to be returned.
|
|