![]() Disk usage is the same as the memory usage.ĮQUAL queries work only against numeric values (such as 12554, 43.27, -3712.39). You can limit the memory usage for a field by using the NumericNormalMaxMem configuration parameter. Memory usage is proportional to the number of NumericType fields, and the number of instances of those fields. Optimized EQUAL queries are much faster than the unoptimized equivalent for exact-value matches, at the cost of RAM and disk space. NumericType fields have the additional advantage that they are optimized for the RANGE, GREATER, and LESS operators, which allow you to search for a range of numeric values. In optimized EQUAL queries, you use the FieldText EQUAL operator on a field that you have configured with the NumericType property. Additionally, EQUAL matches all numeric variations of a value, so that 1 is the same as 01, 001, and 1.0. Do not use these queries for arbitrary strings (such as dog, cat, apples). This option might make sense when you very rarely query against the field, and when saving RAM and disk space is more important than query performance.ĮQUAL queries work only against numeric values (such as 12554, 43.27, -3712.39). In an unoptimized EQUAL query, you use the FieldText EQUAL operator on a field that has no special configuration. Query NameĪction=Query&FieldText=EQUAL:DocumentTypeĭocumentType field set as Index field type.ĭocumentType field set as FieldCheckType. The following table describes the different types of query you can use to search for a value of 230 in the DocumentType field. This field is generated by IDOL KeyView, and contains a numeric value. The following examples consider a query for a value in the DocumentType field. This topic discusses a number of different ways that you can query for numeric values, and the performance and configuration advantages and disadvantages of these configurations. Improve IDOL Performance > Improve Query Performance > Worked Example: Query for Numeric Values Worked Example: Query for Numeric Values ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |