>
> source news_delta_0
> {
> type = mysql
> sql_host = localhost
> sql_user = root
> sql_pass =
> sql_db = development
> sql_sock = /var/run/mysqld/mysqld.sock
> sql_query_pre = SET TIME_ZONE = '+0:00'
> sql_query_pre = SET NAMES utf8
> sql_query = SELECT SQL_NO_CACHE `news`.`id` * 14 + 1 AS `id`,
> news.`content` AS `content`, news.`title` AS `title`, news.`id` AS
> `sphinx_internal_id`, 'News' AS `sphinx_internal_class`, 0 AS
> `sphinx_deleted`, UNIX_TIMESTAMP(news.`created_at`) AS `created_at`,
> UNIX_TIMESTAMP(news.`updated_at`) AS `updated_at`, GROUP_CONCAT(DISTINCT
> sites.`id` SEPARATOR ',') AS `site_id`, news.`published` AS `published`
> FROM `news` LEFT OUTER JOIN `sites` ON `sites`.`news_id` = `news`.`id`
> WHERE (`news`.`delta` = 1 AND `news`.`id` BETWEEN $start AND $end) GROUP BY
> `news`.`id`, news.`content`, news.`title`, news.`id`, news.`created_at`,
> news.`updated_at`, news.`published` ORDER BY NULL
> sql_query_range = SELECT IFNULL(MIN(`news`.`id`), 1),
> IFNULL(MAX(`news`.`id`), 1) FROM `news` WHERE (`news`.`delta` = 1)
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = sphinx_deleted
> sql_attr_bool = published
> sql_attr_timestamp = created_at
> sql_attr_timestamp = updated_at
> sql_attr_multi = uint site_id from field
> sql_attr_string = sphinx_internal_class
> sql_query_info = SELECT `news`.* FROM `news` WHERE (`news`.`id` = ($id
> - 1) / 14)
> }
>
Full config, just in case. And 'config/thinking_sphinx.yml':
development: &options
html_strip: true
enable_star: true
min_infix_len: 3 # if you want to index inner parts of words
mem_limit: 128M # the more memory, the faster your indexes will be
processed
indexed_models:
- News
test:
*options
production:
*options
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/thinking-sphinx.
For more options, visit https://groups.google.com/d/optout.
