Select to view content in your preferred language

Is the Oracle database is faster than SQL database?

4324
10
06-04-2013 08:51 AM
JamalNUMAN
Legendary Contributor
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
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos
10 Replies
JamalNUMAN
Legendary Contributor
Different sports cars may take a winding mountain road in slightly different times, but a
tractor-trailer won't ever give them competition.  Still, the sports cars aren't going to
score well on the basis of tons of food delivered.  As a technologist, you need to learn
how to gauge the similarities and differences of competing software packages, and use
that as feedback into generating unbiased evaluation criteria.

- V


Many thanks Vince. I do agree.

Best

Jamal
----------------------------------------
Jamal Numan
Geomolg Geoportal for Spatial Information
Ramallah, West Bank, Palestine
0 Kudos