[<<][sql][>>][..]
Sat Mar 3 16:29:34 EST 2012

External processing

Considering the size of the tables, it might make sense to just split
them externally using regexps.  Or even to do this in the
preprocessing step directly.


mysql> select count(*) from req;
+----------+
| count(*) |
+----------+
|   354134 |
+----------+
1 row in set (0.00 sec)

mysql> select count(*) from ref;
+----------+
| count(*) |
+----------+
|    42338 |
+----------+
1 row in set (0.00 sec)

Anyways, I installed the PCRE wrapper for mysql and I find that the
next step is to weed out the pletora of hack attempts ;)

I found there are about 30 ways to request the same page, most of them
look like wordpress breakin attempts.



[Reply][About]
[<<][sql][>>][..]