Is the Oracle database is faster than SQL database?
I have a performance issue in my web mapping application and wanted to investigate multiple factors that might affect the speed:
�?� Hardware specs of the host and client machines (CPU and RAM)
�?� Cables connecting host and client machines (vpn, leased lines, etc.)
�?� ArcGIS server Tuning (min/max instances, high/low isolation, cashing, etc)
�?� Database (personal geodatabase/file geodatabase/ ArcSDE geodatabase with SQL or Oracle, etc.)
�?� Web mapping application (ADF, Silverlight, Flex)
In this thread just I wanted to know if there might a definite answer whether the Oracle database is much faster than the SQL. For the time being, I�??m using SQL server database and I�??m struggling with the performance issue as the source data for the URLs used in the web mapping applications is the SQL server database
Thank you
Best
Jamal