I use Geoserver with Oracle DB. Amount of records in DB is less than 4000, but feature request takes 5-6 seconds. How can I speed up this?
P.S. Native JAI is false in my Geoserver
I have view which joins two tables. int view sdo.geometry is polygon with 12 points.
when I open it from layer preview from there is takes from 5 to 6 seconds.
I removed view and joins and it works great. I had to copy columns from one table to another for reading directly from table all fields. If someone knows solution when using views or joins please share :)