我的表格中有一栏是text 。 用户可使用任何组合的词语......因此应当出现。 例如: Suppose string is :-Addicted to ackoverflow
假设用户类型通过和stackoverflow,那么结果也应出现。 换言之,它不是一个简单的<代码>,例如的操作者,我们可以通过该操作取得结果。 其他选择是使用全文检索。 但我的议席是InnoDb,而不是MyISAM,因此,我甚至不能使用全文搜索。 我每当一些用户搜索一个插座时,必须做一个临时表。 这非常低效。
谁能告诉我,对我来说,可以采取什么其他办法? 如果任何人都有自己的算法,也请予以分享。 我会更愿意这样做,而不是设立临时表格,并在每次进行某种搜查时放弃。
提前感谢:
页: 1
Sphinxsearch 实际支持非行和“我”组织。
Hi have this j2ee web application developed using spring framework. I have a problem with rendering mnessages in nihongo characters from the properties file. I tried converting the file to ascii using ...
Check this, List<String> list = new ArrayList<String>(); for (int i = 0; i < 10000; i++) { String value = (""+UUID.randomUUID().getLeastSignificantBits()).substring(3, ...
I am in the middle of solving a problem where I think it s best suited for a decorator and a state pattern. The high level setting is something like a sandwich maker and dispenser, where I have a set ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
I have a system which contains multiple applications connected together using JMS and Spring Integration. Messages get sent along a chain of applications. [App A] -> [App B] -> [App C] We set a ...
If I m given two Java Libraries in Jar format, 1 having no bells and whistles, and the other having lots of them that will mostly go unused.... my question is: How will the larger, mostly unused ...
I have a Class variable that holds a certain type and I need to get a variable that holds the corresponding array class. The best I could come up with is this: Class arrayOfFooClass = java.lang....
I m working on a Java desktop application that reads and writes from/to different files. I think a better solution would be to replace the file system by a SQLite database. How hard is it to migrate ...
