I like the idea! It makes me wonder if this information could be generated automatically. Some sort of automated table count(*) scan that would find the highest number of rows for all tables in all schemas and then calculate percentages for each table compared to the highest number?
small = < 50%
medium = > 50% < 80%
large = > 80%
I guess the issue is that pcrud needs this information to be in fm_IDL.xml at compile time? Is there a way around that? Like a dedicated table to hold this info, hooked up to an openSRF service? Perhaps autogen.sh -u would re-populate. Just getting the idea ball started.
Galen,
I like the idea! It makes me wonder if this information could be generated automatically. Some sort of automated table count(*) scan that would find the highest number of rows for all tables in all schemas and then calculate percentages for each table compared to the highest number?
small = < 50%
medium = > 50% < 80%
large = > 80%
I guess the issue is that pcrud needs this information to be in fm_IDL.xml at compile time? Is there a way around that? Like a dedicated table to hold this info, hooked up to an openSRF service? Perhaps autogen.sh -u would re-populate. Just getting the idea ball started.