puRe – FL3X – Marcel Oelke

Excuse me, I could not find a better name for this blog.
Currently dealing with: Project Voldemort, Redis, RabbitMQ glued together using Java. The vector clock versioning scheme of voldemort drives nuts!
 

Archive for October, 2005

posted in 26 Oct, 2005 by Marcel Oelke  

Materialized Views in MySQL

Update: Dynamic Materialized Views
Please read this article also. Its an improved versio of the technique described below.
Today i found a workaround for a feature that was realy missing in MySQL.
Let’s say you got a really complicated query that requires a lot of cpu and time to complete, but the resulting data is quite static. That’s [...]

posted in 26 Oct, 2005 by Marcel Oelke  

2,007,161 md5 strings

Today i took a look at my md5 site and found out that i (we) broke the 2 million barrier. The database has now 2,007,161 md5 strings with their counter part stored. 222,101 queries where run against the database till now. The size of the database has grown to 320 MB on the [...]