WbSchemaDiff slow

[Mordechai Danielov]

Hi Everyone, 

Is there anything I can do to make WbSchemaDiff faster? It took 10 min to compare just a handful of table, and 35 minutes to compare 190 tables. TIA.

Mordechai

[Thomas Kellerer]

WbSchemaDiff does a lot of requests to gather all needed information. In theory, this could be done with fewer more complicated SQL queries, but that would mean I have to re-implement the whole JDBC API manually for each and every supported database.

I don't know which DBMS system you are using, but this is especially true for Oracle where access to the system tables and views is quite slow anyway.

As WbSchemaDiff should only be used in exceptional circumstances, I don't see a big problem in it being a bit slow.

> --
> You received this message because you are subscribed to the Google Groups "SQL Workbench/J - DBMS independent SQL tool" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to sql-workbenc...@googlegroups.com <mailto:sql-workbenc...@googlegroups.com>.
> To view this discussion on the web visit https://groups.google.com/d/msgid/sql-workbench/1b98a471-61d5-4e7f-8ee5-8358fa98295en%40googlegroups.com <https://groups.google.com/d/msgid/sql-workbench/1b98a471-61d5-4e7f-8ee5-8358fa98295en%40googlegroups.com?utm_medium=email&utm_source=footer>.