Re: JDBC Meta-data performance for Foreign Keys

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