I gang

optimize sql

I have a large database that is called very frequently.

it is growing very fast and now has over a million entries.

my requests take 30 seconds and i need them down much faster

i have some indexes on the database but i don't understand them very well.

i would provide access to a git repository of a cakephp project and a dump of the database for you to get running and work on locally.

then you would need to make updates and optimizations and explain what was changed and how i can go about doing it on my local version and later live version.

this could be done in git making a fork request or explaining manually.

Færdigheder: CakePHP, Database Administration, Programmering af database, MySQL

Se mere: programming sql, database programming sql, mysql fork, cakephp project work, sql optimize, cakephp version, repository database, database dump, explain animation work, cakephp database programming, optimize cakephp, oracle sql optimize, cakephp optimize, peelsasleep, virtuemart sql optimize, sql optimize database, mysql optimize, cakephp mysql optimize, optimize sql indexes, optimize database mysql, sql database programming, optimize database, mysql optimize large database, mysql need optimize, cakephp mysql

Om arbejdsgiveren:
( 10 bedømmelser ) Berlin, Germany

Projekt-ID: #6040421

Tildelt til:

bigdognec

Since you are using git, any query changes can be committed to a new branch. Any structural changes may need to be put in a sql file that needs to be run on your local and live. I have a great track record for optimiza Mere

€94 EUR in 2 dage
(64 bedømmelser)
6.4

25 freelancere byder i gennemsnit €188 for dette job

khush1984

Hi, I am interested for this project. I am having 8 years experience in php and mysql. I am having extensive knowledge of different advance php frameworks like zend framework, Cakephp, Codeigniter and some open s Mere

€200 EUR in 3 dage
(84 bedømmelser)
7.2
njdebugger

Hi, I am very interested. I have gone through the requirements you described in your detail. Please let me have the Git access and the db dump. I will debug to speed up the page I have been working with CakePHP s Mere

€147 EUR in 3 dage
(59 bedømmelser)
7.2
jfreyre

Optimization expert here, normally for that many rows is convenient to other approachs, let me know about your database, which table is having that many rows and what is the use of that table on your script. Jose

€200 EUR in 2 dage
(78 bedømmelser)
6.7
morff

Hi, i have read your project description, and checked the attached code. I understand what you want, and i would like to offer you my services. I have excellent knowledge of CakePHP, MySQL and related technologies, mos Mere

€200 EUR in 7 dage
(63 bedømmelser)
6.0
SoftDevelopINC

Hello, May I discuss with you for further details about this project? I'm really interested in your project because I'm expert in CakePHP with over 5 years experienced, solid knowledge MCV and OOP. There are Mere

€210 EUR in 5 dage
(19 bedømmelser)
5.6
bdsitech

Hi, I have completed 100+ projects with PHP & MySQL.I have long time experience to work on website and its development using PHP/MySQL.You can check my profile and feedback records. If you award me this project it wil Mere

€222 EUR in 2 dage
(30 bedømmelser)
4.7
mmagr99

Just Give us Chance to show you what we are Please must Read our Valuable feedbacks Social Websites http://newsaxon.org/ http://www.lavalife.com/ http://www.faceguru.com/ http://www.canadianpassions.com/ h Mere

€208 EUR in 3 dage
(12 bedømmelser)
4.6
GandalfTheGrey

Please provide some more details (your environment, use cases, queries, etc.) so then I could estimate time and effort needed for this task and adjust my bid accordingly.

€250 EUR in 3 dage
(8 bedømmelser)
4.4
acronymsolutions

Hi, I have gone through your requirements.I am a DBA at CMM5 Level company since August 2010.I am working on MySql,SQL,MS Access,Oracle database, I can do your job confidently. I am very much Interested to do your wo Mere

€185 EUR in 3 dage
(10 bedømmelser)
3.9
janghoil

Dear Employer Thanks for your job posting. I've just applied after reading your job posting carefully. I have good knowledge and experince in CakePHP programming. 1. My Skills and Experiences are like foll Mere

€222 EUR in 5 dage
(3 bedømmelser)
3.1
opustechnology

Hello sir, We have good experience of Photoshop,Banner Design ,Flayer mail, Logo Design, PHP, HTML,HTML5,CSS,JavaScript,Mysql,JOOMLA,wordpress, Graphic Design,Website Design, Android, java, .net. please check m Mere

€210 EUR in 5 dage
(7 bedømmelser)
3.1
splendidgroups

hi , i am ready to work with you on least amount while giving you better quality then any other one !! the reason is just to create a long term realtions with you and your organization !! i am having more then Mere

€200 EUR in 3 dage
(7 bedømmelser)
3.0
shukaibzafar

Hello Hiring Manager! i have done graduation in computer science from top class university of pakistan. i have an experience of 4+ years in web designing,web development and have done job in software company. i am an Mere

€200 EUR in 7 dage
(6 bedømmelser)
2.9
Ecoseit

hi , i am ready to work with you on least amount while giving you better quality then any other one !! the reason is just to create a long term realtions with you and your organization !! i am having more then Mere

€144 EUR in 3 dage
(2 bedømmelser)
2.8
classon

I managed the Flickr.com database cluster during its early growth phase. This was a mysql database cluster with 1 master and 7 replicated slaves. The web front end contained over 50 apache/php servers. I built the sche Mere

€222 EUR in 3 dage
(1 bedømmelse)
1.4
hacpaka

Hello, I will be glad to help you. Thanks, Alex, CTO ABOUT US: We are Eggbe Team. Our office in Riga and we adhere to the traditions of European quality. We specialize in social networking and mobile ap Mere

€155 EUR in 3 dage
(2 bedømmelser)
1.1
ronyhr

Hi We have fixed same issue in other big auction website using cache and mysql optimizations? Ajay

€277 EUR in 3 dage
(1 bedømmelse)
0.0
dcarnelutti

wide experience tunning databases on mysql, posgre, sqlserver and oracle. I can do this work for you

€155 EUR in 5 dage
(0 bedømmelser)
0.0
azmilibn

Hi, well, as per my understanding, database tuning not only depend on indexing, normalizing database and de-normalizing as per requirement would make much more performance on database level. apart from that, vast use Mere

€250 EUR in 7 dage
(0 bedømmelser)
0.0
scfong

Dear sir, I have many experience to fine tune SQL. I can help you to fine tune not only add index, but also rewrite the SQLs, fine tuning MySQL (my.cnf) parameters. Million records is not too many. I'm handling Mere

€144 EUR in 5 dage
(0 bedømmelser)
0.0