How to pre-caching data for best performance?

Jul 22, 2008 at 7:39 PM
hi

I have a site with a data obtain from Oracle, but the data and render is very slow, How I pre-caching the data for fast response like Mapserver. I have some data (arount 500,000 poligons) and is very slow consulting or drawn this.

Any have good techics? I have Spatial Index but is slow too, I have Hi Perf. Machine.

regards.
Jul 24, 2008 at 9:00 PM
any? the problem is when convert sdo_geometry to wkb, this process use most time. I write a second column in oracle with wkb and wkt but can't use this with the same conector. Please help.