Blogs · @wyome
Tagged webdev · everything
Typicons is a free, open-source icon library distributed as a webfont that works across web and native applications, offering over 220 icons in both solid and outline styles. The project provides source files in SVG format and minified CSS on Github, allowing developers to either use the icons directly or customize them for their own needs. The webfont approach reduces HTTP requests while maintaining resolution independence and retina display support.
While Google's inclusion of page speed in search rankings has focused attention on file sizes and server settings, the actual assembly of pages on the server—particularly database queries in PHP or ASP—often receives overlooked scrutiny. This article provides practical methods to identify and eliminate database bottlenecks, from simple techniques like indexing frequently queried columns and using JOINs to combine multiple queries, to more advanced approaches like application-level caching and query optimization. The piece includes diagnostic tools, code examples for timing database performance, and explains when common optimization strategies like table optimization and MySQL caching actually help versus when they're ineffective.