nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is the Oracle database is faster than SQL database?

JamalNUMAN

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

Find more posts tagged with

Accepted answers

All comments

JamalNUMAN

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

VinceAngelo

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

JamalNUMAN

A bicycle is still going to be faster going six blocks in Manhattan at noon than
an airplane. The task is identifying the proper vehicle for the purpose, which
is why the question has validity issues.

- V

Thanks Vince,

The reason behind this thread is that I got that generally the Silverlight and Flex are much faster than the ADF and wanted to know if that is true.

I think I got the answer! That�??s not necessarily true!

Best

Jamal

VinceAngelo

A bicycle is still going to be faster going six blocks in Manhattan at noon than
an airplane. The task is identifying the proper vehicle for the purpose, which
is why the question has validity issues.

- V

JamalNUMAN

Is a Ford faster than a Buick?

Thanks Joe,

Which is much faster a bike/train/aircraft (being all are methods of transportation)?

Best

Jamal

LeoDonahue

Is a Ford faster than a Buick?

Oh, and I forgot. Are either of those modifed for performance in any way?

LeoDonahue

I'm confused. Which one of those vehicle models is the SQL Server and which is the Oracle?

JoeBorgione

Is a Ford faster than a Buick?

JamalNUMAN

No, there will NOT be a definite answer to this question (which is flawed by failure
to name products correctly).

In my experience, most RDBMS packages perform pretty much equally on the
same physical hardware, with experience and skill in tuning and administration
providing as much as a 20% swing in response characteristics.

If you research the literature, you'll find that unidimensional evaluation for any
software product, much less something as complex as database software, is
least likely to produce satisfactory results.

- V

Many thanks Vince. This is what I wanted to know.

It was great also when I knew that the file geodatabase is much faster than the ArcSDE goedatabase

Best

Jamal

VinceAngelo

No, there will NOT be a definite answer to this question (which is flawed by failure
to name products correctly).

In my experience, most RDBMS packages perform pretty much equally on the
same physical hardware, with experience and skill in tuning and administration
providing as much as a 20% swing in response characteristics.

If you research the literature, you'll find that unidimensional evaluation for any
software product, much less something as complex as database software, is
least likely to produce satisfactory results.

- V

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.