tomcat-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Christopher Schultz <ch...@christopherschultz.net>
Subject Re: Tuning parameters in APR/Standard connectors
Date Thu, 27 Sep 2018 12:16:00 GMT
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

M,

On 9/27/18 05:30, M. Manna wrote:
> Hello,
> 
> We have a some SQL statements (Insert, Update) which comes to a few
> MBs in size. We are currently using APR 1.2.16. What we observed
> that sometimes, the connection hangs out because of extremely large
> SQL text blocks being sent to SQL Server.
> 
> Is there any parameter in APR or Standard Connectors that we can
> tweak to monitor the performance?
You want to monitor the performance, or improve it?

Tomcat has nothing to do with the size of your SQL queries themselves
(multi-megabyte *queries* or results?! Seems huge for a query).

The connectors only move data from the client into the application and
back. The database connection is managed by the driver and the db server
.

Hope that helps,
- -chris
-----BEGIN PGP SIGNATURE-----
Comment: Using GnuPG with Thunderbird - https://www.enigmail.net/

iQIzBAEBCAAdFiEEMmKgYcQvxMe7tcJcHPApP6U8pFgFAlusygAACgkQHPApP6U8
pFi0exAAk2xSSyhGCI8zzLDmFZnpxkdx46dD7vpaE1sniVoHjm71FrnGGMGmQ+My
0yY1a4uCGLiWaSRy/0xACdNShwFkKq16fIIHdvbaY12T3LydxZNS4wU3nLAdghlv
RugkEOc46gA/MzuLxSNJ2N1dHI0+lxg+Uj1ThlDAtDvWjAUZwjMAf6Czz8xL+iO3
0aYy/MjeO9zMP0IECJaefW6D6zMhFxC5ALoAyXyaSglh3me/ee9dKZ3l2AIKzDI1
N5ZFYnYdAEBhrri6up8fqL3yJTV0PZY2YyiqXJIQQuA4Of/ec7Ck8H5SEjs4sjhl
RPxD9m6bDN3srOZ50s5s3eokTjlBaCF3Lp3yf+VaFdxV7+UKYenBvYzA6Ifk3k5u
GV6POJzYLEgrFn5mgDiKvQZfc+6PCK3qgEXVwf2YDhqV5shGYLKupeJaie4LtrF8
dXTNdlMp7WTcTa+u0f4K96OcYQBzVxi3H4hn5VPM3VS2iyPC4FCXPuRUbYJr6dh9
vJg+Vt80UI0e830fg0DLtnyGIG7TZVRibJwlSRFx1Jl8PNRLPXg+GG3cnBLcFoTu
9nYoTUvgUPeoLZPIbzN5WHgciaIbEMwVqWjBLgtnAhn3fDGP6cfi1wllMCy9T/vH
Uk5zka9ivCxpVlQ37CW43CLTekYpG7ZEBTqfUB+KPD6df0gFNB0=
=YJom
-----END PGP SIGNATURE-----

---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org


Mime
View raw message