Em Andamento

fix an internet app (MAX BID $50)

I have an internet application which was made for me (attached). It collects tweets from twitter. My internet provider turned it off because it was using too many resources -using the database too frequently (They said MySQL Overload).

They also said

queries are locking each other causing huge mysql server overload.

Query examples:

1030 C261605_willie2 [url removed, login to view] C261605_geoTwitter Query 41 Locked DELETE FROM `tweets`\nWHERE `time` < 1261379170

1029 C261605_willie2 [url removed, login to view] C261605_geoTwitter Query 41 updating DELETE FROM `tweets`\nWHERE `time` < 1261379170

395 C261605_willie2 [url removed, login to view] C261605_geoTwitter Query 38 Locked INSERT INTO `tweets` (`time`, `user`, `location`, `msg`) VALUES (1261379233, 'EtienneSlight', 'North London', 'I DONT WASTE TIME WITH CHAT UP LINES , JUST LOOK IN HER EYES AND READ THE SIGNS')

I want to change the rate at which it collects tweets or writes to the database but I cannot follow the code that was written.

It is not a big application I don't think.

If you can do this please let me know.

Habilidades: AJAX, PHP, SQL, Twitter

Ver mais: internet code, code internet, chat application php mysql, bid examples, rate app, my bid, msg, look max, location app, internet provider, internet php, follow app, fix mysql query, fix database, code app, attached app, app database, app chat, internet fix, written code examples, app follow, fix query, twitter follow app, php follow twitter, time app

Acerca do Empregador:
( 53 comentários ) Beppu shi, Japan

ID do Projeto: #591198

Premiar a:

CoVaLiDiTy

can help you. tnx.

$40 USD em 0 dias
(251 Avaliações)
6.9

15 freelancers estão ofertando em média $53 para este trabalho

TechVillage

Please check PM.

$75 USD in 5 dias
(92 Comentários)
6.8
jeevanoss

Pls see the PMB

$50 USD em 1 dia
(37 Comentários)
6.1
MAST3R

You have PM

$80 USD in 0 dias
(10 Comentários)
5.5
crajeshbe

Hi Good day, Expert in PHP, Mysql Bug fixing. Ready to start the work. Regards C.Rajesh B.E

$40 USD in 0 dias
(41 Comentários)
5.4
getndone

Plz check PM

$50 USD in 5 dias
(36 Comentários)
5.2
Sarvodaya

I am Jitender from Sarvodaya Institute of Software, Delhi NCR, India (www.sisoft.in). We are a team of highly skilled professionals including project managers, domain experts, designers, analyst programmers and quality Mais

$50 USD in 2 dias
(12 Comentários)
5.0
phpquick

Please check PM

$35 USD in 3 dias
(10 Comentários)
3.8
sat12345

Plz check PMB...

$70 USD em 1 dia
(51 Comentários)
3.9
kcmakwana

sir, I can help you to fix , see inboX please

$38 USD in 0 dias
(7 Comentários)
3.3
manojhardwani

I already have solution created for you please check PM. Please check Project Clarification Board Messages. Have attached file to integrate within the application.

$30 USD em 1 dia
(0 Comentários)
0.0
zubairassam

Hi, Kindly chek PMB Microx

$75 USD in 7 dias
(0 Comentários)
0.0
avialex85

We have 5 years of extensive experience in web programming, web designing, web2applications, Rich web based application. We worked on all major CMS, Custom Script Installation, Shopping cart portals and interactive lea Mais

$70 USD in 5 dias
(0 Comentários)
0.0
ducrz

Solve the problem of code and we can study some options like apache tuning to improve your server, do you think?

$50 USD in 2 dias
(0 Comentários)
0.0
lifeeth

Will be able to fix the rate and reduce the load

$40 USD in 2 dias
(0 Comentários)
0.0
klpsoftware

Instead of writing direct queries using mysqli, your coder elected to use the "CodeIgniter" framework. That means he got a lot of extra "functionality" like transactional(Locked) deletes instead of regular deletes. Mais

$40 USD in 5 dias
(0 Comentários)
0.0