On 02-10-2021 08:29, ldh@laurent-hasson.com wrote:
> Lots of code refactoring on our end, but it was worth it as the results are quite good with a ~70% improvement!
>
> The only gotcha is what I tried to also optimize the calls for indices, I was surprised that the jdbc method
DatabaseMetaData.getIndexInfo()doesn't take a table pattern like other "getXXXInfo" methods. For now we have decent
performance,so dropping to a custom query to optimize indices is something we can do later.
>
>
> pre-optimization
> ==========================================
> [..]
> Views: 362 in 22.00ms or 0.1%
> ------------------------------------------
> Total: 19,667.00ms
>
>
> post-optimization
> ==========================================
> [..]
> Views: 362 in 113.00ms or 1.9%
> ----------------------------------------------------------------------------
> Total: 5,809.00ms
I notice that you seem to be requesting views separately. You should be
able to do that in a single call to DatabaseMetaData.getTables together
with retrieving the tables.
Mark
--
Mark Rotteveel