Change introduced by #1016 create a big performance regression for databases with lots of metadata

[pdeliot]

The change introduced by #1016 in the sp_columns_100 call in public java.sql.ResultSet getColumns in

src/main/java/com/microsoft/sqlserver/jdbc/SQLServerDatabaseMetaData.java

is causing global dramatical performance to drop dramatically with databases with much metadata (nearly 500000 columns).

For example, in one database, with JDBC 7 the call during 6658 ms (with 6204 ms CPU load) and 14584 ms (with 13234 ms cpu load) using JDBC 8.

This may be caused by inaccurate use of table variable.
Table variable is supposed to be limited for 100 rows and here handling nearly 500000 rows.

It may also be evaluated to use the @fUsePattern=0 parameters like done for SQLServerParameterMetaData in this change:

Performance | Disabled pattern matching when using CallableStatements and SQLServerParameterMetaData
#1149

[ulvii]

Hi @pdeliot ,
Please provide a JAVA code that reproduces the performance degradation, we will investigate and get back to you.

[peterbae]

Hi @pdeliot, were you able to look into producing a repro case for this?

[ulvii]

Closing due to inactivity.