Faq

Q: GUI is too slow to be useful

A: Two things can severely slow down reponsiveness of the application.

The first is missing or wrong indexes on the databases.

Try to add indices like this:

echo "create index ix_src_addr on q (src_addr); \
create index domain on q (rr_lvl2dom,rr_lvl1dom); \
create index ix_rr_type on q (rr_type); \
create index if not exists resanddomandtype on q (rr_cname,src_addr,rr_type);" | sqlite3 $database

The second is if the user running the webserver has write access to reversedb.db3 which stores previous DNS-lookups. The PDO_sqlite requires write access to both the file and the catalogue holding the file.