A simple change in script, to make it run faster…

Excellent !!! I just have to adjust it to make it run faster…

Here is how:
{code}
#ORIG:
log_message = log_message.rstrip(” “)
#MKOCO addon to message
log_message = log_message.split(“:”)[1]

self.vprint(2, “extracted log message body from log”)
self.vprint(2, “log message is ‘%s'” % log_message)

# security is maintained by a combinarion of “ and restrictive
# regex validation the validate functions. MySQLdb must take care of
# the log value but this is not an input variable anyway.
#ORIGsql#query = “select count(*) from `%s` where `%s` LIKE %%s”
# % (self.mysql_table, self.mysql_column)
#MKOCO
query = “select count(*) from ( SELECT * FROM ( select * from `%s` ORDER BY seq DESC LIMIT 10000 )
sub ORDER BY seq ASC ) as xxx1
where xxx1.`%s` LIKE %%s”
% (self.mysql_table, self.mysql_column)
{code}

If you update your release, you can freely add it…