Anything works for me. The tool is extremely helpful.
The tool is already pulling the list of columns belongs to an index, so there shouldn't be any performance issue (same DB dictionary table), at least for Oracle & MySQL DB.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was able to generate ER model report for a schema containing 346 tables and 2 views in about 86 sec. I will be happy if the reports come back within 10 min or so.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I was referring to how long it takes to load and render the page when the database is large (e.g. 20,000+ columns). I stripped a lot of details from the columns page to keep browsers from crashing when trying to load those.
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Most of the databases are small to mid size, 100-200 tables with less than 1000 columns. Any of the solution would be fine however prefer to print Index Name by default without any parameters.
Thank your for excellent work.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As I was working on this I realized that I completely mis-read what you were asking for. I really need to learn to read things more closely before I interpret what I'm reading.
At the top of the page the table detail page there should be a "Constraints" check box. If you enable constraints you should see the names associated with the index.
Sorry about my inability to comprehend what I'm reading,
John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I assume it would have to be optional since the columns page can become extremely large and therefore unbearably slow with "large" databases.
John
Anything works for me. The tool is extremely helpful.
The tool is already pulling the list of columns belongs to an index, so there shouldn't be any performance issue (same DB dictionary table), at least for Oracle & MySQL DB.
I was able to generate ER model report for a schema containing 346 tables and 2 views in about 86 sec. I will be happy if the reports come back within 10 min or so.
I was referring to how long it takes to load and render the page when the database is large (e.g. 20,000+ columns). I stripped a lot of details from the columns page to keep browsers from crashing when trying to load those.
John
Got it. Thanks.
Most of the databases are small to mid size, 100-200 tables with less than 1000 columns. Any of the solution would be fine however prefer to print Index Name by default without any parameters.
Thank your for excellent work.
Is there a way to get patch?
I'll have to implement it first. Unfortunately I'm at NASA for the next few weeks so I don't have much spare time.
As I was working on this I realized that I completely mis-read what you were asking for. I really need to learn to read things more closely before I interpret what I'm reading.
At the top of the page the table detail page there should be a "Constraints" check box. If you enable constraints you should see the names associated with the index.
Sorry about my inability to comprehend what I'm reading,
John
That is what I was looking for. Thanks John.