search for: fulltext

I tried adding a FULLTEXT search index to a table of mine in MySQL, only to discover that the InnoDB table format doesn''t seem to support this feature. Switching to the MyISAM table type seemed to work, but I seem to have some recollection that ActiveRecord transactions aren''t fully atomic on MyISAM table...

Can anyone point me to the proper syntax to build a FULLTEXT MySQL index via migrations? I''m really liking these things, and don''t want to step back into the world of manual intervention.

If you used MySQL FULLTEXT indexes and just upgraded to Rails 1.1, watch out for this one. Rails 1.1 now defaults to Ruby as your schema format. So instead of development-structure.sql, Rake will use schema.rb. That''s portable and good stuff overall but there is a slight compatibility issue. Ruby schema doesn'&...

...using it through Acts as Ferret. Let''s say I have such a table, and all columns are indexed using the default behavior provided by acts_as_ferret: ARTICLES -id -year -body [1] A typical request will be "select id from articles where KEYWORDS % body". Will id be indexed for fulltext searching? clearly the fulltext index on id will never be used... id is only in the index so that it can be returned. [2] I anticipate that a response might be "because id is numeric and has a cardinality of 1/1, ferret is intelligent enough to store this efficiently in a b-tree and n...

i''m using a table, that uses fulltext search and therefore the table type MyISAM everything works fine in production mode, but tests fail with ActiveRecord::StatementInvalid: Mysql::Error: The used table type doesn''t support FULLTEXT indexes when looking in the test db it''s clear, that it''s using InnoDB, bu...

...arch into search engines recently, as we have some fairly specific requirements with what we're attempting to do with them. Long story short, after a few weeks of playing around with just about everything under the sun (or at least, everything off the shelf, sphinx, lucene, solr, mysql/postgres fulltext, etc, etc), we recently settled on Xapian because of it's specific design characteristics, and that it's really really easy to use and alter. The main reason we struggled to find something suitable was because of our large data requirements: In terms of raw data, we're looking at index...

...hare.R:11 /crunch/R/shoji-catalog.R:39 /crunch/R/show.R:88 /crunch/R/subvariables.R:76 /crunch/R/subvariables.R:95 /dplR/R/common.interval.R:8 /dplR/R/fill.internal.NA.R:47 /dplR/R/helpers.R:3 /dplyr/R/dataframe.R:49 /dplyr/R/glimpse.R:38 /dplyr/R/id.r:36 /dplyr/R/tbl-cube.r:98 /dplyr/R/utils.r:15 /fulltext/R/chunks.R:352 /fulltext/R/chunks.R:356 /ggvis/R/transform.R:56 /httr/R/oauth-token-utils.R:23 /igraph/R/lazyeval.R:219 /jsonlite/R/asJSON.data.frame.R:74 /jsonlite/R/deparse_vector.R:26 /jsonlite/R/simplifyDataFrame.R:14 /jsonlite/R/unescape_unicode.R:10 /knitr/R/utils.R:207 /knitrBootstrap/R/knit...

...for a long time - dovecot seems to not update the index always "incrementally". Yesterday I've finally made a test by telneting to imap port and issuing a search request. Dovecot started to reindex the mailbox. Full reindexing has taken around 15-20 minutes. After reindexing the fulltext searches were fast, just as they should be. And they were fast yesterday even after some new emails arrived. But I've tried to do a new search today and Dovecot started to reindex the whole maildir again! Why is it reindexing the whole maildir again? Could it be related to my anti-spam scr...

The current full-text search will return the AND collection results,for example,if we use Article.search("aa bb"),then the articles that include "aa" and "bb" in the fields will be returned,how to return the articles that include "aa" OR "bb" effectly? A stumb method is to setup two queries respectly and collect them together with remove the

I''ve heard that using LIKE is very slow, but I see it being used a lot in examples, blogs etc. Is it really that bad? Since Rails doesn''t directly support Fulltext search, this is the easiest way to get searching done, right? Or are there any other easier ways? I''m using acts_as_indexed right now, but it still doesn''t do what LIKE does. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed...

...imap server and execute by hand 1 login user password select foldername search body "someword" it works fine, and at blazing speed except first run (indexing). i already indexed everything by doveadm index offline to prevent server overload if multiple users (after i tell them) will try fulltext search. All great BUT it doesn't work in thunderbird. Just gives zero results. i used tcpdump to check how thunderbird executes it and it uses search undeleted body "someword" tried manually and it DOES NOT WORK. always give empty results. even search all body "someword&quot...

Hi I have a question about tunning dovecot-2.2.36.x Mail was stared in storage via nfs in MAILDIR via /home/us/username at domain.ltd/MAILDIR/ I use additionally local dovecot_indexes via SSD disk (/var/dovecot_indexes%h) A few clients have 25K and more e-mail I thinking about use solr like: ?fts = solr ?fts_solr = debug url=http://IP:8983/solr/ (solr in external machine) Does it make sense ?

...983/solr/ (solr in external machine) >> >> Does it make sense ? use dovecot_indexes and fts ? >> What is the difference in performance? >> > Hi! > > Dovecot indexes are not actually related to FTS that much. Using FTS > usually makes sense since it speeds up IMAP fulltext searches. > > Aki > Hi So you're advised to use a solr or something else?

Hi list, I wonder if it is possible to specify my own doc_id? I want to have the same doc_id as my fulltexts tables primary keys. Cheers, Henrik

Hello I just jumped into xapian, so my question could be quite basic, but I haven't found anything really useful in the list. I'm using xapian to make a fulltext search on our local servers, including some pdf's and doc files, but also our own filetypes. Anyway, I managed to write an indexer in php and it works fine. My problem is however, that I have to reindex everything when just one document is changed. Also deleted files aren't kicked out of th...

...isappears in the hash when you submit a form :-), I had to use Webrick as Lighty complained about an unknown variable CWD. This looks to have been added to make the fcgi path absolute rather than relative, but I get an error because it''s not set. I can''t figure out how to do a fulltext search in Trac to see if it''s been reported. A simple Browser find on the faults lists didn''t show up ''CWD'' in the subject lines. So any help on any of the following would be appreciated: 1) Is this a known bug or should I report it? (rails fault list junki...

Hi, Both vapply() and sapply() support the 'USE.NAMES' argument. According to the man page: USE.NAMES: logical; if ?TRUE? and if ?X? is character, use ?X? as ?names? for the result unless it had names already. But if 'X' has names already and 'USE.NAMES' is FALSE, it's not clear what will happen to the names. Are they going to propagate to the result

...buttons]) t.AddCellInfo(row+3, col-1, align='right') *************** *** 250,259 **** row, col = t.GetCurrentRowIndex(), t.GetCurrentCellIndex() t.AddCellInfo(row, col-1, align='right') t.AddRow([Bold('Message Excerpt:'), ! TextArea('fulltext-%d' % id, text, rows=10, cols=80)]) t.AddCellInfo(row+1, col-1, align='right') form.AddItem(t) form.AddItem('<p>') --- 252,264 ---- row, col = t.GetCurrentRowIndex(), t.GetCurrentCellIndex() t.AddCellInfo(row, col-1, align='right...

Using SQL or activerecord I am not sure how to search all fields for a specific value ? I know how to do this by just writing ruby code. To do it in SQL or an activerecord find w/condition, I don''t know how. I actually am supposed to combine an find w/ condition and a search all fields for a value and AND those together. I think perhaps it can''t be done with a single find ?

Hi, I''m trying to implement a live search that supports searching for multiple words. So for example, if I type "ruby rails" in the search field, I would return results that have either the word "ruby" in them or the word "rails" in them. However, this is just a background as to what the following code is trying to do and might not even be needed to fix