Terminé

Need Sphinx and SQL Optimization Expert (Indexing, Procedure) to Help Accelerate Queries

We currently have a Sphinx implementation that is being used to process large amounts of data (140 GB in SQL databases and Sphinx indexes).

One of our critical set of queries is no longer running optimally due to the large data set.

We need some one with experience in SQL query optimization (indexing or procedure) and Sphinx query development (using the Sphinx API or query language) to help us optimize our queries for the application so that they are running quickly and not timing out (due to PHP timeout errors).

This task will require:

1. Reviewing our existing queries

2. Optimizing them to leverage the Sphinx indexes more efficiently (essentially moving away from processing and pushing data via SQL entirely, or optimizing SQL queries so they can work in tandem).

3. Testing a deploying solution

Programmer will work with our existing development team to implement the solution.

Completion next week

Compétences : MySQL, PHP, Java, SQL, Sphinx

en voir plus : sql database schema stored procedure, sql server 2005 stored procedure copy table, freelance optimization expert, freelance job optimization expert combinatorial, sql query expert, create sql database schema stored procedure database map, need experience sql, installer sphinx sql, sql injection expert, sql server 2005 stored procedure latitude longitude search, shopping comparison feed optimization expert, search engine optimization expert pakistan, sql server exec stored procedure copy table table, sql server use stored procedure copy data, google base feed optimization expert, mathematical optimization expert, sql injection expert example

Concernant l'employeur :
( 0 commentaires ) Monroe, United States

Nº du projet : #21231437

Décerné à:

arhamsoftltd

Greetings, Hi, I understood your work, and I am willing to start work on your project. But I would prefer to work on an hourly basis. Please let me know how you would like to proceed? Many Thanks, David

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 7 jours
(171 Commentaires)
9.1

9 freelance font une offre moyenne de $138 pour ce travail

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(46 Commentaires)
6.0
RushService

Feel fee to contact me for Sphinx and SQL Optimization Expert .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] payment Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(64 Commentaires)
6.2
ninestar801

Hi, I have gone through your requirements and I can do this task. The skills and resources needed for this project are in my genes. I can assure you for a complete professional work in given time [login to view URL] share comp Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(14 Commentaires)
3.7
vladimir91216

Hello , Nice to meet you. I read your detail, and i understand what do you want! If you want to see my project, i can show my project anytime. If you want to get perfect result, please contact me anytime. I am fullsta Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(6 Commentaires)
3.7
theukwebexpert

Hello there! My name is Chris, I'm a UK based and native English speaking web developer and app expert with 10 years experience building and maintaining complex web apps and websites. I've built and maintained applic Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(4 Commentaires)
3.6
poojaahujawebit

HI, I have gone through your project description. I can build easily solve your problem. I will Write Html, CSS, PHP, Javascript, Jquery and Bootstrap Code for you. And make a Responsive Custom website for you Basi Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 15 jours
(1 Évaluation)
0.4
meikramull

***Hello Dear****** How are you? thanks for your posting. Very happy to have a chance bidding for your job. I am a full stack web developer and my major skill is Html, Css, Scss, Javascript, Bootstrap, Typescript, Rea Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(0 Commentaires)
0.0
chenmingbiz

Hello, Dear! I am a fullstack web developer and I have rich experiences in Mysql, Sphinx, javascript, Bootstrap, React, Angular. I can do it and start right now and available for you with fulltime manner. I would li Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(0 Commentaires)
0.0