D-talk (Entries tagged as optimizing)

MySQL 5 optimizing

nospam@example.com (Mark van der Velden) — Tue, 09 Oct 2007 11:20:18 +0200

Optimizing MySQL always has been a hot topic for many developers and DBA's. I always took a lot for granted and never really bothered with optimizing MySQL other then trying to make the best query's I could. Over the years I've learned a lot more about MySQL and so my journey went into trying to optimize my MySQL server(s). After a lot of trial and error on development machines, it's time for the real deal The first thing to do is use your favorite search engine and learn the basics, you'll mostly find these phrases: 'good queries', key_buffer_size (or key_buffer), Key_read_requests and Key_reads and memory.

I'm going to talk mostly about MySQL 5 and MySQL 5.1 database tuning. The basics apply to all version but in 5 and 5.1 there are additional parameters not available in previous versions. I'm asuming you are familair with terms as: web servers, indexes, MyISAM, InnoDB, tables, databases, Linux file system (most I talk about applies to windows builds also)

Continue reading "MySQL 5 optimizing"

SEO - shared hosting or dedicated hosting

nospam@example.com (Mark van der Velden) — Wed, 29 Aug 2007 19:20:00 +0200

There is much talk going on about it, name based hosting should score more negative in google then dedicated hosted websites. The opinions are spread, both sides have good arguments but the side that says "it's mostly bogus" I agree with. Your site CAN have a more negative ranking then a dedicated one if the IP you host on get's shitlisted. Meaning...
Continue reading "SEO - shared hosting or dedicated hosting"

String length vs isset to check string length's

nospam@example.com (Mark van der Velden) — Tue, 07 Aug 2007 13:47:00 +0200

A while ago I've had a discussion about the optimal way to determine a string length in PHP. The obvious way is to use strlen()

$str = 'This is a string'; echo strlen($str); // 16

However to check the length of a minimal requirement it's actually not that optimal to use strlen. The following is actually much faster (roughly 5 times)

Continue reading "String length vs isset to check string length's"