Project: Full Text Search in mysql ID: 1210171205

Status:	Open
Budget:	N/A
Created:	5/7/2008 at 10:40 EST
Bidding Ends:	5/21/2008 at 10:40 EST (9 days left)
Project Creator:	salber Rating: (32 reviews)
Description:	On a database of 100,000 entries, implement full text search on the title and description fields. The table and fields that need to be search are | Field | Type | Null | Key | Default | Extra | +-------------------+---------------+------+-----+---------+-------+ | entry_unique_id | varchar(32) | NO | PRI | | | | category_id | int(11) | NO | MUL | 0 | | | location_id | int(11) | NO | MUL | 0 | | | xml_entry_title | varchar(1024) | NO | | | | | xml_entry_descr | text | NO | | | | | xml_entry_link | varchar(255) | NO | | | | | xml_entry_pubdate | int(11) | NO | | the xml_entry_title and xml_entry_descr fields. The description field has a maximum lenght of 500 characters. The search function should be optimized for search, rather than updates, and cacheing searches should be part of the solution. Please supply harness scripts to test the solution with a list of queries terms in a file. I will supply the database table, and will run benchmark tests on the speed. Please do not bid if you have no full-text-search experience.
Job Type:	MySQL

Messages Posted: 37

Programmers	Bid	Delivery Within	Time of Bid	Rating
krypt2005	$100	2 days	5/11/2008 at 6:51 EST	(No Feedback Yet)
Hi, I have a good hands on java and mysql,I can accomplish this task easily.So i like to avail this opportunity. Thanks
vishalce2008	$100	2 days	5/8/2008 at 1:02 EST	(No Feedback Yet)
bprozcom	$150	2 days	5/7/2008 at 23:23 EST	(18 reviews)
******** 100% Satisfaction is Guaranteed ********
codebarons	$150	3 days	5/7/2008 at 17:47 EST	(37 reviews)
We will do it and fast too. Pls see PMB.
inoday	$150	5 days	5/10/2008 at 6:03 EST	(1 review)
We are medium size company with head counts of 40-45, mainly located in India,Greece,USA. Right now we are providing services in more than 30 countries. As we are growing now and we would like to increase our business relationship boundaries, I would like to give service for your proposal. I will not take much time of yours. In case if you are interested to talk for further, Please feel free to contact us. Thank you and regards,
greentech12	$190	5 days	5/7/2008 at 17:04 EST	(44 reviews)
Escrow to Proceed
fede	$200	5 days	5/7/2008 at 12:54 EST	(11 reviews)
Please check PMB
nidhi	$200	3 days	5/7/2008 at 12:08 EST	(37 reviews)
ready to start
amitysoftware	$210	4 days	5/7/2008 at 11:17 EST	(No Feedback Yet)
We are WebSite Builder Using PHP+MYSQL. and we are experience in MySQL.
softechblr	$250	4 days	5/7/2008 at 13:43 EST	(7 reviews)
can be done.
wincent	$250	3 days	5/7/2008 at 10:59 EST	(55 reviews)
i can do this. im familiar with mysql and its full text search.
alexs	$255	2 days	5/9/2008 at 7:15 EST	(2 reviews)
Hi salber. I am expert in MySql/php and full-text search functions.I can provide full-text search in "natural", "boolean" modes as well as searching with "stopwords" and "restrictions". Also, if you need searching with morphology I can suggest another solution. I know how to speed up searching wherewith caching.
khanhhuyna	$300	7 days	5/7/2008 at 12:45 EST	(2 reviews)
Ready to work! Thanks!
agentjax	$303	5 days	5/7/2008 at 10:50 EST	(88 reviews)
Please check PMB.
lampc	$500	8 days	5/9/2008 at 5:30 EST	(603 reviews)
can be done... http://www.agriya.com