Closed ylyxf closed 1 year ago
wise-coders
commented
2 years ago This is an interesting idea. We have in plan to add multi-model projects, each model with its connections. Then this will be possible. Is a matter of time to get it done.
Best regards, Dragos Pruteanu
brettshearer
commented
2 years ago I would be interested in being able to split a model simply to reduce the size of the generated dbs file. Mine is currently 16MB and I'm looking to move to DBschema due to the performance of the previous CASE tool I used. Would prefer to split the model up (yet still eventually deploy it monolithically for now). This introduces virtual foreign keys which would actually be real foreign keys in the production database.
wise-coders
commented
2 years ago Please let us know which operations are slow right now. Maybe we can focus and improve this first, and let DbSchema as it is. A short video would help. Also reducing the number of layouts could help.
Which database are you using? If the database supports virtual foreign keys, we can also add this option to the FK options, so you can create the virtual foreign keys in the database. Please send me a sample SQL command to create the virtual fk in the database.
Best regards, Dragos Pruteanu
brettshearer
commented
2 years ago I don’t believe I’ve reported any slowness – everything is actually really fast and I impressed with the overall speed of all functions.
From: Wise Coders @.> Sent: Monday, 24 January, 2022 5:54 PM To: wise-coders/dbschema @.> Cc: Brett Shearer @.>; Comment @.> Subject: Re: [wise-coders/dbschema] Can DbSchema Support Foreign Table or 'Connection Group' (Issue #58)
⚠ CAUTION: This email originated from outside of the organisation. Do not click on links or open attachments in emails unless you are sure it is from a trusted sender and was expected.
Please let us know which operations are slow right now. Maybe we can focus and improve this first, and let DbSchema as it is. A short video would help. Also reducing the number of layouts could help.
Which database are you using? If the database supports virtual foreign keys, we can also add this option to the FK options, so you can create the virtual foreign keys in the database. Please send me a sample SQL command to create the virtual fk in the database.
Best regards, Dragos Pruteanu
— Reply to this email directly, view it on GitHubhttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2F%2Fgithub.com%2Fwise-coders%2Fdbschema%2Fissues%2F58*issuecomment-1019774494__%3BIw!!Na5NE8kfbMIR6Ys!4IFGKKAn-N4BcCGZqTBh62J0U1_9zPNZ-uaaSNQ0cR6LslCC3KqauiSW-U-KrtnJHjEu5Zn5%24&data=04%7C01%7Cbrett.shearer%40wisetechglobal.com%7C2eb43ce155cc4cb0fa2b08d9df065f30%7C8b493985e1b44b95ade698acafdbdb01%7C0%7C0%7C637786040737453760%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=U1Sezz3NPpYM6jpMAflvZhal6Vmk4MLt5kuWPZyIfYY%3D&reserved=0, or unsubscribehttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FACE76TQ5DUIRYZ5UZOUJ7FDUXTZSHANCNFSM5LGVWQQQ__%3B!!Na5NE8kfbMIR6Ys!4IFGKKAn-N4BcCGZqTBh62J0U1_9zPNZ-uaaSNQ0cR6LslCC3KqauiSW-U-KrtnJHhFTQPA7%24&data=04%7C01%7Cbrett.shearer%40wisetechglobal.com%7C2eb43ce155cc4cb0fa2b08d9df065f30%7C8b493985e1b44b95ade698acafdbdb01%7C0%7C0%7C637786040737610720%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=iJ1MYJ1Lzk7lTOIMmPQtQcUzRGEaYhunTlpSEeLeWrU%3D&reserved=0. Triage notifications on the go with GitHub Mobile for iOShttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2F%2Fapps.apple.com%2Fapp%2Fapple-store%2Fid1477376905%3Fct%3Dnotification-email%26mt%3D8%26pt%3D524675__%3B!!Na5NE8kfbMIR6Ys!4IFGKKAn-N4BcCGZqTBh62J0U1_9zPNZ-uaaSNQ0cR6LslCC3KqauiSW-U-KrtnJHhsmf-Eb%24&data=04%7C01%7Cbrett.shearer%40wisetechglobal.com%7C2eb43ce155cc4cb0fa2b08d9df065f30%7C8b493985e1b44b95ade698acafdbdb01%7C0%7C0%7C637786040737610720%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=YbnzuYfkZavGtt7JdbseE9eEvFLYin%2BKGkSmnOweANQ%3D&reserved=0 or Androidhttps://aus01.safelinks.protection.outlook.com/?url=https%3A%2F%2Furldefense.com%2Fv3%2F__https%3A%2F%2Fplay.google.com%2Fstore%2Fapps%2Fdetails%3Fid%3Dcom.github.android%26referrer%3Dutm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__%3BJSUlJSU!!Na5NE8kfbMIR6Ys!4IFGKKAn-N4BcCGZqTBh62J0U1_9zPNZ-uaaSNQ0cR6LslCC3KqauiSW-U-KrtnJHj57kJGg%24&data=04%7C01%7Cbrett.shearer%40wisetechglobal.com%7C2eb43ce155cc4cb0fa2b08d9df065f30%7C8b493985e1b44b95ade698acafdbdb01%7C0%7C0%7C637786040737610720%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000&sdata=9JwBLUiZ6AY0vGLM3PGgowuJu8m8CHiKWyqIFt7vfpI%3D&reserved=0. You are receiving this because you commented.Message ID: @.***>
wise-coders
commented
2 years ago I got it. I read this message: I would be interested in being able to split a model simply to reduce the size of the generated dbs file. Mine is currently 16MB and I'm looking to move to DBschema due to the performance of the previous CASE tool I used.
and I thought the performance issues are related to slowness. Which is then the reason to reduce the size of the dbs file? Even if the file is relative large, this shouldn't be a problem.
Best regards, Dragos Pruteanu
In Oracle Database , there are some foreign tables created by synonyms based on database links, I want show these tables in DbSchema Layouts.
But the connection can only reverse Tables , Views, User Data Types, Squeences, Procedures,Functions,Triggers. can conneciton reverse Synonyms , so I can use 'Foreign Tables' in Layout。
OR:
Is it possiable to change the conception of 'Connection' in DbSchema form only one Database Connetion to a group of Database Connections, then one Schema/Layout can contains different tables from different Databases.
One Connection (Current Dbschema Conception) Change To Connection Group like the image : (Note The Title Can add More Connecitons)
Project Explorer Add An Connection Level