Stack Overflow
Stack Overflow

Questions tagged [full-text-indexing]

indexing for full-text search

569 questions
0
votes
1 answer

Error 2013: lost connection to mariadb when adding full text index

I am using Maria DB 10.1.8 latest stable version available and i have dumped around 15 Million records into table more_bar_codes table. When i tried to alter table to add fulltext index onto one of its column, am getting error 2013: lost…
Ravish N V
  • 3
  • 2
0
votes
1 answer

Apache Jena full-text search (with external content)

I would like to configure something like this: RDF dataset of metadata about books; Books placed separately like XHTML files, paragraphs with unique IDs; Every book’s metadata includes something like dc:source link to the file (absolute? like a…
Honza Hejzl
  • 874
  • 8
  • 23
0
votes
1 answer

MySQL fulltext relevancy

I usually copy all text from appropriate columns into a single column and fulltext index that. Do you think that's the best way to do it, for relevancy, or should each column have its own index? For example, if I had a blog table I would copy the…
texelate
  • 2,460
  • 3
  • 24
  • 32
0
votes
1 answer

Creating a Full Text Index search

I've created a blog and I wish to search through certain tables in my MySQL databases and then return results for the user on a separate search page. I do not wish to use Google CSE. How would I go about creating this for my site. I found a post on…
user319815
0
votes
1 answer

Getting element in array that matched text index query

I have the following Schema set up on mongoose { _id: store: offers:[{ name: price: }] } I decided to indexed offers.name as follows uniSchema.index({'offers.name':'text'}); and now I'm trying to do searches on that…
Lucas C. Feijo
  • 1,002
  • 3
  • 13
  • 29
0
votes
1 answer

What query returns the list of columns that are text indexed in Oracle?

I need a SQL query that will return a list of all of the columns in an Oracle database which are full-text indexed, similar to the one for SQL Server given in answer How to find Full-text indexing on database in SQL Server 2008?. Either a sample…
lavinio
  • 23,931
  • 5
  • 55
  • 71
0
votes
1 answer

Create valid MySQL query with two LEFT JOINs, MATCH AGAINST and FULLTEXT indexes

I am trying to create a SELECT query that combines 3 tables via LEFT JOIN and then MATCH specific keywords AGAINST the resulting table. My testing so far reveals that the query is working fine and the output results are correct, however I have a…
user3132858
  • 609
  • 1
  • 11
  • 27
0
votes
1 answer

multiple input and multiple exclusion using text search index in mongodb

i have collection of recipes in my mongoDb.in which i have created text search index on ingredients. so that i can search recipes according to the ingredients which i have.result should have recipes atleast ingredients which i pass. this is sample…
Dhruvil Thaker
  • 1,950
  • 1
  • 15
  • 25
0
votes
1 answer

How to change MySQL's ft_min_word_len in Windows?

None of the solutions suggested to reduce MySQL's ft_min_word_len works for me on Windows 7 Pro. In Control Panel Services the path to MySQL56 server executable reads "C:\Program Files\MySQL\MySQL Server 5.6\bin\mysqld"…
EdNdee
  • 745
  • 1
  • 10
  • 18
0
votes
2 answers

How does MyISAM scale compared to Solr for Django searching?

Imagine you have a web application written in Django and Python 2.65, and MySQL 5.1 is your database of choice. Now, imagine you will need to scale your app to handle searching 100's of thousands of document and potentially 100's of thousands of…
mkelley33
  • 5,323
  • 10
  • 47
  • 71
0
votes
1 answer

How to make a full text search engine with php and mysql?

I have created a php search engine by using an open source code. I have created a database and a table with 5 columns: title, description, keywords, link, date The code I'm using is the php code below:
buggytuf
  • 69
  • 1
  • 10
0
votes
1 answer

SQL Server : searching strings for equivalent phrasing such as inch, inches,'' and "

As per the title I am looking for a method to search data on an equivalence basis Ie user searches for a value of 20" it will also search for 20 inch, 20 inches etc... I've looked at possibly using full text search and a thesaurus but would have to…
Andrew J S
  • 86
  • 6
0
votes
2 answers

Full text search returns empty result

Full text search seems that not working with my query, $dbh = new PDO('mysql:host=localhost;dbname=demo-search', $user, $pass, $options); // Searches using the LIKE operator. $statement = $dbh->prepare("SELECT id, title, content FROM article WHERE…
Run
  • 54,938
  • 169
  • 450
  • 748
0
votes
2 answers

FULLTEXT search(Mysql) is slow for the first time and then from second time onwards it gets much faster

I have a table with 4000 records(Which is much easier to handle through full text search). when the search query is executed for the first time it is much slower. It takes about 5 to 10 seconds. Then it gets faster. If the site remains inactive for…
Selvaraj M A
  • 3,096
  • 3
  • 30
  • 46
0
votes
1 answer

Why can't I MATCH() AGAINST() one of the columns in my FULLTEXT index?

Here's the CREATE TABLE: CREATE TABLE `EntityAddresses` ( `EntityAddress_ID` int(11) NOT NULL AUTO_INCREMENT, `Entity_ID` int(11) NOT NULL, `CreateDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `CreatedBy` int(11) NOT NULL, …
Travis
  • 599
  • 2
  • 6
  • 16
1 2 3
…
37 38