Kangry.com [insert cool graphic here]
home | Topics | Logout | Search | Contact | ?? Kangry ?? | Bandwitdh
Topics:
DVR
nvrec
Mplayer
Links
Misc
Commands
Humor

Name

Password

New user

uploaded files
(links)-> (Parent)->sql news and links submited by Russell Fri 13 Jan 06
Edited Thu 04 May 06
Web kangry.com
Gov't GSA Office goes MySQL
Ten of the Biggest Mistakes Developers Make With Databases

Simple Optimization for PHP and MySQL These all make sence, but besides using indexes and generaly not putting stuff in the DB that doesn't need to be, these arn't earth shattering improvments. I don't think that a site that had these problems would go from unable to handle 1000's of hits per second to being able to.

I know this sloppy little site could never handle a digg/slash dotting. The simplest requests hit the database like 4 times. Perhaps I should build a cache. so that full rendered pages were stored in the DB and those were only updated when the data is updated. But it's Soooo not wort it for the level of traffic I currently have




Add comment or question...:
Subject:
Submited by: NOT email address. Leave blank for anonymous    (Spam Policy)

Enter Text: (text must match image for posting)




This file (the script that presented the data, not the data itself) , last modified Wednesday 03rd of December 2014 09:40:39 AM
your client: CCBot/2.0 (http://commoncrawl.org/faq/)
current time: Tuesday 25th of April 2017 04:28:37 AM