Menu

SchemaSpy takes entire month to analyze DB

Help
2015-11-13
2019-08-02
  • Milos Milosavljevic

    I am trying to draw ERD for Adempiere 380 backend PostgreSQL base, that has 843 tables. However it took 60 hours for my laptop to draw only 32 of them. How do I speed this up? I need it in a couple of days max.
    I do not need 2nd degree of separation, but i do not know how to turn this feature off. It should lessen the time needed a lot.
    This is how I ran SchemaSpy:

    java -jar schemaSpy.jar -t pgsql -db adempiere -host localhost -port 8443 -u adempiere -p adempiere -o /home/asus/Downloads -dp /home/asus/Downloads/postgresql-8.4-703.jdbc3.jar
    

    My laptop is Asus X401A, 4GB RAM, integrated graphics, dual core Intel 1.7GHz CPU, three years old, running Ubuntu 14.04. I am willing to get a new one, but what performance is needed for it to be for example finished in 60 hours? How do I know it is slow hardware, not the underlying software that makes it so slow? Is adding horsepower going to help enough?

     

    Last edit: Milos Milosavljevic 2015-11-13
  • K Mishra

    K Mishra - 2019-08-02

    Please use the below parameter:
    [-noimplied] Don’t look for implied relationships.
    Full list of params here.

     

    Last edit: K Mishra 2019-08-02

Log in to post a comment.