php mySQL - reduce update time

Attached code takes about 10 minutes to execute. Needs to be optimised to complete within less than 45 seconds.

I have tested this in Xampp on Windows (php5) and on a Linux web server (php4). The time test results are almost identical, so I don't think the delay is related to the host system, so I assume it is code related.

If the target time can not be acheived, the table data should be read into arrays, adjusted, and re-written to the table.

The original commands used to create the tables are included in the attached files.

The solution must be php and contain no classes.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

php Apache

Evner: Ingeniørarbejde, MySQL, PHP, Software Arkitektur, Software Testning

Se mere: Xampp, time table, linux update, mysql read files, windows web server php mysql, php delay, linux mysql create, windows php web server, program xampp, mysql create table data, apache php mysql, php mysql windows, execute seconds, web optimised files, update apache, xampp linux install, mysql update table, windows server xampp, mysql exist table, mysql xampp

Om arbejdsgiveren:
( 139 bedømmelser ) Umbogintwini, South Africa

Projekt ID: #3319907

3 freelancere byder i gennemsnit $33 på dette job


See private message.

$4.25 USD på 1 dag
(39 bedømmelser)

See private message.

$42.5 USD på 1 dag
(37 bedømmelser)

See private message.

$51 USD på 1 dag
(1 bedømmelse)