Indexing

• Indexes
  • Plain indexes
  • Real-Time indexes
  • Distributed indexes
  • Templates indexes
  • Percolate indexes
  • Index files
  • Accessing index files
  • Operations on indexes
    • Declaration
    • Loading or discarding indexes
    • Index changes
• Data Types
  • Text
  • String
  • Integer
  • Big Integer
  • Timestamps
  • Float
  • JSON
  • Multi-value integer
  • Multi-value big integer
• Full-text fields
• Attributes
  • Example sphinx.conf part:
  • Example application code (in PHP):
• MVA (multi-valued attributes)
• Restrictions on the source data
• Charsets, case folding, translation tables, and replacement rules
• Data sources
• SQL data sources (MySQL, PostgreSQL)
  • Ranged queries
  • sql_query_post vs. sql_query_post_index
• xmlpipe2 data source
• TSV/CSV data source
• Live index updates
• Delta index updates
• Index merging