1 Database Creation
- 1.1 Designing the database
- 1.2 Standard tables
- 1.3 Disk layout of the table and indexes
- 1.4 Ordering data for performance
- 1.5 Counter data type, other types
- 1.6 Database security
2 Importing Data
- 2.1 TIMPORT - the program
- 2.2 The TIMPORT function in Texis
- 2.3 Timport Schemas
- 2.4 Other Import Methods
- 2.5 Processing batches
- 2.6 Handling continuous streams
- 2.7 Performance impact
3 Creating Queries
- 3.1 Search strategies
- 3.2 Ordering clauses
- 3.3 Joins and subqueries
- 3.4 Choosing the appropriate indices
4 Metamorph Queries
- 4.1 Metamorph Philosophy
- 4.2 Query syntax
- 4.3 Query protection
- 4.4 Query processing options
- 4.5 Different types of text queries in Texis
- 4.6 Index types
- 4.7 Index Issues
5 Indexing
- 5.1 Regular Index
- 5.2 Metamorph Index
6 Metamorph Index Updates
7 Performance and Installation Notes
- 7.1 Typical installation
- 7.2 Texis parameters
- 7.3 Disk layout
- 7.4 RAM: cache most-common index
- 7.5 Large number of records
- 7.6 Large number of searchable fields
- 7.7 Multiple machines sharing the load
- 7.8 Minimizing the work done on user interaction
- 7.9 Caching frequently accessed results
- 7.10 Seek optimization
8 Vortex Introduction
- 8.1 Hello World
- 8.2 Script Syntax
- 8.3 URL Syntax
- 8.4 User Input
  - 8.4.1 User Input - Continued
  - 8.4.2 User Input - Continued
- 8.5 Variable Manipulation
- 8.6 Variable Values
  - 8.6.1 Variable Values - Continued
  - 8.6.2 Variable Values - Continued
- 8.7 LOOP
- 8.8 Variable Types
- 8.9 Variable Initialization
- 8.10 Functions
  - 8.10.1 Function Scope
  - 8.10.2 Function Parameters
  - 8.10.3 Pass by Value vs. Pass by Reference
9 Common Tasks in Vortex
- 9.1 Look and Feel Functions
- 9.2 Embedding Javascript
- 9.3 Generating HTML Forms
- 9.4 Patent Search
  - 9.4.1 Patent Search - Continued
- 9.5 SQL Queries
  - 9.5.1 Special SQL Variables
  - 9.5.2 SQL Parameters
  - 9.5.3 Multi-value SQL Parameters
  - 9.5.4 Altering the Query with $null
- 9.6 Formatting Output with fmt
- 9.7 State Retention
- 9.8 Query Markup
  - 9.8.1 Query Markup - Multiple Variables
- 9.9 Paginating Results
10 Advanced Vortex Topics
- 10.1 rex and sandr
- 10.2 Dynamic Error Handling
- 10.3 Geographic Searching
  - 10.3.1 Using ZIP Codes
  - 10.3.2 Delimiting an Entire Region
- 10.4 Fast Value Lookup - xtree
  - 10.4.1 xtree - Continued
- 10.5 Creating User Functions in C
- 10.6 Multi-part File Uploads
- 10.7 Controlled Access Applications
  - 10.7.1 Controlled Access Applications - Continued
  - 10.7.2 Controlled Access Applications - Continued
11 Vortex Library Modules
- 11.1 Writing a Module
- 11.2 Inserting a Module
- 11.3 Using a Module
- 11.4 Checking Out a Module
- 11.5 Updating a Module
- 11.6 Checking In a New Revision
- 11.7 Using a New Revision
- 11.8 Function Scope in Modules
- 11.9 Using Older Revisions
- 11.10 Multiple Modules
- 11.11 Other Module Options
12 Vortex Coding Tips
13 Common Vortex Mistakes
14 Processing Data from the Web
- 14.1 The fetch Statement
  - 14.1.1 The fetch Statement - Continued
- 14.2 Detailed Page Info
- 14.3 Controlling Fetch Behavior
- 14.4 Accessing Forms
  - 14.4.1 Accessing Forms - Continued
- 14.5 Parsing Search Results
  - 14.5.1 Parsing Search Results - Continued
- 14.6 Searching Multiple Sites Concurrently
  - 14.6.1 Searching Multiple Sites Concurrently - Continued
- 14.7 In-line Search and Replace
  - 14.7.1 Dynamic Replace Strings
  - 14.7.2 Dynamic Replace Strings - Continued
  - 14.7.3 Parsing Forms with SANDCALL
    - 14.7.3.1 Parsing Forms with SANDCALL - Continued
    - 14.7.3.2 Parsing Forms with SANDCALL - Continued
- 14.8 FTPing Large Files
15 Texis Web Server - vhttpd
16 Profiling
- 16.1 <Profiler> and LIKEIN - How to use
- 16.2 Metamorph counter index

Next: Database Creation


Table of Contents