apply tiedot indexes instead of full scan. Got between a 2x - 12x speed improvement on queries.