View Single Post
  #93   Spotlight this post!  
Unread 07-12-2013, 18:01
1306scouting 1306scouting is offline
Registered User
FRC #1306 (BadgerB.O.T.S.)
Team Role: Scout
 
Join Date: Apr 2012
Rookie Year: 2004
Location: Madison, WI
Posts: 24
1306scouting is on a distinguished road
Re: A New Way to Scout

Quote:
Originally Posted by yash101 View Post
I forgot to show the details running as root. This has a greater view of what is sipping up the RAM. Here are some more details (in the screenshot). I never work on optimizing the RAM! If you want, I can give you a list of all the packages installed on the Pi! That might give you a bit of info on where everything is going! Also, what processor do you have? My Windows 2000 machine is about as powerful as my Pi, maybe even more. The only problem is that it has only 256 MB of RAM! Do you use SWAP? That might help ease the RAM usage of the system!

I, myself, dislike caching because it is hard to make sure it is updated! For the good loading speeds, I use the accelerator, APC. It doesn't cache the HTML. It caches the code to make PHP execute faster. I use the WordPress plugin, QuickCache to cache the HTML. Since it is based on WP, it will automatically update when I add/change/remove content!
That looks quite nice. Since I have a reasonable amount of RAM (1.5GB, low for a server but it works) I don't worry about it too much. It's running a 2.4 GHz Pentium 4 from about 2002 or 2003, which is why the CPU is the bottleneck.

Caching shouldn't be problematic; I'd recommend Varnish (which I would use if I served more static resources) if you haven't looked at it (though if QuickCache works well you may as well stick with it for WP). It can be annoying to set up but works really well. I also use APC, though I'll switch to the built-in opcache when I start using PHP 5.5.


To return to your earlier question, I think you'd best be served by a single MySQL database if you're on a Pi (though I'd recommend you check out the alternatives to MySQL too in case there are ones with better optimization.) I don't see a good reason to use multiple MySQL-style databases, and file-based databases have few advantages except simplicity.