It is a very bad design that all string type datafields a defined as TEXT. This wastes a lot of space and performance. I would strongly recommend a review of the table definitions. I will come up with a more efficient suggestion within the next days. Hope it will make it into 2.7 final.
Hi Ulrich,
are you still up to work on it?