Re: JDBC Meta-data performance for Foreign Keys

On 02-10-2021 08:29, ldh(at)laurent-hasson(dot)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