GeoServer SQL Server – Understanding ‘Native JAI is False’ in GeoServer

geoserversql server

Below given is screen shot of GeoServer 2.13.0 installed on my machine.
Configuration of my machine is :
Intel(R) Core(TM) i7-3770 CPU @3.40 GHZ

Installed Memory 16.0 GB

OS Windows 10 64-bit

Geoserver on windows 10

I am displaying WMS layer using leaflet to draw tiles on map.Database is SQL SERVER 2016. The problem is that mostly rendering of tiles is slow on map. When I investigated further, I found that Native JAI and Native JAI ImageIO is false and this was required for good performance : Geoserver Running in production environment

When I tried "Installing native JAI on Windows" in the following link :
Installing native JAI on Windows few links were not working. When I download JAI and JAI ImageIO from the given link they were throwing error that JRE 1.4 must be installed. However , on my machine JRE 1.8 is installed. Check the screenshot given below.

enter image description here

Any suggestion?

Best Answer

The docs are old and native JAI is on the "way of the dodo", I believe in most of our installations we are not adding it anymore (mostly because it does not have some basic fixes present in jai-ext and won't handle NODATA).

It will help you on Windows under the following conditions:

  • Your slowness is on rendering raster data (not vector data sources from SQL Server)
  • You don't need NODATA support
  • You can run on 32bit binaries (native JAI is not available on 64 bits on Windows)
  • You're not hitting any known JAI bug

If instead you're mostly rendering vector data and the slowness is visible to the naked eye on light load, it's most likely a database query issue (maybe it's not using indexes, maybe you're just trying to render too much data, you did not provide enough context to tell). Suggestion, switch the logging level to GEOTOOLS_DEVELOPER_LOGGING and check what the queries are doing.

Related Question