-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-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
