Database Administration (MOSC)

MOSC Banner

Oracle Locator Performance vs. MYSQL (ORACLE LOOSES!!!!)

edited Mar 25, 2009 8:38AM in Database Administration (MOSC) 3 commentsAnswered
 Oracle Locator Performance vs. MYSQL
I am curious - what I am seeing when I compare apples to apples with spatial seraches
using MYSQL database vs Oracle 11g "Locator" - MySQL beats oracle in a big way!

Does anybody have any data to dispell this?  I am using simple 4 point polygons. I am doing a simple search for all polygons that CONTAIN the point that was clicked.

MY METADATA Entry is as follows -
insert into USER_SDO_GEOM_METADATA VALUES('OREGON','image_map',
MDSYS.SDO_DIM_ARRAY(  -- 20x20 grid,
MDSYS.SDO_DIM_ELEMENT('X', -360.0, 360.0, 0.1),
MDSYS.SDO_DIM_ELEMENT('Y', -180.0, 180.0, 0.1)),8307);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center