chery
03-26-2005, 06:28 AM
I was wondering whether you can help me I am getting quite desperate as
no-one seems to be able to fix my autosurfer.
I REALLY need help now.
I run an autosurfer and the site is running slower and slower because of the
db query backlog.
The surf bar is constantly updating MySQL. Every 20 seconds it updates the
credits to the surfers account.
I need someone to design a new implementation of the surfbar and perhaps
change some of the databases to have a little more 'intelligence' to cut
down on the constant queries. We are running on a dual xeon processor but we overload it for several hours per day as the backlog increases. At other
times it runs like a dream
I need someone to start weeding out extra queries that really don't need to
be there. Perhaps the query for surfed pages from the surfbar should never
update until they actually finish surfing. At that time, the query should
run to update the database. So instead of a query every 1 page hit, we have
one database query. Or perhaps update the db every 30 sites or something.
That is the sort of thing would make a huge difference to my site.
The main culprit seems to be the 7statsite db.
Please if you think you can help me please contact me ASAP
I am not asking for charity I will pay I'm just not sure how much work would be involved
thanks,
chery
no-one seems to be able to fix my autosurfer.
I REALLY need help now.
I run an autosurfer and the site is running slower and slower because of the
db query backlog.
The surf bar is constantly updating MySQL. Every 20 seconds it updates the
credits to the surfers account.
I need someone to design a new implementation of the surfbar and perhaps
change some of the databases to have a little more 'intelligence' to cut
down on the constant queries. We are running on a dual xeon processor but we overload it for several hours per day as the backlog increases. At other
times it runs like a dream
I need someone to start weeding out extra queries that really don't need to
be there. Perhaps the query for surfed pages from the surfbar should never
update until they actually finish surfing. At that time, the query should
run to update the database. So instead of a query every 1 page hit, we have
one database query. Or perhaps update the db every 30 sites or something.
That is the sort of thing would make a huge difference to my site.
The main culprit seems to be the 7statsite db.
Please if you think you can help me please contact me ASAP
I am not asking for charity I will pay I'm just not sure how much work would be involved
thanks,
chery