oracle maps with georaster themes, performance issue
Hi,
We are using oracle maps. The basic map consists georaster theme.
In map cache, tile size is 512 X 512.
Map size is 800 X 800.
To complete one request it takes 1 to 2 minutes.Tried different tile size like 256 X 256 , 1024 X 1024 but no improvement.
From logs it is clear that map client requests for more tiles then needed , like when tile size is 512 X 512 it requests around 30 tiles.
for each tile it takes around 20 seconds to fetch.
So it takes more then a minute to complete one request.
How the performance can be improved?