Hello, I am thinking about hiring an experienced programmer to take my site www.GamesForWork.com and make all the popular calls to the mysql database cached. I do not know how large/small, cheap or expensive this type of request is. Right now, I am looking for an estimate, so I can get a feel if I should go a head with trying to get this done. If you try to visit the site, and you get a max connections error, try again with a refresh and it should come up. I don't know if I need to provide more details or if you can just take a look around the pages to get a feel for what I'm asking, but I am looking to get probably as much cached as possible to help ease the load of the constant calls to the mysql. If you're a programmer and would like to give me more of a quote of what you would be willing to do it for, you can PM me, but I'd appreciate a link to a portfolio or links to past work... hopefully that are similar to this job that we are requesting. I don't know if there our other ways or things "cached" can mean, but I mean I want it to write the data that is being called from the mysql database into files so it can just call the data from there. Then at my specified intervals it will update, or if I delete the file, it will auto recreate the cache file again. If there is a better way, I'm open to it, just anything to alleviate all the calls being made to the database without removing some of the websites features. Thanks for any interest you show in this.
Why cache MySQL queries while you can cache certain parts of your site... it's more easy and flexable to use.. and will load much faster! PM me if intrested!
would depend on what script you are using and how its setup. Caching, the front page with X per Category would make sense. it could/should operate off a timed schedule or on update if possible.
I can help you out. I have a caching method that would GREATLY improve the load times. just message me.
What hardware do you have? Caching requires a lot of memory, and if you're currently using most of it, it's unlikely to get any performance gains. Also, have you tried using a front-end caching system like APC (Assuming you're using php).
Good God. Still using PHP 4??? For best performance improvements you need someone to go through your code and look for inefficiencies. There are almost always parts that can be rewritten to put less demand on the server while accomplishing the same thing.
Is APC similar to eaccelerator? Would you want both installed on the same server? If I understand how eaccelerator works, it speeds up php. This isn't the same thing that APC does, is it?