|
More site info...
Sphinx - Free open-source SQL full-text search... - sphinxsearch.com | Site profile
|
|
Site profile page for http://sphinxsearch.com.
This report page has aggregated and summarized the online discussions from the Message Board located at http://sphinxsearch.com.
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://sphinxsearch.com is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Sphinx - Free open-source SQL full-text search engine:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
98
|
333
|
1,128
|
|
Post:
|
228
|
645
|
2,615
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Sphinx - Free open-source SQL full-text search engine (http://sphinxsearch.com)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Sphinx - Free open-source SQL full-text search engine posting activity graph:
|
|
http://sphinxsearch.com Alexa graph:
|
Top authors on Sphinx - Free open-source SQL full-text search engine during last week:
user's latest post:
Phrase Weighting
Published (2009-11-10 20:56:00)
Maybe SetRankingMode(SPH_RANK_WORDCOUNT) ?
user's latest post:
question about sql_attr_multi...
Published (2009-11-06 19:17:00)
Hi joepilon, To be honest, no, I haven't really considered nor researched any other product (other than the KickFire appliance). About 2 years ago, I made the switch from Sybase to mySQL. The move was more b/c I wanted to abandon the remaining windows servers (actually, they were towers at the time) and move to all linux rack servers (debian). I have been following the MariaDB, but, I have been a little slow to test this db solution. I...
user's latest post:
обновление...
Published (2009-11-10 22:46:00)
> Сделать атрибут "статус" и пометить в основном индексе запись как удаленную. + > Дополнительный индекс update в котором будут индексироваться эти обновленные данные. До > тех пор пока не будет переиндексирован основной индекс. можно...
user's latest post:
Selecting from multiple tables /...
Published (2009-11-09 02:30:00)
> Seems to be this would be an ideal use for the mysql Partition engine > > http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html > Hmm, very interesting! I'm reading about it now and like, very much, what I see :-) Thanks for the pointer!
user's latest post:
SetLimits over multiple indexes
Published (2009-11-09 14:53:00)
> Sounds like you should aim to have it all in one query - then SetLimits applies to the > one query, and then sphinx handles merging of results - in such a way that paging will > work. This won't work with different fieldweights per index. > Maybe SetIndexWeights, can be used. Or you can somehow fudge the fields, so that > setFieldWeights can be used, for example my having different feilds in each index. Not > used it...
user's latest post:
SPH_MATCH_EXTENDED issue
Published (2009-11-10 14:39:00)
Hi All I am using $cl->SetMatchMode( SPH_MATCH_PHRASE | SPH_MATCH_BOOLEAN ); for exact phrase marching and OR-ing with boolean search which is working perfectly fine $cl->SetMatchMode( SPH_MATCH_EXTENDED ); i want to use (any field search as well as the Boolean as well as exact match phrase) for that when i use $cl->SetMatchMode(SPH_MATCH_EXTENDED); it doesnt shows me any data in...
user's latest post:
Search Error
Published (2009-11-05 11:23:00)
hi , on analysis i found out the error.. when i indexed 50,000 ducuments , on searching the authorname 'Isabel Wolff' , the database gives the results.. and the productid's are 1.680 2.1000 3.1001 4.1002 5.1184 6.1185 7.24875 on sphinx search with the same authorname its giving the result.. 1.680 2.1000 3.1001 4.1002 5.1184 6.1185 7.2487 and the difference is the last 7 th document it is giving only the four digit id.. i cant...
user's latest post:
Getting random results
Published (2009-11-03 18:54:00)
How do I update ? I've glanced the documentation but it only teach you how to recompile the new code, isn't there a way to update it correctly ? - I mean, without installing the RC-2 and removing the other one ?
user's latest post:
Phrase Ranking
Published (2009-11-09 14:49:00)
As explained in document Phrase rank is based on a length of longest common subsequence (LCS) of search words between document body and query phrase. So if there's a perfect phrase match in some document then its phrase rank would be the highest possible, and equal to query words count. . . . In SPH_MATCH_EXTENDED mode, final weight is a sum of weighted phrase ranks and BM25 weight, multiplied by 1000 and rounded to integer Can any one...
user's latest post:
new to sphinx
Published (2009-11-05 12:40:00)
> For the moment have a look at recent posts mentioning 'GROUP_CONCAT' or 'MVA' * > > That should find some interesting posts. I do plan to add a page to the wiki documenting > it better. > > > * (Multi-Value-Attributes) I know about GROUP_CONCAT method, but I can't figure out how to make single query search using MVA. MVA containing only id of the tags, so I should create some additional queries...
|
|
|
Top 10 active forums on Sphinx - Free open-source SQL full-text search engine during last week:
|
|
Top 10 forums on Sphinx - Free open-source SQL full-text search engine:
|
|
|
|
Latest active threads on Sphinx - Free open-source SQL full-text search engine:
Started 1 month, 3 weeks ago (2009-09-17 14:35:00)
by Arantor
> Hi,
>
> Can we use stored procedure for sql_query in sphinx.conf instead of MySQL query?
If you can query the results as if it were a regular query, yes. sql_query just sends the
query as-is to MySQL and expects a resultset. If that will be returned without use of any
variables (since sql_query_pre doesn't work for this AFAIK) it'll work.
If in doubt, try it.
Started 12 hours, 50 minutes ago (2009-11-11 14:29:00)
by wmark
> Hey - I'm attempting to compile mysqlse, but the autorun script doesn't pick up sphinx.
> I'm using 5.1.40 and 9.9 rc2. Looking at old posts, I'm guessing this is do to an update
> on mysql's side. I have a copy of 5.1.37's source that I did my original testing on, and
> I'll post it if anyone here needs it.
MySQL's cmake scripts have been redesigned and now it is easier to ...
Started 20 hours, 55 minutes ago (2009-11-11 06:24:00)
by Alysum
Correction: search command seems to work and it's only the sphinxapi.php that is throwing
the error from GetLastError() after executing Query() from the API.
Started 14 hours, 27 minutes ago (2009-11-11 12:52:00)
by wmark
> I'm trying to do a simple query to get the count of matches in the index:
>
> select count(*) from TP_PRDCT_INDEX
> where query="it;maxmatches=100000;"
>
> However, I keep getting the following error:
>
> There was a problem processing the query on the foreign data source. Data source error:
> searchd error:
> per-query max_matches=100000 out of bounds ...
Started 15 hours, 34 minutes ago (2009-11-11 11:45:00)
by barryhunter
Breaking the output into two sections might help explain things....
~~~~~~~~~~~~~~
> indexing index 'wiki_main'...
> collected 20082 docs, 22.4 MB
> sorted 3.7 Mhits, 100.0% done
> total 20082 docs, 22423950 bytes
> total 6.920 sec, 3240454.72 bytes/sec, 2902.02 docs/sec
~~~~~~~~~~~~~~
> indexing index 'wiki_incremental'...
> collected 0 docs, 0.0 MB
> total 0 ...
Started 2 days, 17 hours ago (2009-11-09 10:09:00)
by barryhunter
The most basic way to 'solve' this, would be to add ' to ignore_chars, so they stripped
before indexing. And use stemming to make with/without the 's' work as the same.
Started 1 day, 9 hours ago (2009-11-10 18:10:00)
by barryhunter
>
> $cl->SetMatchMode( SPH_MATCH_PHRASE | SPH_MATCH_BOOLEAN );
I seriouslly doubt that is doing what you expect. I think it only accepts ONE mode. (I
dont know which one it will actully be from the two)
> it doesnt shows me any data in case when i put @field EN050809323V it doesn't shows me
> any result though this value is present in the feild.
need more details ...
Started 1 day, 9 hours ago (2009-11-10 17:48:00)
by barryhunter
have you checked the speed of the raw SQL queries?
Perhaps the second time (after the recompilation) is simply faster because it hits the
mysql query cache.
- also check your mysql slow query log. Maybe the slow query suffered a long lock time.
Started 1 day, 1 hour ago (2009-11-11 02:09:00)
by cbiggins
Ok, so maybe it is not encoding and is, in fact, still in binary form?
How can I tell if the query has made it to the daemon ok?
|
|
Hot threads for last week on Sphinx - Free open-source SQL full-text search engine:
Started 1 week, 1 day ago (2009-11-03 14:53:00)
by adammac
Hi Edward,
Not sure if this is your issue, but similar to what I had before:
Check Title,AuthorName,Description and make sure that the data is not less than
min_word_len in sphinx.conf. I had mine set at min of 2, and when I had data that
contained only 1 characters, results were *lost*.
Deleting all data that contained a str len of less than 2 fixed it for me. Alternatively,
I could...
Started 1 week ago (2009-11-04 11:45:00)
by barryhunter
If the document_id's from the two tables overlap, then there really is nothing for it
other than run two seperate queries. (merging in your application as required)
(alternativly you can manipulate the data at indexing time, so the ids are completely
distinct)
Started 2 days, 15 hours ago (2009-11-09 11:35:00)
by Frits1980
After reading all other threads about SetLimits again I thought it might help to mention
that I use addquery.
The code:
$cl = new SphinxClient();
$cl->SetArrayResult(true);
$cl->SetMatchMode(SPH_MATCH_EXTENDED2);
$cl->SetRankingMode(SPH_RANK_BM25);
$cl->SetSortMode(SPH_SORT_RELEVANCE);
$cl->SetLimits(0, 2);
foreach ($indexName as...
Started 1 week ago (2009-11-04 15:04:00)
by barryhunter
From the documentation:
> Field-start and field-end keyword modifiers, introduced in version 0.9.9- rc2, will make
> the keyword match only if it occurred at the very start or the very end of a fulltext
> field, respectively.
Upgrade!
Started 2 weeks, 5 days ago (2009-10-23 23:44:00)
by barryhunter
Is 'date feild' defined as an interger (or timestamp) attribute?
Also are you putting a number into it (eg from your sql_query - unix_timestamp() is a
useful mysql function here) ?
Started 2 weeks ago (2009-10-28 05:25:00)
by SabreCEO
> Hi, I would like to know how to get random results ?
> Does
> CONF : sql_attr_uint = Rand();
> PHP : $cl->SetSortMode ( SPH_SORT_ATTR_DESC, "Rand()" );
> works ? I don't think so...
>
> I just want to get random results from my index, no tricky or fishy things.
>
> Thanks !
Go to the Documentation page and just search for "random" in your Internet ...
Started 1 week, 1 day ago (2009-11-03 09:26:00)
by joepilon
Anyone help me out with these questions?
Started 1 week, 1 day ago (2009-11-03 14:32:00)
by barryhunter
I imagine you are not defining SP_PORT as an int? Possibly a string. Ie dont do this:
define('SP_PORT','3312');
or you could jsut do $cl->SetServer ( SP_SRV, intval(SP_PORT) );
While its questionable to use assert in this way, personally think its great for
development debugging. And they are easily disabled - and sphinx will probably work just
fine. Could make it 'softer' using ...
Started 2 days, 17 hours ago (2009-11-09 10:09:00)
by barryhunter
The most basic way to 'solve' this, would be to add ' to ignore_chars, so they stripped
before indexing. And use stemming to make with/without the 's' work as the same.
Started 1 week ago (2009-11-04 11:51:00)
by Krot
> Есть 2 таблицы: first и second. В таблице first для id=83 в поле есть слово "test".
> Аналогично в таблице second есть такая же запись с таким же id. Как при использовании API
> (Java, хотя это не важно) получить сведения о нахождении слова в ОБЕИХ таблицах?
>
> Сейчас получаю только только один результат:
> id=83, weight=100
>
> Этот результат мне ничего не ...
|
|
Size: 570 bytes
