Find freelancers. Lose those costly delays.

With 1.7 million freelancers, we'll match you with the perfect talent.

or, Register with Elance »

Sphinx server install an index
Sign in to Add to Watch List

IT & Programming > System Administration

View Change History

The client has made the following changes to the job.


Job canceled.

May 7, 2012

Job Description

  |  Change History >>


  • Posted: Sun, May 06, 2012
  • Time Left: Closed
  • Location: Anywhere
  • Client prefers freelancers from:

    You are still able to submit a proposal for this job.

    The client prefers freelancers from
    a different location.

    You're still able to submit a proposal for this job, regardless of your location.
  • Start: Immediately
  • Budget: Less than $500
  • Fixed Price Job
  • Elance Escrow Protection
  • W9 Not Required
Sign in to view client's details

We use a custom search script which runs full text queries on a a couple of databases. Like this:

SELECT site_id, threadid, keywords, excerpt, origtitle, entry_type, dateline, replycount,
MATCH (keywords,excerpt) AGAINST ('$query') AS score
FROM search_keys where MATCH (keywords,excerpt) AGAINST ('$query') and replycount>2 order by score desc LIMIT {$start},{$items_per_page};

We want to get the sphinx search installed and configured to index these two databases so that the sphinx indexes can be used in the script instead of a full text mysql search.

The indexes should be available on the mysql so that we can just modify the query on the search script to use the indexes and the query should return the same data containing all the columns site_id, threadid, keywords, excerpt, origtitle, entry_type, dateline, replycount.

It should take a couple of hours for an experienced admin to get this done. We have a budget of $100 for this.

Please bid if you are available to work on this...

Sign in or Register to see more

Job ID: 30350476
Avg $ | High $ | Low $ — Show Pricing
  • Submit Date (Latest)

Vineet Goel      
Vineet Goel's identity has been verified.  Learn More
 India  |  
An independent and highly experienced web technology expert. Expertise in various layers of web technologies like solution architecture,...
 0.0   |  Private   |  0 Jobs
Bid ID: 30363596  |  Submitted: May 7, 2012 06:44 ET 
Proposal SEALED

Inderjit S.      
Inderjit S.'s identity has been verified.  Learn More
 India  |  
10yrs of Experience in IT. Provide 24/7/365, reliable, cost-effective,Cloud support, secure Outsourced Server Support, Remote Server...
 5.0   |  Private   |  35 Jobs
Bid ID: 30358072  |  Submitted: May 7, 2012 01:18 ET 
Proposal SEALED
Sign in to Elance and start working on jobs today.
Sign in to view more of the job details and submit a proposal. Once registered, you'll have access to thousands of jobs online or through email.
Are you ready to post a job like this one?
Post a Similar Job »