Skip to main content
Solved

Loading Time: Migration of Oracle Spatial to SQL Server

  • August 28, 2018
  • 1 reply
  • 22 views

Hi, we are migrating mapguide gis using oracle spatial to esri arcgis using sql server. I would like to check if there is a benchmark that can be used as a reference to compute for the loading time?

IS there a rule of thumb in terms of number of features, data size?

Thank You.

Best answer by markatsafe

We do not have benchmarks on data loading performance as there a so many factors at play - network performance, database performance, what processing you doing in FME, etc. The best thing to do is run a test dataset and see what that looks like in your environment.

We do have some knowledge articles that might help you tune your FME performance:

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

Forum|alt.badge.img+2
  • Best Answer
  • August 29, 2018

We do not have benchmarks on data loading performance as there a so many factors at play - network performance, database performance, what processing you doing in FME, etc. The best thing to do is run a test dataset and see what that looks like in your environment.

We do have some knowledge articles that might help you tune your FME performance: