import time
import sqlite3

conn = sqlite3.connect('/home/jan/.local/share/zeitgeist/activity.sqlite')
c = conn.cursor()

t = time.time()
rows = c.execute("SELECT timestamp, subj_text, subj_uri FROM event_view").fetchall()
print len(rows), time.time() - t