Finetuning MySQL database and querys

Hello! Having attached the php script that performs the query is just as close to almost nothing. That because usually the problem doesn't only reside in the script, but in the way the tables are built and indexes used. So the only possibly analysis for this kind of situations is on both the code (to see the queries) and the db tables, to see the indexes, data types used etc. So if you can also attach the tables used in the script, that'd be really of great help. Or, if you are willing to allow me ftp + phpmyadmin, I'll see for myself all the information needed. Moreover, a mysql slow query log would be greatly beneficial for use under such circumstances, but usually shared hosting doesn't allow customers to see it; if you have a dedicated server, I can instruct on how to create or fetch it. This is a placeholder bid, at this moment I can't tell 100% for sure that it only takes 5h, because I think there are several files and queries to be abalized, not only a single one, thus I'll wait for your files for a proper evaluation. Regards, Dragos

Hello!!! Very Very suitalble for ME. I'm professional web developer with full experience in JSP, JQuery, CSS3, PHP technologies. also , i have master laravel and codeigniter frameworks and anglar js, node js templates. keep in touch. my dear.

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce,vBulletin , Zen cart-Drupal , android and IOS , I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks

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 9 Professional Software Engg. Reply us so that we can move ahead to get this software successfully run. Regards Latest Technologies

A proposal has not yet been provided

Dear Sir/ Madam, My name is Henry - the owner of PHAMTECH Co. My team is really interested in this project as it is exactly within our scope of expertise: We are web/ app design & development company located in Hochiminh city, VIETNAM. Working with a team who has both in-house DESIGNERS and PROGRAMMERS means that you can take advantage of both: Our designers could help revise the design even in coding process, which is a GREAT benefit for any ongoing project. + We plan and build. We don't use prebuilt templates which produce conflicting codes and bugs and hurt the system in the long term. + Our team is 100% in-house. We don't outsource projects elsewhere. So you pay for the real service - not marketing fee. In short, if you need an experienced team who offers *real English* communication, beautiful design & optimized code, premium after-service, in time and to budget, then we are the choice. If you need something based on solely ONE of the above criteria, then we're still happy if you decide to give another freelancer a chance. Just bookmark our Freelancer profile https://www.freelancer.com/u/phamtech211.html and come back in case the selected freelancer can't meet your demands. Best wishes, Henry.

To whom it may concern, the problem is a small one. Should be rectified within 3hrs. You didn't use indexes on the db. Only on the primary key. Regards, Daniel

Hi, I am very interested to work on your project. I have 10 years experience in Web Development and few of my projects related with yours can be seen on my freelancer.com portfolio. Let's start our collaboration by sending me last details

A proposal has not yet been provided

Hello, We have gone through the scope of work and would be happy to provide complete solution on this and future support also if required. Scope of work includes - - Fine tuning database queries and adding indexing to speed up the queries Let's take it to the next step and start on this ASAP. Thanks, Techmart Team

A proposal has not yet been provided

A proposal has not yet been provided

Hello Dear Sir/Madam, We are having a Company of 25 members and we are new to freelancer and we are here to get big projects as per requirement of client and we have the ability to work anything on our skills such as we can do anything in PHP MAGENTO CSS WORDPRESS PLUGIN DEVELOPMENT EXTENSION THEME SOAP API AWS HTML HTML5 CSS3 JAVASCRIPT JQUERY SEO API DEVELOPMENT AND MANY MORE NOW WE ARE HERE TO PROVIDE OUR SERVICES. LOOKING FOR YOUR RESPONSE AND WE ARE HERE TO DISCUSS EVERYTHING ON OUR PROJECTS AND FEEL FREE TO ASK IF YOU NEED ANY SUGGESTION. Thanks

Wala pang naibigay na panukala

I am an experienced developer, with skills in particular languages, such as: PHP, MySQL, HTML, CSS, AJAX, jQuery. With 30+ years of IT experience, decided to come back to first love - programming in PHP and MySql.

A proposal has not yet been provided

Предложение еще не подано

Dear Sir/Madam, please let me introduce myself briefly. Fifteen years dealing with information technology, I am mostly familiar with fields of web development and system and network operations. I work with Linux servers on a daily basis, mostly with Ubuntu and Debian. Among other things I have strong knowledge in MySQL, PHP. I checked your PHP script and the MySQL dump and I saw some easily solvable design flaws which currently slow down your database. I'll solve this and I can make some modifications on your SQL to further tune the query speed. As I'm new here, I'd be nice to have some good recommendations, so I'll work hard to get yours! :) Having any questions please don't hesitate to contact me, I'll be glad to answer them. I'm looking forward to work with you. Kind regards, Robert.