Odd. We've done something similar with a self-written index file (for radix tree search). We used the temp space as well, without issue.
We never did use it in the cloud (only local and on an on-premise Pivotal CF), but I see no reason why it shouldn't work in the Mendix cloud as well...
I take it your local tests are all fine?