Markus,
>> But for another small speedup skip indexing to cdx and instead use an old compressed idx.
>
>I tried INDEX ON...TO (idx_file) COMPACT UNIQUE. While theoretically this could be faster the difference is not measurable.

I bet it is measurable even on your machine. BUT you have to run always on a freshly formated partition and use higer resolution timers.

thomas