Sorry Pat
Actually I posted wrong file.
pravious file is generated when I use thinking sphinx version 1.3.5
This is correct file of version 1.3.14
indexer
{
mem_limit = 1024M
}
searchd
{
listen = 127.0.0.1:3310
log = /home/rahul/application/demo/log/searchd.log
query_log = /home/rahul/application/demo/log/searchd.query.log
pid_file = /home/rahul/application/demo/log/searchd.development.pid
}
source account_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta"
= TRUE
sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" ,
"accounts"."name" AS "account_name", array_to_string(array_accum
(COALESCE("contacts"."first_name", '0')), ' ') AS
"contact_first_name", array_to_string(array_accum(COALESCE
("contacts"."last_name", '0')), ' ') AS "contact_last_name",
array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
"sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
"company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
"contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
"accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY
"accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
"accounts"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) /
6)
}
index account_core
{
source = account_core_0
path = /home/rahul/application/demo/db/sphinx/development/
account_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = account_name, contact_first_name, contact_last_name,
contact_email
enable_star = 1
}
source account_delta_0 : account_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" ,
"accounts"."name" AS "account_name", array_to_string(array_accum
(COALESCE("contacts"."first_name", '0')), ' ') AS
"contact_first_name", array_to_string(array_accum(COALESCE
("contacts"."last_name", '0')), ' ') AS "contact_last_name",
array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
"sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
"company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
"contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
"accounts"."delta" = TRUE AND accounts.deleted_at is null GROUP BY
"accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
"accounts"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) /
6)
}
index account_delta : account_core
{
source = account_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
account_delta
}
index account
{
type = distributed
local = account_delta
local = account_core
}
source account_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta"
= TRUE
sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" ,
"accounts"."name" AS "account_name", array_to_string(array_accum
(COALESCE("contacts"."first_name", '0')), ' ') AS
"contact_first_name", array_to_string(array_accum(COALESCE
("contacts"."last_name", '0')), ' ') AS "contact_last_name",
array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
"sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
"company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
"contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
"accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY
"accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
"accounts"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) /
6)
}
index account_core
{
source = account_core_0
path = /home/rahul/application/demo/db/sphinx/development/
account_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = account_name, contact_first_name, contact_last_name,
contact_email
enable_star = 1
}
source account_delta_0 : account_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "accounts"."id" * 6 + 0 AS "id" ,
"accounts"."name" AS "account_name", array_to_string(array_accum
(COALESCE("contacts"."first_name", '0')), ' ') AS
"contact_first_name", array_to_string(array_accum(COALESCE
("contacts"."last_name", '0')), ' ') AS "contact_last_name",
array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
"sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
"company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
"contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
"accounts"."delta" = TRUE AND accounts.deleted_at is null GROUP BY
"accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
"accounts"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 0) /
6)
}
index account_delta : account_core
{
source = account_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
account_delta
}
index account
{
type = distributed
local = account_delta
local = account_core
}
source contact_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "contacts" SET "delta" = FALSE WHERE "delta"
= TRUE
sql_query = SELECT "contacts"."id" * 6 + 1 AS "id" ,
"contacts"."first_name" AS "first_name", "contacts"."last_name" AS
"last_name", "contacts"."email" AS "email", "accounts"."name" AS
"contact_account_name", "contacts"."id" AS "sphinx_internal_id",
2212487076 AS "class_crc", '2212487076' AS "subclass_crcs", 0 AS
"sphinx_deleted", "contacts"."id" AS "id", "contacts"."company_id" AS
"company_id", "contacts"."status_type" AS "status_type",
"accounts"."id" AS "contact_account_id" FROM "contacts" LEFT OUTER
JOIN "account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"contacts"."id" >= $start AND "contacts"."id" <= $end AND
"contacts"."delta" = FALSE AND status_type in (select id from lookups
where (type='ProspectStatusType' or type = 'LeadStatusType') and
lvalue<>'Rejected') or contacts.deleted_at is null GROUP BY
"contacts"."id", "contacts"."first_name", "contacts"."last_name",
"contacts"."email", "accounts"."name", "contacts"."id",
"contacts"."id", "contacts"."company_id", "contacts"."status_type",
"accounts"."id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "contacts" WHERE "contacts"."delta" = FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_uint = status_type
sql_attr_uint = contact_account_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "contacts" WHERE "id" = (($id - 1) /
6)
}
index contact_core
{
source = contact_core_0
path = /home/rahul/application/demo/db/sphinx/development/
contact_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = first_name, last_name, email, contact_account_name
enable_star = 1
}
source contact_delta_0 : contact_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "contacts"."id" * 6 + 1 AS "id" ,
"contacts"."first_name" AS "first_name", "contacts"."last_name" AS
"last_name", "contacts"."email" AS "email", "accounts"."name" AS
"contact_account_name", "contacts"."id" AS "sphinx_internal_id",
2212487076 AS "class_crc", '2212487076' AS "subclass_crcs", 0 AS
"sphinx_deleted", "contacts"."id" AS "id", "contacts"."company_id" AS
"company_id", "contacts"."status_type" AS "status_type",
"accounts"."id" AS "contact_account_id" FROM "contacts" LEFT OUTER
JOIN "account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"contacts"."id" >= $start AND "contacts"."id" <= $end AND
"contacts"."delta" = TRUE AND status_type in (select id from lookups
where (type='ProspectStatusType' or type = 'LeadStatusType') and
lvalue<>'Rejected') or contacts.deleted_at is null GROUP BY
"contacts"."id", "contacts"."first_name", "contacts"."last_name",
"contacts"."email", "accounts"."name", "contacts"."id",
"contacts"."id", "contacts"."company_id", "contacts"."status_type",
"accounts"."id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "contacts" WHERE "contacts"."delta" = TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_uint = status_type
sql_attr_uint = contact_account_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "contacts" WHERE "id" = (($id - 1) /
6)
}
index contact_delta : contact_core
{
source = contact_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
contact_delta
}
index contact
{
type = distributed
local = contact_delta
local = contact_core
}
source contact_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "contacts" SET "delta" = FALSE WHERE "delta"
= TRUE
sql_query = SELECT "contacts"."id" * 6 + 1 AS "id" ,
"contacts"."first_name" AS "first_name", "contacts"."last_name" AS
"last_name", "contacts"."email" AS "email", "accounts"."name" AS
"contact_account_name", "contacts"."id" AS "sphinx_internal_id",
2212487076 AS "class_crc", '2212487076' AS "subclass_crcs", 0 AS
"sphinx_deleted", "contacts"."id" AS "id", "contacts"."company_id" AS
"company_id", "contacts"."status_type" AS "status_type",
"accounts"."id" AS "contact_account_id" FROM "contacts" LEFT OUTER
JOIN "account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"contacts"."id" >= $start AND "contacts"."id" <= $end AND
"contacts"."delta" = FALSE AND status_type in (select id from lookups
where (type='ProspectStatusType' or type = 'LeadStatusType') and
lvalue<>'Rejected') or contacts.deleted_at is null GROUP BY
"contacts"."id", "contacts"."first_name", "contacts"."last_name",
"contacts"."email", "accounts"."name", "contacts"."id",
"contacts"."id", "contacts"."company_id", "contacts"."status_type",
"accounts"."id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "contacts" WHERE "contacts"."delta" = FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_uint = status_type
sql_attr_uint = contact_account_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "contacts" WHERE "id" = (($id - 1) /
6)
}
index contact_core
{
source = contact_core_0
path = /home/rahul/application/demo/db/sphinx/development/
contact_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = first_name, last_name, email, contact_account_name
enable_star = 1
}
source contact_delta_0 : contact_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "contacts"."id" * 6 + 1 AS "id" ,
"contacts"."first_name" AS "first_name", "contacts"."last_name" AS
"last_name", "contacts"."email" AS "email", "accounts"."name" AS
"contact_account_name", "contacts"."id" AS "sphinx_internal_id",
2212487076 AS "class_crc", '2212487076' AS "subclass_crcs", 0 AS
"sphinx_deleted", "contacts"."id" AS "id", "contacts"."company_id" AS
"company_id", "contacts"."status_type" AS "status_type",
"accounts"."id" AS "contact_account_id" FROM "contacts" LEFT OUTER
JOIN "account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"contacts"."id" >= $start AND "contacts"."id" <= $end AND
"contacts"."delta" = TRUE AND status_type in (select id from lookups
where (type='ProspectStatusType' or type = 'LeadStatusType') and
lvalue<>'Rejected') or contacts.deleted_at is null GROUP BY
"contacts"."id", "contacts"."first_name", "contacts"."last_name",
"contacts"."email", "accounts"."name", "contacts"."id",
"contacts"."id", "contacts"."company_id", "contacts"."status_type",
"accounts"."id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "contacts" WHERE "contacts"."delta" = TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_uint = status_type
sql_attr_uint = contact_account_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "contacts" WHERE "id" = (($id - 1) /
6)
}
index contact_delta : contact_core
{
source = contact_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
contact_delta
}
index contact
{
type = distributed
local = contact_delta
local = contact_core
}
source opportunity_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "opportunities" SET "delta" = FALSE WHERE
"delta" = TRUE
sql_query = SELECT "opportunities"."id" * 6 + 4 AS "id" ,
"opportunities"."name" AS "opportunity_name", "contacts"."first_name"
AS "contact_first_name", "contacts"."last_name" AS
"contact_last_name", "contacts"."email" AS "contact_email",
"accounts"."name" AS "opportunity_conatct_account_name",
"opportunities"."id" AS "sphinx_internal_id", 85281792 AS "class_crc",
'85281792' AS "subclass_crcs", 0 AS "sphinx_deleted",
"opportunities"."id" AS "id", "opportunities"."company_id" AS
"company_id" FROM "opportunities" LEFT OUTER JOIN "contacts" ON
"contacts".id = "opportunities".contact_id LEFT OUTER JOIN
"account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"opportunities"."id" >= $start AND "opportunities"."id" <= $end AND
"opportunities"."delta" = FALSE AND opportunities.deleted_at is null
GROUP BY "opportunities"."id", "opportunities"."name",
"contacts"."first_name", "contacts"."last_name", "contacts"."email",
"accounts"."name", "opportunities"."id", "opportunities"."id",
"opportunities"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "opportunities" WHERE "opportunities"."delta"
= FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "opportunities" WHERE "id" = (($id -
4) / 6)
}
index opportunity_core
{
source = opportunity_core_0
path = /home/rahul/application/demo/db/sphinx/development/
opportunity_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = opportunity_name, contact_first_name,
contact_last_name, contact_email, opportunity_conatct_account_name
enable_star = 1
}
source opportunity_delta_0 : opportunity_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "opportunities"."id" * 6 + 4 AS "id" ,
"opportunities"."name" AS "opportunity_name", "contacts"."first_name"
AS "contact_first_name", "contacts"."last_name" AS
"contact_last_name", "contacts"."email" AS "contact_email",
"accounts"."name" AS "opportunity_conatct_account_name",
"opportunities"."id" AS "sphinx_internal_id", 85281792 AS "class_crc",
'85281792' AS "subclass_crcs", 0 AS "sphinx_deleted",
"opportunities"."id" AS "id", "opportunities"."company_id" AS
"company_id" FROM "opportunities" LEFT OUTER JOIN "contacts" ON
"contacts".id = "opportunities".contact_id LEFT OUTER JOIN
"account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"opportunities"."id" >= $start AND "opportunities"."id" <= $end AND
"opportunities"."delta" = TRUE AND opportunities.deleted_at is null
GROUP BY "opportunities"."id", "opportunities"."name",
"contacts"."first_name", "contacts"."last_name", "contacts"."email",
"accounts"."name", "opportunities"."id", "opportunities"."id",
"opportunities"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "opportunities" WHERE "opportunities"."delta"
= TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "opportunities" WHERE "id" = (($id -
4) / 6)
}
index opportunity_delta : opportunity_core
{
source = opportunity_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
opportunity_delta
}
index opportunity
{
type = distributed
local = opportunity_delta
local = opportunity_core
}
source opportunity_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre = UPDATE "opportunities" SET "delta" = FALSE WHERE
"delta" = TRUE
sql_query = SELECT "opportunities"."id" * 6 + 4 AS "id" ,
"opportunities"."name" AS "opportunity_name", "contacts"."first_name"
AS "contact_first_name", "contacts"."last_name" AS
"contact_last_name", "contacts"."email" AS "contact_email",
"accounts"."name" AS "opportunity_conatct_account_name",
"opportunities"."id" AS "sphinx_internal_id", 85281792 AS "class_crc",
'85281792' AS "subclass_crcs", 0 AS "sphinx_deleted",
"opportunities"."id" AS "id", "opportunities"."company_id" AS
"company_id" FROM "opportunities" LEFT OUTER JOIN "contacts" ON
"contacts".id = "opportunities".contact_id LEFT OUTER JOIN
"account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"opportunities"."id" >= $start AND "opportunities"."id" <= $end AND
"opportunities"."delta" = FALSE AND opportunities.deleted_at is null
GROUP BY "opportunities"."id", "opportunities"."name",
"contacts"."first_name", "contacts"."last_name", "contacts"."email",
"accounts"."name", "opportunities"."id", "opportunities"."id",
"opportunities"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "opportunities" WHERE "opportunities"."delta"
= FALSE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "opportunities" WHERE "id" = (($id -
4) / 6)
}
index opportunity_core
{
source = opportunity_core_0
path = /home/rahul/application/demo/db/sphinx/development/
opportunity_core
morphology = none
min_word_len = 2
charset_type = utf-8
min_prefix_len = 2
prefix_fields = opportunity_name, contact_first_name,
contact_last_name, contact_email, opportunity_conatct_account_name
enable_star = 1
}
source opportunity_delta_0 : opportunity_core_0
{
type = pgsql
sql_host = 127.0.0.1
sql_user = *****
sql_pass = *****
sql_db = demo_dev_29122009
sql_query_pre =
sql_query = SELECT "opportunities"."id" * 6 + 4 AS "id" ,
"opportunities"."name" AS "opportunity_name", "contacts"."first_name"
AS "contact_first_name", "contacts"."last_name" AS
"contact_last_name", "contacts"."email" AS "contact_email",
"accounts"."name" AS "opportunity_conatct_account_name",
"opportunities"."id" AS "sphinx_internal_id", 85281792 AS "class_crc",
'85281792' AS "subclass_crcs", 0 AS "sphinx_deleted",
"opportunities"."id" AS "id", "opportunities"."company_id" AS
"company_id" FROM "opportunities" LEFT OUTER JOIN "contacts" ON
"contacts".id = "opportunities".contact_id LEFT OUTER JOIN
"account_contacts" ON ("contacts"."id" =
"account_contacts"."contact_id") LEFT OUTER JOIN "accounts" ON
("accounts"."id" = "account_contacts"."account_id") WHERE
"opportunities"."id" >= $start AND "opportunities"."id" <= $end AND
"opportunities"."delta" = TRUE AND opportunities.deleted_at is null
GROUP BY "opportunities"."id", "opportunities"."name",
"contacts"."first_name", "contacts"."last_name", "contacts"."email",
"accounts"."name", "opportunities"."id", "opportunities"."id",
"opportunities"."company_id"
sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
("id"), 1::bigint) FROM "opportunities" WHERE "opportunities"."delta"
= TRUE
sql_attr_uint = sphinx_internal_id
sql_attr_uint = class_crc
sql_attr_uint = sphinx_deleted
sql_attr_uint = id
sql_attr_uint = company_id
sql_attr_multi = uint subclass_crcs from field
sql_query_info = SELECT * FROM "opportunities" WHERE "id" = (($id -
4) / 6)
}
index opportunity_delta : opportunity_core
{
source = opportunity_delta_0
path = /home/rahul/application/demo/db/sphinx/development/
opportunity_delta
}
index opportunity
{
type = distributed
local = opportunity_delta
local = opportunity_core
}
On Jan 5, 6:49 pm, rahul100885 <[email protected]> wrote:
> ######################################### development.sphinx.conf
> #############################################
>
> indexer
> {
> mem_limit = 1024M
>
> }
>
> searchd
> {
> address = 127.0.0.1
> port = 3310
> log = /home/rahul/application/demo/log/searchd.log
> query_log = /home/rahul/application/demo/log/searchd.query.log
> pid_file = /home/rahul/application/demo/log/searchd.development.pid
>
> }
>
> source matter_core_0
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre = UPDATE "matters" SET "delta" = FALSE WHERE "delta" =
> TRUE
> sql_query = SELECT "matters"."id" * 6 + 0 AS "id" , "matters"."name"
> AS "matter_name", "users"."first_name" AS "contact_first_name",
> "users"."last_name" AS "contact_last_name", "matters"."id" AS
> "sphinx_internal_id", 3077742169 AS "class_crc", '3077742169' AS
> "subclass_crcs", 0 AS "sphinx_deleted", "matters"."id" AS "id",
> "matters"."company_id" AS "company_id" FROM "matters" LEFT OUTER
> JOIN "users" ON "users".id = "matters".employee_user_id WHERE
> "matters"."id" >= $start AND "matters"."id" <= $end AND
> "matters"."delta" = FALSE GROUP BY "matters"."id", "matters"."name",
> "users"."first_name", "users"."last_name", "matters"."id",
> "matters"."id", "matters"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "matters" WHERE "matters"."delta" = FALSE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "matters" WHERE "id" = (($id - 0) /
> 6)
>
> }
>
> source matter_core_1
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre = UPDATE "matters" SET "delta" = FALSE WHERE "delta" =
> TRUE
> sql_query = SELECT "matters"."id" * 6 + 0 AS "id" , "matters"."name"
> AS "matter_name", "users"."first_name" AS "contact_first_name",
> "users"."last_name" AS "contact_last_name", "matters"."id" AS
> "sphinx_internal_id", 3077742169 AS "class_crc", '3077742169' AS
> "subclass_crcs", 0 AS "sphinx_deleted", "matters"."id" AS "id",
> "matters"."company_id" AS "company_id" FROM "matters" LEFT OUTER
> JOIN "users" ON "users".id = "matters".employee_user_id WHERE
> "matters"."id" >= $start AND "matters"."id" <= $end AND
> "matters"."delta" = FALSE GROUP BY "matters"."id", "matters"."name",
> "users"."first_name", "users"."last_name", "matters"."id",
> "matters"."id", "matters"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "matters" WHERE "matters"."delta" = FALSE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "matters" WHERE "id" = (($id - 0) /
> 6)
>
> }
>
> index matter_core
> {
> source = matter_core_0
> source = matter_core_1
> path = /home/rahul/application/demo/db/sphinx/development/
> matter_core
> morphology = none
> min_word_len = 2
> charset_type = utf-8
> min_prefix_len = 2
> prefix_fields = matter_name, contact_first_name, contact_last_name,
> matter_name, contact_first_name, contact_last_name
> enable_star = 1
>
> }
>
> source matter_delta_0 : matter_core_0
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre =
> sql_query = SELECT "matters"."id" * 6 + 0 AS "id" , "matters"."name"
> AS "matter_name", "users"."first_name" AS "contact_first_name",
> "users"."last_name" AS "contact_last_name", "matters"."id" AS
> "sphinx_internal_id", 3077742169 AS "class_crc", '3077742169' AS
> "subclass_crcs", 0 AS "sphinx_deleted", "matters"."id" AS "id",
> "matters"."company_id" AS "company_id" FROM "matters" LEFT OUTER
> JOIN "users" ON "users".id = "matters".employee_user_id WHERE
> "matters"."id" >= $start AND "matters"."id" <= $end AND
> "matters"."delta" = TRUE GROUP BY "matters"."id", "matters"."name",
> "users"."first_name", "users"."last_name", "matters"."id",
> "matters"."id", "matters"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "matters" WHERE "matters"."delta" = TRUE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "matters" WHERE "id" = (($id - 0) /
> 6)
>
> }
>
> source matter_delta_1 : matter_core_1
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre =
> sql_query = SELECT "matters"."id" * 6 + 0 AS "id" , "matters"."name"
> AS "matter_name", "users"."first_name" AS "contact_first_name",
> "users"."last_name" AS "contact_last_name", "matters"."id" AS
> "sphinx_internal_id", 3077742169 AS "class_crc", '3077742169' AS
> "subclass_crcs", 0 AS "sphinx_deleted", "matters"."id" AS "id",
> "matters"."company_id" AS "company_id" FROM "matters" LEFT OUTER
> JOIN "users" ON "users".id = "matters".employee_user_id WHERE
> "matters"."id" >= $start AND "matters"."id" <= $end AND
> "matters"."delta" = TRUE GROUP BY "matters"."id", "matters"."name",
> "users"."first_name", "users"."last_name", "matters"."id",
> "matters"."id", "matters"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "matters" WHERE "matters"."delta" = TRUE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "matters" WHERE "id" = (($id - 0) /
> 6)
>
> }
>
> index matter_delta : matter_core
> {
> source = matter_delta_0
> source = matter_delta_1
> path = /home/rahul/application/demo/db/sphinx/development/
> matter_delta
>
> }
>
> index matter
> {
> type = distributed
> local = matter_delta
> local = matter_core
>
> }
>
> source account_core_0
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta"
> = TRUE
> sql_query = SELECT "accounts"."id" * 6 + 1 AS "id" ,
> "accounts"."name" AS "account_name", array_to_string(array_accum
> (COALESCE("contacts"."first_name", '0')), ' ') AS
> "contact_first_name", array_to_string(array_accum(COALESCE
> ("contacts"."last_name", '0')), ' ') AS "contact_last_name",
> array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
> AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
> 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
> "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
> "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
> ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
> "contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
> WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
> "accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY
> "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
> "accounts"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 1) /
> 6)
>
> }
>
> source account_core_1
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre = UPDATE "accounts" SET "delta" = FALSE WHERE "delta"
> = TRUE
> sql_query = SELECT "accounts"."id" * 6 + 1 AS "id" ,
> "accounts"."name" AS "account_name", array_to_string(array_accum
> (COALESCE("contacts"."first_name", '0')), ' ') AS
> "contact_first_name", array_to_string(array_accum(COALESCE
> ("contacts"."last_name", '0')), ' ') AS "contact_last_name",
> array_to_string(array_accum(COALESCE("contacts"."email", '0')), ' ')
> AS "contact_email", "accounts"."id" AS "sphinx_internal_id",
> 2995482424 AS "class_crc", '2995482424' AS "subclass_crcs", 0 AS
> "sphinx_deleted", "accounts"."id" AS "id", "accounts"."company_id" AS
> "company_id" FROM "accounts" LEFT OUTER JOIN "account_contacts" ON
> ("accounts"."id" = "account_contacts"."account_id") LEFT OUTER JOIN
> "contacts" ON ("contacts"."id" = "account_contacts"."contact_id")
> WHERE "accounts"."id" >= $start AND "accounts"."id" <= $end AND
> "accounts"."delta" = FALSE AND accounts.deleted_at is null GROUP BY
> "accounts"."id", "accounts"."name", "accounts"."id", "accounts"."id",
> "accounts"."company_id"
> sql_query_range = SELECT COALESCE(MIN("id"), 1::bigint), COALESCE(MAX
> ("id"), 1::bigint) FROM "accounts" WHERE "accounts"."delta" = FALSE
> sql_attr_uint = sphinx_internal_id
> sql_attr_uint = class_crc
> sql_attr_uint = sphinx_deleted
> sql_attr_uint = id
> sql_attr_uint = company_id
> sql_attr_multi = uint subclass_crcs from field
> sql_query_info = SELECT * FROM "accounts" WHERE "id" = (($id - 1) /
> 6)
>
> }
>
> index account_core
> {
> source = account_core_0
> source = account_core_1
> path = /home/rahul/application/demo/db/sphinx/development/
> account_core
> morphology = none
> min_word_len = 2
> charset_type = utf-8
> min_prefix_len = 2
> prefix_fields = account_name, contact_first_name, contact_last_name,
> contact_email, account_name, contact_first_name, contact_last_name,
> contact_email
> enable_star = 1
>
> }
>
> source account_delta_0 : account_core_0
> {
> type = pgsql
> sql_host = 127.0.0.1
> sql_user = *****
> sql_pass = *****
> sql_db = demo_dev_29122009
> sql_query_pre =
> sql_query = SELECT "accounts"."id" * 6 + 1 AS "id" ,
> "accounts"."name" AS "account_name", array_to_string(array_accum ...
>
> read more »
--
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en.
