Hi Pat I tried as per mine but I not found any solution. Do you have any link for such index or documentation about specifying multiple index?
Regards, Rahul P. Chaudhari On Jan 6, 10:18 am, rahul100885 <[email protected]> wrote: > Hi Pat > > Second file generated when I used version 1.3.14 and I sent you only > some part of file (Means contact, account and opportunity related > part) > > As you asked, following is an output - > > >> ThinkingSphinx.context.indexed_models > > => ["Account", "Contact", "Matter", "Opportunity", > "Physical::Crm::Campaign::Campaign"] > > > > On Jan 6, 4:20 am, Pat Allan <[email protected]> wrote: > > > Hmm, there's a lot of models missing, comparing the two files. And > > everything that's there is duplicated... > > > In script/console, what's the output of the following: > > ThinkingSphinx.context.indexed_models > > > -- > > Pat > > > On 06/01/2010, at 1:11 AM, rahul100885 wrote: > > > > 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", > > ... > > 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.
