I've been revamping my Bolivian soccer blog, which I finally updated and made live tonight. In doing so, I needed to convert the data from ISO-8859-1 (back when I didn't know better about how to setup a database) to UTF-8. I was fearing the process would be complicated and tedious, involving some script to read the data and use PHP's mbstring or iconv extensions to do the work.
...click to continue reading.online database designer, pretty slick and you can download and host your own too
Wednesday, Aug 22, 2007 at 02:53 PM
given a query log, reports what indexes are not used
Tuesday, Apr 3, 2007 at 08:20 PM
This page and related pages describe various issues surrounding the Web 2.0 tagging and folksonomy concepts, including discussions on schema architecture, common data access patterns, and replication/scale-out guidelines.
Monday, Feb 19, 2007 at 03:56 PM
recommended by nyk
Friday, Jan 26, 2007 at 06:18 PM
One of the most basic optimizations is to design your tables to take as little space on the disk as possible. This can result in huge improvements because disk reads are faster, and smaller tables normally require less main memory while their contents are
Monday, Jan 22, 2007 at 05:41 PM
That's not exactly true. The prepared statement is stored in the database, and is therefor faster to execute next time. This means that the second time a page is rendered, it's not eating as much database CPU. Even in a different page, if it's the exact s
Tuesday, Nov 21, 2006 at 05:41 AM
