Fixing database issues and performance

Κλειστό

We have a travel agency site and we need some fixes to be done

Specifically

#1 - Optimize Cache Settings (currently disabled) (this will improve search.)

#2 - Optimize Connections Count Settings (currently 100 as I remember.) This will fix most 'database gone away' issues.

but more importantly is #3 - Restructure of tables indexing of packages tables, and rewriting search code. ( this will allow many more packages on the system and improved performance)

3.a. Currently there are not appropriate database indexes on the packages table, which has 100ks of packages and is badly optimized. This means for 1 search all 300k packages must be scanned. With proper index table, this will not happen. This also means that performance will decrease as more packages are added to the system.

3.b. by creating separate dates and origin/destination data to mysql tables and indexing this data independent of package table, this will increase performance so that whole package table is not searched. (for example to search 1 month packages only, all packages from all months must be forcefully scanned by mysql server, because of improper indexing.)

Δεξιότητες: AJAX, PHP, Programming

Δείτε περισσότερα: performance evaluation database excel, common issues database driven applications, concrete5 performance issues, employee performance evaluation database, risk actions issues database, performance tuning database, performance evaluation database, flv performance issues, sql backup performance issues, performance issues flash projector cd rom, solaris nfs data domain performance issues, indesign script index proper names, software database looks index cards, weblogic performance issues transform, dot net nuke performance issues, zen cart database phpmyadmin slow performance, php script fixing mailing list database issue tomtbit

ID Εργασίας: #11785248

61 freelancers κάνουν προσφορές με μέσο όρο $622 γι' αυτή τη δουλειά

hits

We are a team of designers and developers with expertise and experience in Photoshop, HTML5, CSS3, PHP, AJAX, JQuery, Angular JS, XML, Wordpress, Joomla, Shopify, Bootstrap, CodeIgniter, Laravel, Google Map API and MyS Περισσότερα

$882 USD σε 5 μέρες
(908 Αξιολογήσεις)
8.9
e3d

Hi, I can help you to optimize your database so it will start working faster. Please show me your website and website's backend

$764 USD σε 3 μέρες
(181 Αξιολογήσεις)
8.5
michale21

Hi, Greetings from Votive Technologies!! ********* We have Good experience expertise on your all features and skills requirement, please review our some works on Travel Portals: http://www.despegar.com.ar/ h Περισσότερα

$700 USD σε 10 μέρες
(318 Αξιολογήσεις)
8.4
$882 USD σε 15 μέρες
(345 Αξιολογήσεις)
8.3
aistechnolabs

Greetings, I am very thankful for this opportunity. It’s really exciting that we have below similar kind of expertise and work experience: http://www.flexitours.net/ http://www.kaymu.co.ug/ http://dazo.in/ htt Περισσότερα

$764 USD σε 15 μέρες
(41 Αξιολογήσεις)
8.3
DevWorkshop

Hi ! we would like to check out the database and coding structure and then will be in a position to comment on the time and cost involved in this project. if you can message back, we can can discuss all details and Περισσότερα

$750 USD σε 10 μέρες
(787 Αξιολογήσεις)
8.3
nuked24

Hi, please provide your existing site link. your current site is develop in which framework? waiting for your response. Thanks

$600 USD σε 10 μέρες
(143 Αξιολογήσεις)
8.4
arhamsoftltd

Hi, This is my tentative bid. After reviewing the job description, I am glad to offer my services for the fixing and optimization of your travel agency's website's database, cache and development work needed ther Περισσότερα

$588 USD σε 10 μέρες
(101 Αξιολογήσεις)
8.2
TheInnoVibes

Hello, We are a hard-working web-development company working on core PHP And Wordpress projects. We can develop cross-browser, W3C compliant good quality professional websites. We have gone through your requirement Περισσότερα

$941 USD σε 10 μέρες
(368 Αξιολογήσεις)
8.1
mmagr99

Hi, This kind of project is my forte. I can definitely complete this for you. This project is pretty straight forward. I just have a few questions for you for discussion.I am recommended Freelancer by freelancer.co Περισσότερα

$705 USD σε 4 μέρες
(126 Αξιολογήσεις)
7.9
nmans

We are highly interested to work with you on this project and can assure you quality results ready to start immediately some of our developed websites are listed below Wordpress: http://www.wilsontenniscamps.c Περισσότερα

$882 USD σε 10 μέρες
(268 Αξιολογήσεις)
7.7
shivmirthyusl

ABOUT US "IT FLEX SOLUTIONS has focused exclusively on the Web Development/Designing projects with 8+ years of service. Our Web Development/Designing expertise has helped clients to create e-commerce, social networkin Περισσότερα

$588 USD σε 10 μέρες
(159 Αξιολογήσεις)
7.8
maxsmith8

Hi, I have gone through your project requirement specification and as per my previous experience with this I am capable to do this project. I ensure to give a best quality website with good performance and responsi Περισσότερα

$722 USD σε 10 μέρες
(145 Αξιολογήσεις)
7.9
pointlogic

Hello, I have an experience of more than 8 years in web development and maintenance. I have in-depth knowledge of php, mysql, jquery, paypal integrations, AJAX ,API's, css, html, html5 and SEO. Our team is experie Περισσότερα

$588 USD σε 10 μέρες
(221 Αξιολογήσεις)
7.7
phpdevindia

Respected Concern, We have the potential as well as experienced regarding Database indexing and therefore very much interested to work in your project. Approach to the Job: We need the following.. 1. The w Περισσότερα

$750 USD σε 10 μέρες
(166 Αξιολογήσεις)
7.8
tomydeveloper

HI, I have read all of your 4 points . I will fix your database issue and optimise the performance as well. Let me know if you have any other questions. THanks

$882 USD σε 15 μέρες
(308 Αξιολογήσεις)
7.8
fattahaabdul

Expert in DB performance. i have 8+ years of experience. Can we discuss the project. Please initiate a chat with me so that we can discuss the project at a broader level. Why you should hire me- 1. I have a very Περισσότερα

$1052 USD σε 10 μέρες
(58 Αξιολογήσεις)
7.6
Yknox

Hello I'm interesting your project very well I'm a Good PHP, Java, DB, Math, Algorithm expert. I m quite well experienced in these jobs. Let's go ahead with me I want to service for you continously. Thanks

$750 USD σε 7 μέρες
(256 Αξιολογήσεις)
7.5
tlchung

I am a skilled developer i have tune and optimize lot of website for my clients, i can review the setup, install cache, optimize the db for you so the performance boost. let discuss more via private message, thanks.

$555 USD σε 10 μέρες
(280 Αξιολογήσεις)
7.2
posspooja

Hello, I am an PHP Developer with more than 7 years of experience and shall get this done in about 10 days' time. Let me know if you have any doubts / queries about my expertise, will be more than happy to addr Περισσότερα

$823 USD σε 10 μέρες
(122 Αξιολογήσεις)
7.5