-----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
