Posted by peter
So it looks like these days Kickfire welcomed everyone to tell they’ve been working with Kickfire - Baron Keith Frank is writing about KickFire. Good Job Kickfire PR team you really energized community.
We also were working with Kickfire for quite a while and are also very excited to give it a try.
[read more...]
Posted by peter
We have an application which stores massive amount of urls. To save on indexes instead of using URL we index CRC32 of the URL which allows to find matching urls quickly. There is a bit of chance there would be some false positives but these are filtered out after reading the data so it works all pretty well.
If we just process urls one by one it works great:
SQL:
-
mysql> EXPLAIN SELECT url FROM 124pages.124pages WHERE url_crc=484036220 AND url="http://www.dell.com/";
-
+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+
-
| id | select_type | TABLE | type | possible_keys | KEY | key_len | ref | rows | Extra |
-
+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+
-
| 1 | SIMPLE | 124pages | ref | url_crc | url_crc | 4 | const | 1 | USING WHERE |
-
+----+-------------+----------+------+---------------+---------+---------+-------+------+-------------+
-
1 row IN SET (0.02 sec)
[read more...]
del.icio.us
digg