Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 6 of 6
  1. #1
    New to the CF scene
    Join Date
    Mar 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    help needed urgently

    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
    Last edited by chery; 03-26-2005 at 06:31 AM.

  • #2
    New Coder
    Join Date
    Mar 2005
    Location
    Trenton, NJ
    Posts
    20
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I would be interested to help you. But I will need to know a few more details before I committ.

    Please contact me at Ed@HandGems.com or call me at (Ed) 609-585-4735 or AIM=HandGems

    Thanks.

  • #3
    New to the CF scene
    Join Date
    Feb 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hello,
    I sent you a PM. Looking forward to hear from you.
    Last edited by johnnyb2003; 03-26-2005 at 03:47 PM.

  • #4
    New to the CF scene
    Join Date
    Mar 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The guy who looked at my script thinks that it will need to be rewritten from scratch and more likely database structure as well because it takes too many queries to do something so I was thinking that if I bought a new script instead would it be possible to transfer the info from the original dbs to the new ones?

  • #5
    New to the CF scene
    Join Date
    Feb 2005
    Posts
    9
    Thanks
    0
    Thanked 0 Times in 0 Posts
    The data can be transfered to the new db. PM for more info.

  • #6
    New to the CF scene
    Join Date
    Mar 2005
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by johnnyb2003
    The data can be transfered to the new db. PM for more info.
    What I would really prefer would be to have my script and databases fixed though because what whatever script I bought would probably have the same problems eventually as we have a member base of over 6,000 members surfing.
    I also have a few mods that I'd like done as well.


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •