On Thu, Jul 30, 2015 at 7:56 PM, Martin Davis <[email protected]> wrote:
> We have the following GeoServer setup: > > Datastore to an Oracle 12c Exadata instance > Internal connection pooling > No schema specified > What GEoServer version? > > We noticed a serious performance anomaly, where each layer was taking > about 4 s to render, even when the data was very small. > > When we switched to specifying an explicit schema in the Datastore config, > the performance got significantly faster, and the time to render individual > layers became more proportional to the query result size. > > So the questions are: > 1. does omitting a schema name in the Oracle Datastore config cause > connection pooling to be disabled or defeated? > While I cannot ensure I won't be hit by an asteroid in the next hour, that's unlikely. So is the idea that not setting up the catalog can break connection pooling. It will likely slow down things for other reasons unrelated to connection pooling instead. Oracle is a database from hell, if you don't setup the catalog the jdbc driver returns a huge number of tables (50k on some installations?) when you get the database metadata. We had issues with caching metadata at the content data store level, with the Oracle dialect not using prepared statements for metadata (pull request still open, I'm unable to find the time to review it, see here: https://github.com/geotools/geotools/pull/905), and likely something else that I don't remember. I would suggest to try trunk, with the above pull request applied, and see if it gets any better. > 2. Will this issue be avoided when using a JNDI connection pool? > Not directly, but with JNDI you can setup a single connection pool and then setup N datastores, one for each of the catalogs you need to access. Investigations and patches welcomed too, we have a large disconnect between people using and complaining about Oracle and people actually doing something about it. The common wisdom is to just drop Oracle in favor of PostGIS, when one can (yes, I'm well aware that's often not an option). Cheers Andrea -- == GeoServer Professional Services from the experts! Visit http://goo.gl/it488V for more information. == Ing. Andrea Aime @geowolf Technical Lead GeoSolutions S.A.S. Via Poggio alle Viti 1187 55054 Massarosa (LU) Italy phone: +39 0584 962313 fax: +39 0584 1660272 mob: +39 339 8844549 http://www.geo-solutions.it http://twitter.com/geosolutions_it *AVVERTENZE AI SENSI DEL D.Lgs. 196/2003* Le informazioni contenute in questo messaggio di posta elettronica e/o nel/i file/s allegato/i sono da considerarsi strettamente riservate. Il loro utilizzo è consentito esclusivamente al destinatario del messaggio, per le finalità indicate nel messaggio stesso. Qualora riceviate questo messaggio senza esserne il destinatario, Vi preghiamo cortesemente di darcene notizia via e-mail e di procedere alla distruzione del messaggio stesso, cancellandolo dal Vostro sistema. Conservare il messaggio stesso, divulgarlo anche in parte, distribuirlo ad altri soggetti, copiarlo, od utilizzarlo per finalità diverse, costituisce comportamento contrario ai principi dettati dal D.Lgs. 196/2003. The information in this message and/or attachments, is intended solely for the attention and use of the named addressee(s) and may be confidential or proprietary in nature or covered by the provisions of privacy act (Legislative Decree June, 30 2003, no.196 - Italy's New Data Protection Code).Any use not in accord with its purpose, any disclosure, reproduction, copying, distribution, or either dissemination, either whole or partial, is strictly forbidden except previous formal approval of the named addressee(s). If you are not the intended recipient, please contact immediately the sender by telephone, fax or e-mail and delete the information in this message that has been received in error. The sender does not give any warranty or accept liability as the content, accuracy or completeness of sent messages and accepts no responsibility for changes made after they were sent or for other risks which arise as a result of e-mail transmission, viruses, etc. -------------------------------------------------------
------------------------------------------------------------------------------
_______________________________________________ Geoserver-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geoserver-users
