Has anyone experienced this issue with railo? We have some queries that will take 3 minutes or more to run in railo on our application, but when running at the same time in the same database via the SQL Management Studio, in runs in less than a second. The query is a select statement. It's non-trivial, but still should run quickly - or at least with similar performance on the same database.
Could it be a driver issue? Does anyone know of any issues that might cause this, or have seen this before?
We are using:
OS: Linux 3.11.0-12 64bit
DB: Microsoft SQL Server 2014
DB driver: MSSQL - Microsoft SQL Server (Vendor Microsoft) - not sure the driver "version" whatever shipped with this release of railo.
This is a production environment (which, unfortunately, is the only environment where we see these issues) - so updating versions etc. is not something I can just do. Unless someone has found and solved this by a particular upgrade?