|
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:
|
69
|
318
|
1,022
|
|
Post:
|
111
|
660
|
2,163
|
|
|
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:
Showing columns in result
Published (2009-11-26 20:11:00)
You are aware sphinx is a 'index', not a datastore. http://sphinxsearch.com/faq.html#row-storage To get original data you need to look it up in your own database.
user's latest post:
Suggestions for string attributes
Published (2009-11-19 16:34:00)
> Any idea when this will be implemented in trunk? > I'm not sure. BTW I would *not* trust this patch, in a production environment. I quickly hacked it together to get it to work.
user's latest post:
English and Greek characters
Published (2009-11-19 09:26:00)
Under better investigation my db is latin1 swedish ci and i want to ask if i can use in the config the latin1 swedish ci to search greek characters?
user's latest post:
How do i make two indexes?
Published (2009-11-24 15:09:00)
Thanks, i figured it had to be something like that but didnt want to presume too much!! As for making Sphinx work with ASP, do you know if this is theoretically possible, and if so any resources that i could take a peek at to help me along the way??
user's latest post:
prefix indexing problem
Published (2009-11-25 17:01:00)
> I use xmlpipe with static xml file and I don't use mysql. If I change data source to mysql then prefix search works normally.
user's latest post:
Index fail: Lost connection to...
Published (2009-11-26 15:38:00)
Hi Zam, First, ensure that the directory for searchd.pid exists (and is writeable): #cd /home/adam/sphinx/var/log/ #ls -al searchd.pid If it is there, stop sphinx and see if it is still there (should be gone). If it is still there, delete it. If the directory doesn't exist, then mkdir var and possibly log. Then reindex catalogue using rotate: #/scripts/indexer catalogue --rotate Then restart sphinx: (wherever searchd is)...
user's latest post:
Мультииндекс.
Published (2009-11-18 12:06:00)
> А вот насчет 15 индексов? Или придется эксперименты производить? Лучше эксперименты. Но теоретически - дисковых операций больше, а они как правило "дорогие" - значит скорее всего определенное замедление будет, вот только думаю вы его...
user's latest post:
Мультииндекс.
Published (2009-11-18 15:18:00)
> Лучше эксперименты. Но теоретически - дисковых операций больше, а они как правило > "дорогие" - значит скорее всего определенное замедление будет, вот только думаю вы его > даже не заметите. Да я-то его точно не замечу. :-) И 100...
user's latest post:
Passing multiple search parameters
Published (2009-11-26 07:09:00)
Barry, please see the sample code for this issue: Index for invitation model-- indexes :activity_id indexes urpose_id indexes escription...
|
|
|
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 2 months ago (2009-09-24 14:13:00)
by adammac
> Here I am using the same filed(NAME) for sql_attr_str2ordinal. Is it correct or Should I
> write as shown below?
>
> sql_query = SELECT ID, NAME, NAME AS NAME_ORD, ADDRESS FROM EMPDETAILS
> sql_attr_str2ordinal = NAME_ORD
This is the proper way.
select id,name,name as name_ord,etc from table
sql_attr_str2ordinal = name_ord
Started 4 months ago (2009-07-28 19:31:00)
by Arantor
> Basically I want to know if there is a way to have a string attribute so I can filter by
> category. It is not possible for me to convert the database system to use integers for
> categories.
You can word search on it. Using the extended2 mode you can do column independent
searches.
"@category word" for example.
There is a sql_attr_string being developed, it's in the SVN ...
Started 2 days, 5 hours ago (2009-11-26 15:38:00)
by adammac
Hi Zam,
First, ensure that the directory for searchd.pid exists (and is writeable):
#cd /home/adam/ sphinx/var/log/
#ls -al searchd.pid
If it is there, stop sphinx and see if it is still there (should be gone). If it is still
there, delete it.
If the directory doesn't exist, then mkdir var and possibly log.
Then reindex catalogue using rotate:
#/scripts/indexer catalogue --...
Started 2 years, 1 month ago (2007-10-16 22:09:00)
by shodan
> I searched PHP API and it seems to me that this method (UpdateAttributes) does not
> support update for MVA attributes (?).
It does not support MVAs yet, indeed. There are plans to implement that.
Started 5 months, 3 weeks ago (2009-06-06 12:07:00)
by red
Sorry, I should have clarified that after restarting the high loads are permanent. I
understand after a restart the first few minutes server load goes up, but I'm talking
about the loads staying much higher in definitely.
Started 2 days ago (2009-11-26 20:11:00)
by barryhunter
You are aware sphinx is a 'index', not a datastore.
http://sphinxsearch.com/faq.html#row-storage
To get original data you need to look it up in your own database.
|
|
Hot threads for last week on Sphinx - Free open-source SQL full-text search engine:
Started 5 days, 4 hours ago (2009-11-23 16:35:00)
by barryhunter
> I currently have sphinx being used to index a mediawiki installation. However i now need
> to expand its functionality so that it can index our corporate intranet. Im under the
> impression that this is possible but cant find anything on how to actually do it. What id
> like to know is whether its possible to have multiple indexes so each can be searched
> independantly of ...
Started 3 days, 5 hours ago (2009-11-25 14:46:00)
by adammac
Hi Kovacs,
Try changing:
min_prefix_len = 1
to:
min_prefix_len = 0
in sphinx.conf, then reindex with --rotate
#/usr/local/bin/indexer <indexname> --rotate
Started 2 days, 5 hours ago (2009-11-26 15:38:00)
by adammac
Hi Zam,
First, ensure that the directory for searchd.pid exists (and is writeable):
#cd /home/adam/sphinx/var/log/
#ls -al searchd.pid
If it is there, stop sphinx and see if it is still there (should be gone). If it is still
there, delete it.
If the directory doesn't exist, then mkdir var and possibly log.
Then reindex catalogue using rotate:
#/scripts/indexer catalogue --...
Started 6 days, 9 hours ago (2009-11-22 10:54:00)
by Arantor
> I wanted to ask those Sphinx users who have implemented multiple instances of searchd
> about the load on the server and whether it is worth it.
> I have one instance running that searches a database of 80000 records based on user
> input. I need the second instance in order to set up Sphinx to search another table that
> will hold past user queries.
Why not one instance ...
Started 3 days, 2 hours ago (2009-11-25 18:23:00)
by barryhunter
Please supply an example query. And maybe your 'source's, just the sql_query and
attributes would probably be enough.
At the moment I dont beleive its clear what you are trying to do.
Started 3 days, 7 hours ago (2009-11-25 13:07:00)
by barryhunter
> tried to kill 12745,
All you doing is trying to kill the grep command itself, - which will have already
terminated ;)
What actully happens when try to start the daemon? Did you check the searchd log?
Sounds like an unclean shutdown, perhaps just try removing the .spl files, doing a
reindex and starting searchd.
Failing that just delete all the index files (/var/sphinx/*.sp?)...
Started 1 week ago (2009-11-20 21:30:00)
by ramana
--merge-dst-range only removes the old key words, but it deosn't physically remove it
from the index according to the documentation. I had also didn't notice any decrease of
the index size..
> Hi,
>
> I am wondering about one thing.
> If I merge two indexes (~100GB in size) and delta (~1GB in size) and use
> --merge-dst-range which have such values that all documents from...
Started 1 week, 1 day ago (2009-11-20 10:59:00)
by barryhunter
> Is it best practice to remove punctuation marks (.,'" etc.) or not from the text before
> indexing.
No need usually. Any chars not in 'charset_table' will not be considered parts of words -
ie as seperators.
Pretty sure most people (and I know I do) just throw the raw text as sphinx - and it
handles 'cleaning' and tokenising - in fact even an option top strip html.
> ...
Started 5 days, 10 hours ago (2009-11-23 10:44:00)
by barryhunter
The API has a UpdateAttributes function
http://sphinxsearch.com/docs/current.html#api-func -updateatttributes
You can have your application update Sphinx when a new rating comes in.
Started 3 days, 1 hour ago (2009-11-25 19:19:00)
by barryhunter
I doubt such a 'magic' number exists. It will be different for each query and dataset.
One thing I once tried with reasonable success (didnt take it very far) was to work down
the list of results keeping a running average of the difference in relevance score, and
then notice when there was big jump (say over 1 std deviation), and then stop and discard
the following results.
As say, this...
|
|
Size: 620 bytes
