I run a simple "select count(*) from mytable", but it is quite slow. sqlite3 database.

If I do it with sqlitestudio 3.3.3 I get the answer instantaneous. 264000 records.

With unidac it takes 6 secs, when I set unidirectional = false or it is much worse with true.

Setting it to readonly=true/false or Direct=true/false, seems to make almost no difference.

All files are local.

How can I get the result immediately?