Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: @group and multiple indexes (main + delta)
Started 1 month, 1 week ago by kupokomapa
Hello, I am facing the following problem. I am using "live" indexes by having my main index generated once a day and then every 20 minutes or so I generate a delta index of the items changed since the last full main index generation. Everything woks as expected when searching the indexes without @group cause. But when I want to find the items count grouped by a certain attribute, I get ...
Site: Sphinx - Free open-source SQL full-text search engine  Sphinx - Free open-source SQL full-text search engine - site profile
Forum: Common forum  Common forum - forum profile
Total authors: 1 author
Total thread posts: 6 posts
Thread activity: no new posts during last week
Domain info for: sphinxsearch.com

Other posts in this thread:

kupokomapa replied 1 month, 1 week ago
Also just to mention that I did increase (to 10,000) the max_matches both in the sphinx.conf and in (my case) the PHP api call to SetLimits(). The number of results very well fit in 1000 but I wanted to make sure that's not the problem before posting here.
Size: 310 bytes
Customize:  Customize "<b>Reply 1</b>: @group and multiple indexes (main + delta) :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

kupokomapa replied 1 month, 1 week ago
Is this my possible solution http://www.sphinxsearch.com/docs/current.html#conf -sql-query-killlist ? > Also just to mention that I did increase (to 10,000) the max_matches both in the > sphinx.conf and in (my case) the PHP api call to SetLimits(). The number of results very > well fit in 1000 but I wanted to make sure that's not the problem before posting here. >
Size: 716 bytes
Customize:  Customize "<b>Reply 2</b>: @group and multiple indexes (main + delta) :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

kupokomapa replied 1 month, 1 week ago
Yes, that's my solution. I hope this self-talk will be useful to somebody else :) > Is this my possible solution > http://www.sphinxsearch.com/docs/current.html#conf -sql-query-killlist ? > > > Also just to mention that I did increase (to 10,000) the max_matches both in the > sphinx.conf and in (my case) the PHP api call to SetLimits(). The number of results very > ...
Size: 982 bytes
Customize:  Customize "<b>Reply 3</b>: @group and multiple indexes (main + delta) :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

kupokomapa replied 1 month, 1 week ago
Ah, I was talking too early. upon reading the docs I thought that would solve the problem but I am still getting wrong counts when using @group. Also when the delta index is empty and the main contains all the data, @group gives the correct counts but as soon as I start adding items to the delta index, the @group count numbers starts to increase which makes me think that it counts the ...
Size: 1,611 bytes
Customize:  Customize "<b>Reply 4</b>: @group and multiple indexes (main + delta) :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

kupokomapa replied 1 month, 1 week ago
I wish I could delete the thread :) I had an error in the query inside sql_query_killlist but "indexer" did not raise any warning or error (is this expexted?) but I decided to verify it anyway and fixed the error and the counts are OK, now. I first learned about the solution from here http://www.sphinxsearch.com/forum/view.html?id=467 3, so thanks Barry! > Ah, I was talking too ...
Size: 1,381 bytes
Customize:  Customize "<b>Reply 5</b>: @group and multiple indexes (main + delta) :: Common forum :: Sphinx - Free open-source SQL full-text search eng..."

 

Top contributing authors

Name
Posts
kupokomapa
6
user's latest post:
@group and multiple indexes...
Published (2009-11-11 20:40:00)
I wish I could delete the thread :) I had an error in the query inside sql_query_killlist but &quot;indexer&quot; did not raise any warning or error (is this expexted?) but I decided to verify it anyway and fixed the error and the counts are OK, now. I first learned about the solution from here http://www.sphinxsearch.com/forum/view.html?id=4673, so thanks Barry! > Ah, I was talking too early. upon reading the docs I thought that...

Related threads on "Sphinx - Free open-source SQL full-text search engine":

Main+Delta => Merge or Search Multiple Indexes?  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Main+Delta => Merge or Search Multiple Indexes?
Main+Delta => Merge or Search Multiple Indexes?
Main+Delta rotation is not ading new entries to main  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Main+Delta rotation is not ading new entries to main
Main+Delta rotation is not ading new entries to main
Main index size in main + delta scheme  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Main index size in main + delta scheme
Main index size in main + delta scheme
ID conflicts and Single vs Multiple indexes - Best practice?  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile ID conflicts and Single vs Multiple indexes - Best practice?
ID conflicts and Single vs Multiple indexes - Best practice?
How is multiple indexes working?  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile How is multiple indexes working?
How is multiple indexes working?
0.9.9 / SPH_MATCH_EXTENDED + multiple INDEXES  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile 0.9.9 / SPH_MATCH_EXTENDED + multiple INDEXES
0.9.9 / SPH_MATCH_EXTENDED + multiple INDEXES
Multiple indexes vs. one big index  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Multiple indexes vs. one big index
Multiple indexes vs. one big index
Multiple Indexes  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Multiple Indexes
Multiple Indexes
Combining fields across multiple indexes  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Combining fields across multiple indexes
Combining fields across multiple indexes
Search on multiple indexes with different attributes  Sphinx - Free open-source SQL full-text search engine - site profile Common forum - forum profile Search on multiple indexes with different attributes
Search on multiple indexes with different attributes

Related threads on other sites:

Multiple Indexes vs Multi-Column Indexes?...  Twitter / gatekiller - site profile gatekiller - forum profile Multiple Indexes vs Multi-Column Indexes? http://tinyurl.com/4pe6g4 08:41 AM October 07, 2008 from twhirl
Multiple Indexes vs Multi-Column Indexes? http://tinyurl.com/4pe6g4 08:41 AM October 07, 2008 from twhirl
Building multiple indexes on a table that has 19799750...  Twitter / dwayne - site profile dwayne - forum profile Building multiple indexes on a table that has 19799750 rows on a single CPU VM (running multiple DBs) is the opposite of fun...nap time 10:44 AM Oct 26th from DestroyTwitter
Building multiple indexes on a table that has 19799750 rows on a single CPU VM (running multiple DBs) is the opposite of fun...nap time 10:44 AM Oct 26th from DestroyTwitter
Sorting arrays by multiple indexes?  CodingForums.com- Web coding and development forums. Get help on JavaScript, PHP, CSS, XML, mySQL, ASP, and more! - site profile PHP - forum profile Sorting arrays by multiple indexes?
Sorting arrays by multiple indexes?
Mysql and indices... anyone out there who can give me an...  Twitter / namtrok - site profile namtrok - forum profile Mysql and indices... anyone out there who can give me an introduction on these? Do multiple indexes speed up SELECT statements? 12:25 PM Jun 19th from CoTweet
Mysql and indices... anyone out there who can give me an introduction on these? Do multiple indexes speed up SELECT statements? 12:25 PM Jun 19th from CoTweet
Compass search multiple indexes  OpenSymphony Support Forums - site profile OSCache CVS 4,011 374 / 377 Aug 4, 2006 12:25 PMby: plightbo@dev.ja... - forum profile Compass search multiple indexes
Compass search multiple indexes
Multiple Indexes  OpenSymphony Support Forums - site profile OSCache CVS 4,011 374 / 377 Aug 4, 2006 12:25 PMby: plightbo@dev.ja... - forum profile Multiple Indexes
Multiple Indexes
Multiple indexes in microsoft.public.word.docmanagement  Discussions in microsoft.public.word.docmanagement - site profile microsoft.public.word.docmanagement - forum profile Multiple indexes in microsoft.public.word.docmanagement
Multiple indexes in microsoft.public.word.docmanagement
How do I create multiple indexes in Word 2007 in...  Discussions in microsoft.public.word.docmanagement - site profile microsoft.public.word.docmanagement - forum profile How do I create multiple indexes in Word 2007 in microsoft.public.word.docmanagement
How do I create multiple indexes in Word 2007 in microsoft.public.word.docmanagement
Making multiple indexes with index package while using...  Programming Forum - site profile Tex - forum profile Making multiple indexes with index package while using natbib's
Making multiple indexes with index package while using natbib's
Multiple indexes containing the same field - ok? not?  PHPBuilder.com - site profile Database - forum profile Multiple indexes containing the same field - ok? not?
Multiple indexes containing the same field - ok? not?
Thread profile page for "@group and multiple indexes (main + delta)" on http://sphinxsearch.com. This report page is a snippet summary view from a single thread "@group and multiple indexes (main + delta)", located on the Message Board at http://sphinxsearch.com. This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity