Devam Ediyor

SQL Database cleanup script optimization

I have a script that runs on a cron and cleans the website database of duplicate entries, the data uniqueness is based on 2-3 field in the table. The script is failing as the dB is getting bigger and the query times out. Need someone to look at the script and find ways to optimize it. I will provide the script once I pick a winning bid.

Beceriler: CakePHP, PHP, SQL

Daha fazlasını gör: database cleanup script, website database, sql database website, sql based, Query optimization, database optimization, cron script, cleanup, table optimization, sql cleanup script, duplicate table, sql optimize, optimization database, cleanup script sql, script sql table, website sql database, query optimize, sql script cleanup, sql query field, php script database query, duplicate website script, optimize script, need someone duplicate website, cron sql query, sql database cleanup script

İşveren Hakkında:
( 29 değerlendirme ) MURPHY, United States

Proje NO: #743883

Bu iş için 14 freelancer ortalamada $55 teklif veriyor

Arenabpo

Hello, I can handle this kind of problem, thanks!

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(149 Değerlendirme)
7.6
HussienSharaf

HI, i m the best SQL and TSQL expert. Hussien Sharaf

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(14 Değerlendirme)
6.4
ruimaxwell

Hi. Please check PM. Thanks

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(48 Değerlendirme)
5.5
hotranan

Hi, Please check your inbox. Thanks

in %bids___i_period_sub_35% gün içinde80%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(5 Değerlendirme)
4.9
dataconsultants

Please check PMB for details, Thank you

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(27 Değerlendirme)
4.2
albariconsulting

please check PMB for details

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(2 Değerlendirme)
4.0
shibly27

Hi, I can do this work. please check my PM.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(5 Değerlendirme)
3.6
eyesee

Hi. Since I don't even have to write a line of query but correct an existing one I would even bid lower, but I can't. Award this to me, send me the details and you'll have your DB query corrected within the hour :)

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(7 Değerlendirme)
3.3
sabinantony

Hello, I am Professionally a Server Administrator having more than six years of experience in the same area, Also an Open source developer. I do manage both windows and Linux servers. In my professional career lif Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(10 Değerlendirme)
3.4
ashrafulni

I am expert on SQL Query. I am ready to start immediately

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(3 Değerlendirme)
3.2
ameerjafri

Please check your PMB.

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
3.0
lampgenious

Thanks.. Please check PMB

in %bids___i_period_sub_35% gün içinde30%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(11 Değerlendirme)
2.8
kishore2903

Have full exp. in database. Please provide the script and database details. So that I can fine tune it. Regards.

in %bids___i_period_sub_35% gün içinde100%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
0.0
armac

Over 20 years of SQL experience on may platforms. I can optimize your script quickly.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
freeradicals

Hi, I have got a lot of experience in query optimization techniques over the past few [login to view URL], I can help.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0