PUBLIC MARKS with tags free & sql

How do you implement full-text search for that 10 million row table, keep up with the load, and stay relevant? Sphinx is good at those kinds of riddles.

Sphinx is a standalone search engine, meant to provide fast, size-efficient and relevant fulltext search functions to other applications. Sphinx was specially designed to integrate well with SQL databases and scripting languages. Currently built-in data sources support fetching data either via direct connection to MySQL or PostgreSQL, or using XML pipe mechanism (a pipe to indexer in special XML-based format which Sphinx recognizes).

SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine.