Færdiggjort

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.

Evner: CakePHP, Database Administration, Programmering af database, MySQL

Se mere: t sql programming, programming in sql, database programming sql, mysql fork, cakephp project work, sql optimize, cakephp version, repository database, database dump, explain animation work, cakephp database programming, explain implications work ethic sheehy describes, 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

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 Flere

€94 EUR in 2 dage
(88 bedømmelser)
7.1

24 freelancere byder i gennemsnit €189 på 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 Flere

€200 EUR in 3 dage
(149 bedømmelser)
7.9
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 Flere

€147 EUR in 3 dage
(72 bedømmelser)
7.5
mmagr99

Just Give us Chance to show you what we are Please must Read our Valuable feedbacks Social Websites [login to view URL] [login to view URL] [login to view URL] [login to view URL] h Flere

€208 EUR in 3 dage
(32 bedømmelser)
7.0
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 Flere

€200 EUR in 7 dage
(101 bedømmelser)
6.5
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 Flere

€210 EUR in 5 dage
(45 bedømmelser)
6.5
bdsitech

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

€222 EUR in 2 dage
(31 bedømmelser)
4.8
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 Flere

€185 EUR in 3 dage
(35 bedømmelser)
5.4
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
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 Flere

€200 EUR in 7 dage
(20 bedømmelser)
4.2
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 Flere

€222 EUR in 5 dage
(4 bedømmelser)
3.1
dcarnelutti

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

€155 EUR in 5 dage
(1 bedømmelse)
3.1
classon

I managed the [login to view URL] 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 Flere

€222 EUR in 3 dage
(2 bedømmelser)
2.5
grundahl

Hi, I'm a professional DataBase Administrator working for big clients like french government. I can do your job very efficiently. Sincerely yours, Eric

€150 EUR in 5 dage
(1 bedømmelse)
2.6
nikhilratnaparkh

Hello there, We understand that optimization is required in your database queries, and we 150% sure that we do it with quality and in economic cost. We you hire us , we are ready to start working on it on immedia Flere

€105 EUR in 3 dage
(1 bedømmelse)
2.4
rsmusthafa

Hello, Being certified "MySql DB Administrator" & experienced in optimisation more than 12 yrs, i can handle this issue and fix in time Regards Musthafa

€250 EUR in 3 dage
(5 bedømmelser)
2.2
cipvtl

HI - I have 8+ years experience in PHP, CakePHP and familiar to work with huge database.. I am very much interested for this job, Can we discuss further? Thanks, Deep

€222 EUR in 10 dage
(2 bedømmelser)
1.4
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 ([login to view URL]) parameters. Million records is not too many. I'm handling Flere

€144 EUR in 5 dage
(1 bedømmelse)
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
tigernotiger

一个有效的提议尚未被提供

€211 EUR in 2 dage
(0 bedømmelser)
0.0
godpote

Hello I can help you with this problem. I need to check database/table structure and must now whats the growth rate or how many petitions per second are you receiving, we could try using a trigger to increase perfor Flere

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