Oracle Locator Performance vs. MYSQL (ORACLE LOOSES!!!!)
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);
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);
0