source table
{

type = mysql
sql_host = localhost
sql_user =
sql_pass =
sql_db = table
sql_port = 3306


sql_query_pre = SET NAMES utf8
sql_query_pre = SET CHARACTER SET utf8


sql_query = SELECT id, cast, director FROM table ORDER BY id DESC

sql_field_string = cast

sql_field_string = director

sql_ranged_throttle = 0
}

index table
{
source = table

path = /home/sphinx/data/table

docinfo = extern

morphology = stem_enru

min_word_len = 1

charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F, U+401->U+0435, U+451->U+0435

min_infix_len = 2

index_exact_words = 1
}

indexer
{
mem_limit = 256M
}

searchd
{
listen = 3312

log = /home/sphinx/log/searchd.log

read_timeout = 5

max_children = 30

pid_file = /home/sphinx/log/searchd.pid
}

sql_query_range = SELECT MIN(id),MAX(id) FROM table

#количество записей за раз
sql_range_step = 10000

sql_query = SELECT id, cast, director FROM table WHERE id>=$start AND id<=$end