login
Forgot?
Login with Facebook

Don't have an account? Register one now!

Looking for Expert sql databases and php

Bids 
27
Avg Bid
$172 USD
CLOSED

  • Project ID:

    785586

  • Project Type:

    Fixed

  • Budget:

    $30-$250 USD

Project Description:

We posted this project earlier this week but couldn't get this problem resolved. I have a database that has over 600,000 thousand records in this one table and growing rapidly. This table and others are updated via a cron php script we create.

The cron script update 4 main tables which are important part of the whole site. But since its grown and will grow rapidly, it takes longer to update.

I had 2 programmers look at the table design and only attempted to update cron script. Programmer 1 updated it by splitting the script into 3 script so the loop want be so long. This only worked temporary but it will not update all the records.

Programmer 2 said that there is not primary key in table so its hard to index the table to update it fast. They said it may have to update entire code so you can use a primary key to update things.

I need to get this database update so my users will be happy, also I need a long term solution that can quickly update millions or records.

Skills required:

MySQL, PHP, SQL

Additional Files:

main_cron.php
See more: sql update script, sql code, php sql database project, sql database tables, expert sql, cron script update database, expert code php, need php programmer update script, sql database project, database design sql, sql update code, php table design, update code php, database php script, database update script, search multiple databases sql php, looking sql expert, php sql expert, sql php databases start, php raw sql server, php admin sql dump, joomla bridges php databases, sql import routine loop, php htmlentities sql injection, php pdfreport sql

Project posted by:

optimizehosting United States
(86 Reviews)
Last seen:
Post a Project like this Report Project

Public Clarification Board

6 messages

  • optimizehosting

    I am online now and ready to discuss with anyone who can help me fix these issues to speed of my querying of information from my databases

    over 1 year ago

  • SEugeneV

    can provide you fastest possible solution BUT it will cost more than your budget + i cant bid coz bidding period finished :(

    over 1 year ago

  • optimizehosting

    here is 3rd image

    Attachment: scene3_1.gif

    over 1 year ago

  • optimizehosting

    here is second image

    Attachment: scene2_1.gif

    over 1 year ago

  • optimizehosting

    hi everyone here is a screen shot of tables and database.

    Attachment: scene1_1.gif

    over 1 year ago

  • johanndutoit

    Hi sounds like a interesting problem. Would love to just have a wheel at it to see if I can find a solution. I see you have had many other developers so I'll be happy to let me first find a solution (see if I can) and then see any money.

    over 1 year ago


If you are the project creator or one of the bidders, please Log In for more options.


Awarded Bids

Freelancers   Bid (USD) Time of Bid Freelancer Reputation
gasparch Armenia
gasparch
Armenia From Armenia     Offline
  General Freelancer Orientation (85%, 95th percentile)
 Accepted
$199 in 2 days 
$100 Milestone Requested
over 1 year ago
4.9
5.2
28 Reviews
86% Completion Rate
Could be done quite fast. Please see PM.

All Bids ()

Freelancers Msg Bid (USD) Time of Bid Reputation
humashahid80 Pakistan
baslogo.png
humashahid80
Pakistan From Pakistan     Gold Member     Offline
  General Freelancer Orientation (75%, 81st percentile)
  Foundation LimeExchange Member
$200 in 14 days 
0
over 1 year ago
4.9
6.7
46 Reviews
61% Completion Rate
Hi, Immediately ready for your work, please check PM for details.

ambar India
SSD-Icon-D2.jpg
ambar
India From India     Gold Member     Offline
  Foundation Freelancer.co.uk Member
  US English Level 1 (%, 46th percentile)
$100 in 5 days 
0
over 1 year ago
5.0
6.6
47 Reviews
80% Completion Rate
Dear Sir/Madam, Please check my private message. Thanks Shome.

shuiwatermizu Australia
shuiwatermizu
Australia From Australia     Offline
$250 in 5 days 
0
over 1 year ago
4.9
6.4
92 Reviews
89% Completion Rate
please see pmb

Mindon China
1.jpg
Mindon
China From China     Offline
  Foundation EUFreelance.com Member
$198 in 2 days 
$99 Milestone Requested
over 1 year ago
4.9
5.9
50 Reviews
77% Completion Rate
Check the PM pls

edsiper Chile
ed_blog.jpg
edsiper
Chile From Chile     Offline
$150 in 2 days 
0
over 1 year ago
5.0
5.7
3 Reviews
72% Completion Rate
Hi, I'm a very experienced developer with strong background in performance issues, please check my private message

fastwebsolutions India
fastwebsolutions
India From India     Offline
  General Freelancer Orientation (90%, 98th percentile)
$200 in 2 days 
$200 Milestone Requested
over 1 year ago
4.7
5.5
13 Reviews
96% Completion Rate
See PMB for more information.Thanks.

forrestwang China
2322723_100.jpg
forrestwang
China From China     Gold Member     Offline
  General Freelancer Orientation (85%, 95th percentile)
  Foundation EUFreelance.com Member
$200 in 5 days 
$100 Milestone Requested
over 1 year ago
4.8
5.3
22 Reviews
77% Completion Rate
hi, i would like to do it for you .thx

leprakhauns United States
leprakhauns
United States From United States     Offline
  Freelancer Orientation (90%, 100th percentile)
  General Freelancer Orientation (80%, 90th percentile)
$50 in 1 day 
0
over 1 year ago
4.8
5.2
39 Reviews
77% Completion Rate
See PM for details.

servicebenq Cyprus
service (Custom) (3).jpg
servicebenq
Cyprus From Cyprus     Offline
  General Freelancer Orientation (90%, 98th percentile)
  Foundation EUFreelance.com Member
$150 in 1 day 
$90 Milestone Requested
over 1 year ago
4.9
4.8
23 Reviews
65% Completion Rate
Hi Please See your PM. Thanks

univane India
logo.png
univane
India From India     Offline
  Foundation Freelancer.co.uk Member
  General Freelancer Orientation (75%, 81st percentile)
$250 in 10 days 
$125 Milestone Requested
over 1 year ago
4.9
4.4
22 Reviews
57% Completion Rate
Please check PM. Thanks

freelance4hire80 Malaysia
adv_perl.JPG
freelance4hire80
Malaysia From Malaysia     Offline
  General Freelancer Orientation (75%, 81st percentile)
$150 in 2 days 
$150 Milestone Requested
over 1 year ago
5.0
4.1
10 Reviews
92% Completion Rate
Lets me solve this problem for you.

prowesssolutions India
Picture1.jpg
prowesssolutions
India From India     Offline
  Foundation EUFreelance.com Member
$180 in 2 days 
$36 Milestone Requested
over 1 year ago
5.0
3.4
5 Reviews
37% Completion Rate
plz check pmb Thanks

yvayse01 United States
yvayse01
United States From United States     Offline
$150 in 3 days 
0
over 1 year ago
5.0
2.4
4 Reviews
66% Completion Rate
Can start imediately

fshahzad Pakistan
fshahzad
Pakistan From Pakistan     Offline
  General Freelancer Orientation (80%, 90th percentile)
$100 in 4 days 
$50 Milestone Requested
over 1 year ago
5.0
2.0
1 Review
33% Completion Rate
Hi, Please see my PM.

drjanko Serbia and Montenegro
drjanko
Serbia and Montenegro From Serbia and Montenegro     Offline
  Foundation EUFreelance.com Member
$100 in 0 days 
$100 Milestone Requested
over 1 year ago
5.0
1.0
1 Review
50% Completion Rate
Hi, please check PMB.

redhop Morocco
kenpachi.jpg
redhop
Morocco From Morocco     Offline
$30 in 2 days 
$30 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
0% Completion Rate
hi i can update it for u check pm

whitekin Slovenia
PRIJON-CROSS-2mini.jpg
whitekin
Slovenia From Slovenia     Offline
$200 in 2 days 
$80 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
Please, check PMB.

kota555 India
kota555
India From India     Offline
  Foundation LimeExchange Member
  Foundation EUFreelance.com Member
$150 in 5 days 
0
over 1 year ago
0.0
0.0
0 Reviews
0% Completion Rate
I am having 6yrs of working experience with SQL. I am a single developer. Hope to hear from you.

MegaaSoft India
MegaaSoft
India From India     Offline
$200 in 5 days 
$20 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
I can help you, Lets start

dineshdeveloper India
dineshdeveloper
India From India     Offline
$100 in 4 days 
$50 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
I am ready to work.

johanndutoit
avatar267288_1.PNG
johanndutoit
    Offline
$200 in 7 days 
$200 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
Hi sounds like a interesting problem. Would love to just have a wheel at it to see if I can find a solution. I see you have had many other developers so I'll be happy to let me first find a solution (see if I can) and ... more
Hi sounds like a interesting problem. Would love to just have a wheel at it to see if I can find a solution. I see you have had many other developers so I'll be happy to let me first find a solution (see if I can) and then see any money. less

fpremuta Italy
fpremuta
Italy From Italy     Offline
$200 in 5 days 
$100 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
I use PHP script on a Postgres database all the days. I have the solution

johnbeki Pakistan
johnbeki
Pakistan From Pakistan     Offline
$176 in 3 days 
$127 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
0% Completion Rate
the team is ready to solve the problem

mechanic2000 New Zealand (Aotearoa)
mechanic2000_da_b1.png
mechanic2000
New Zealand (Aotearoa) From New Zealand (Aotearoa)     Offline
$300 in 6 days 
$150 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
interesting task

binarylogix Pakistan
logo.jpg
binarylogix
Pakistan From Pakistan     Offline
  Foundation EUFreelance.com Member
$250 in 5 days 
$125 Milestone Requested
over 1 year ago
0.0
0.0
0 Reviews
50% Completion Rate
Hi, Dear please check INBOX for detail thanks.

DondieAriola Philippines
DondieAriola
Philippines From Philippines     Offline
$200 in 5 days 
0
over 1 year ago
0.0
0.0
0 Reviews
New Freelancer!
PLease check PM

Freelancer.com (formerly GetAFreelancer) is the world's largest outsourcing and crowdsourcing marketplace for small business. We have hundreds of thousands of satisfied customers from all over the world. We connect over employers and freelancers globally from over 234 countries & regions. Through our website, employers can hire freelancers to do work in areas such as software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services. The average job is under US$200, making outsourcing for the first time extremely cost effective for small businesses.

Would you like to find freelance jobs and make money online? Just sign up to get started! We have created a safe environment for both freelancers and employers via our secure milestone payment system. We have thousands of freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, professional programming, custom writing or affordable marketing has never been easier! Try outsourcing for free today! Don't forget to bookmark our homepage for your next project or job.

© Copyright 2011 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)