Hi Peoples,
Is it possible to use FME to export data in Spatial Index Order. This would be similar to the command line tool that esri had in the past, but no longer supplied.
In trials I have done in the past, if the data can be read in spatial index order, then piped back to the write in spatial index order - the performance can be increased in ArcSDE by about 30%.
Why you may ask?
The result is similar to Morten Sequencing, where the data that is spatial close in the real world is then physically close on disk. This means fewer read/write access, fewer blocks of memory to manage and thus vastly improved performance. I have talked with Cary Millsap (author of Optimizing Oracle Performance) about this very matter. Turns out this is one way Oracle users have used in the past to optimize performance as well with non spatial data - for example if your process access data in alphabetical order, then if you store your data in alphabetical order you get performance improvement.
Cheers,
Mark