Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#69 Fixing problem with long running "getTypesInfo" on potgres.

snapshot
closed-accepted
nobody
None
5
2014-05-12
2014-05-10
Jjarmolowicz
No

Squirell uses getTypesInfo from JDBC connection Metadata. On Postgres databases this call can be slow on production servers where there are lots of installed modules/types (it does N + 1 queries where N is number of types that database supports).
Simple comparison
before:
DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Data types loaded in 66312 ms
after:
DEBUG net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaInfo - Data types loaded in 163 ms

User summary:
- Fixed performance when connecting to postgresql databases

1 Attachments

Discussion

  • Gerd Wagner
    Gerd Wagner
    2014-05-12

    • status: open --> closed-accepted
     
  • Gerd Wagner
    Gerd Wagner
    2014-05-12

    Is committed to our GIT repository.
    Will be available in future snapshots and versions.