This content has been marked as final. Show 10 replies
Update to 1) Out of despair I tried to import Entities and tables anew and then the sort order was alphabetical. It seems that something went severly wrong.
2 and 3 is still open
Hi Guenter,1 person found this helpful
thanks for feedback.
when I find something, I want to go the object itself, wherever it is. That means after finding 'MyTable' or 'MyEntity' I want to go to Subview1 where it is and have it selected.if you click on a row in search result you'll see diagrams listed where that object is used. If type is table/entity you can double click on diagram and diagram will be made visible and table/entity will be selected.
There is a bug and if diagram is not currently visible you need a second double click in order to get object selected. Well it will work for column/attribute and index/key at some point (another bug).
For #3 when you reverse engineer tables from a database you shoul dbe able to click on the tables tab then select or de-select what ever tables you like. Same on the PK, FK, and view tabs.
Are you not seeing that option?
YESSSS! Thank you. That works. I didn't see it at first because I sized the 'find-window' too small and so I couldn't see that after the title 'diagrams' there were some result rows.
Have you some answers to the engineering windows too?
e.g. Now I have another problem. I managed to reverse engineer one table to logical model, but when I selected another table and clicking on 'engineer to logical model' I cannot choose this table and the only table available is the first one I did. I cannot see anything to refresh this list. The only thing that seemed to work was unchecking 'exclude unchecked objects from tree' then 'update tree'. And that is a not a logical way to do that, don't you think?
Yes, you are correct BUT - I have to scroll through 2300 tableslist/rows.
And you know that it is time consuming for SDDM to build this tree and time consuming to find the right table.
I would suggest to add a new filter entry (actual filters: show all, new, deleted, modified objects) e.g. 'selected objects' to just show those in the tree.
Why? I just imported the tables from the database into a relational model and they are of course neither 'new, deleted, modified objects' and some tables are alas not in the repository as entities. (I don't think that we are the only ones with such problems :-) )
So the filter is unusable for me. My approach would be to select the necessary tables/entities in the browser window or in a subview and either have the possibility to right click and have an 'engineer' line or to have the possibility to click on the engineer button and only see those selected in the engineer window. That would be a valuable improvement, I think.
Do you understand what I tried to explain? My English is not that good, I know.
Hi Guenter,1 person found this helpful
Using find. When I enter something in the search field it seems to try to find something after each 2 letters and that is really SLOW. !Search can be :
1) simple - search is done as you type; all properties of all objects are checked whether match to search expression
2) advanced - you can select object type, properties to be searched and expressions on them and how to combine defined criteria using OR or AND
depending on scope:
1) global - all open designs and all loaded models (including physical ones) are searched; simple search only is supported in global search
2) at model level - only objects in model are included in search, if the model is relational one then all open physical models are included in search
We'll add options how simple search is triggered, but still you can try some tweaks:
1) increase memory dedicated to Data Modeler - datamodeler\datamodeler\bin\datamodeler64.conf or datamodeler.conf
default value is:
2) use search at model level, then you can use switch to advanced search
3) For simple mode check "Stop on First" status - if checked then processing of object will stop after first match
4) write search expression somewhere else and use copy/paste to activate simple search
you can find more on search here :
One more addition. Search (global and model level) can use regular expressions, so you can take advantage of it.1 person found this helpful
Thank you for your answer.
italics 1) simple - search is done as you type; all properties of all objects are checked whether match to search expression
I do not understand this strategy. Almost everywhere I look one enters a search expression and then clicks on a button/link to start the search.
Isn't that simpler? Or - when you programmed this part you only tested it with HR schema and not with 2000 entities/tables and 4000 relations?
Sorry that was impolite, but I am a bit desperate with SDDM. I suggested to my management to change from Designer to SDDM because I felt it was mature enough and when I now use it for production I fall into a traphole every
And I only need it for simple works, well at least I regard them so. I just want many small logical models (no I can't use different files because there are many relations to other schemas) and I want to create my 'create/alter table scripts' and the constraints/indizes for PK, FK
e.g. naming standard is almost useless, I have to edit every script. Oracle Designer was not the best software but it did all that without complaining.
italics 1) global - all open designs and all loaded models (including physical ones) are searched; simple search only is supported in global search
italics 2) at model level - only objects in model are included in search, if the model is relational one then all open physical models are included in search
I don't feel much difference in time, sorry
italics 1) increase memory dedicated to Data Modele....
I tried that, but couldn't set it more than -Xmx1280M, because of an error 'Unable to create an instance....' (I use SDDM 32Bit because we installed Oracle client win32_11gR2 and SDDM 64bit haggled about not able to connect to my Databases)
italics 4) write search expression somewhere else and use copy/paste to activate simple search
Be serious, that can't be an option. But I tried it anyway and it really didn't help reducing the waiting time.
Best wishes and don't be upset with me
I read all the helptopcis, white papers, looked at he videos and I am not a newbie. But I see beneath all those brilliant ideas much immature and unintuitive in SDDM
how is the search in advanced mode, still slow or you are getting the result faster?
Yes, search is much faster using advanced search. You should forget the simple search, which is unusable, at least for bigger models.
Could you please look at my newest elaborate here? And can you tell us something about how you think a good approach to using SDDM with entities/tables over 2000 would be?
Thank you for your time reading