Find Jobs
Hire Freelancers

Fixing database issues and performance

$250-750 USD

Closed
Posted over 7 years ago

$250-750 USD

Paid on delivery
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.)
Project ID: 11785248

About the project

58 proposals
Remote project
Active 7 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
58 freelancers are bidding on average $628 USD for this job
User Avatar
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 MySql. We have designed and coded many custom sites and applications of varied extents and complexity. We have coded complex search features. I have read the overview of your requirements. I am confident of delivering well. Which cache do you want us to use? Some of the settings seem to be done in config files, such as my.ini. I hope you have access to all files on the server? Please share site url and database structure with sample data. This will enable us to study how to go about # 2 and 3. When we work, we will need CPanel, SSH access. Once we have studied the site and the database, we will be able to assess scope of work. I will revise / confirm my bid accordingly. Detailed specifications and inputs will also help me to make an informed commitment and deliver as required. I ensure a very thorough job and also support if you need changes / enhancements in future. I look forward to hearing from you and working on the project.
$882 USD in 5 days
4.9 (938 reviews)
8.9
8.9
User Avatar
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 in 3 days
5.0 (250 reviews)
8.8
8.8
User Avatar
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 in 7 days
4.9 (530 reviews)
8.6
8.6
User Avatar
Warm wishes of the day..!! Gone through with your job post and sure to provide you with the work as mentioned. Further looking to discuss as per your availability. Thanks
$352 USD in 10 days
4.9 (684 reviews)
8.3
8.3
User Avatar
Hi, please provide your existing site link. your current site is develop in which framework? waiting for your response. Thanks
$600 USD in 10 days
4.8 (161 reviews)
8.6
8.6
User Avatar
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 experienced, creative & efficient enough to get your job done well. I look forward to work on this.
$588 USD in 10 days
4.7 (283 reviews)
8.0
8.0
User Avatar
Hello Mate! I am Interested in this project, can you please provide me the link of your travel agency site, so that I can review. I have vast experience of developing PHP and WordPress and till know I have completed 60+ projects. Looking forward to hearing from you soon. Thanks!
$588 USD in 15 days
5.0 (49 reviews)
7.4
7.4
User Avatar
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 website URL so we can check page test , HTTP request time , Image and CSS load time (individually ) 2 . If you select our service then we need FTP and Database access . 3. Your server details with ssh access. We are also expert in database indexing , Cloudfare CDN service for media load balancing . User/visitor load test etc..Caching means temporarily hold your page in a server location so if someone open same page twice then 2nd time page load very fast then the 1st time To discuss more please message me. i am ready to assist you. Regards Prasun
$750 USD in 10 days
4.7 (168 reviews)
8.0
8.0
User Avatar
With Freelancer Preferred badge bound to give 100% Quality (Let's Chat) Hello, A great team is here for your service!! I read the project description properly, and I agreed to fulfill 100% of all your requirements. I can start your important project right away. I am 24x7 available on chat, so i can serve you whenever you want. Please check the PMB. Let's start! To achieve goal with 100% quality we have team of 27 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Regards Dsv Infosolutions Pvt. Ltd.
$352 USD in 5 days
4.8 (135 reviews)
7.5
7.5
User Avatar
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 in 15 days
4.8 (327 reviews)
7.9
7.9
User Avatar
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 in 10 days
5.0 (385 reviews)
7.3
7.3
User Avatar
Hi there. I'm Alex. I can help you with this and I'm ready to start anytime. Please don't hesitate to check my feedback page and see what other clients are writing about me. Thank you. Cheers. Alex
$494 USD in 1 day
5.0 (165 reviews)
7.1
7.1
User Avatar
Hello, I have read through your project and I am incredibly interested in taking on your project. I am an experienced developer with a diploma in the field of web development. i have recently also earned my preferred freelancer badge. I have been working in the field of web development for roughly 7 years. I take great pride in my work and deliver only the best quality. My skill-set includes... -PHP -HTML5 -CSS -AJAX -Responsive Design -Joomla -Wordpress -Magento -Drupal -Photoshop -Illustrator -Video Editing -Data entry -Iphone -Android I look forward to hearing from you and hopefully we will have the opportunity to work together. Thank you, Coasif
$588 USD in 10 days
4.6 (223 reviews)
7.3
7.3
User Avatar
Hi Sir Greetings I have 8+ years of experience in web development and also have sound knowledge of database optimization. Please invite me on freelancer chat to discuss more on this project. Waiting for your positive reply. Thanks Abhishek
$280 USD in 10 days
4.8 (93 reviews)
6.7
6.7
User Avatar
I am expert of programming. PhP and MySQL are my expertised and core skills. please give me a cjance to proove myself. ready to start
$264 USD in 2 days
5.0 (78 reviews)
6.1
6.1
User Avatar
Hi i am experienced in this kind of job and know how to this job, i did lots of job like that.. i can do it perfectly and make you fully satisfied. see my ratings and reviews to make you more confident on me and my work.
$588 USD in 10 days
5.0 (124 reviews)
6.3
6.3
User Avatar
‌I have a lots of experience in PHP MVC,MySQL, Wordpress, Codeigniter, laravel and Web Designing. my aim to deliver quality products to our customers within specified deadline. If hired by you I will put in my best work. I am ready to be hired by you and start work on your jobs
$682 USD in 12 days
4.7 (103 reviews)
6.3
6.3
User Avatar
Hi, I study given requirement, I understand that you want to fix given database issues. I am Web Developer with 10+ years of experience. In past, I work on database. I believe I can successfully complete this project as per your expectation. Please inform me about your prefer time to chat so we can discuss the project in detail and it is possible for me to give you a fair estimation. Best Regards, Prashant
$600 USD in 20 days
5.0 (22 reviews)
5.6
5.6
User Avatar
Hello Sir I am a web developer and have a lot of experiences on web developing. You will know about me by visiting my profile. I want to chat with you about your job more details. I think I can do your job fully. Thankx, Best regards.
$526 USD in 10 days
4.7 (15 reviews)
5.5
5.5
User Avatar
Hi, I reviewed your requirement and I can do this job as per your requirement, I have huge skills in PHP, MySQL, Javascript, HTML, Jquery, MYSQL ,AJAX/ Magento, and CSS to name a few. you can hire me for your project. I always believe in long-term business relationship. I have worked more than 100 + website in Magento/WordPress including theme and customized theme as well. Looking forward for your positive response. For more reference please see portfolio herewith. Regards, Ravi
$250 USD in 10 days
5.0 (1 review)
1.7
1.7

About the client

Flag of GREECE
XANTHI, Greece
5.0
8
Payment method verified
Member since Oct 18, 2015

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.