#42 Get Rowcount from metadata

[Anonymous]

We have run the SchemaSpy against our Mysql database, it took more than 1 hours to finish. I found the slowness is in select(*) from table, if you can get the rowcount from information_schema, that will be greatly speed analyzing process.

Most databases has rowcount information ready after running analyze statement, for example, such information can be found in user_tables in Oracle.

Thanks,

Daning

[John Currier]

Logged In: YES
user_id=1264584
Originator: NO

This should be resolved with the solution that I'll put in for this feature request:
https://sourceforge.net/tracker/index.php?func=detail&aid=1598195&group_id=137197&atid=737990

John

[John Currier]

Logged In: YES
user_id=1264584
Originator: NO

MySQL-specific selectRowCountSql implemented in Subversion revision 419.

John

[Mikheil Kapanadze]

John,

Here is oracle-specific setting for selectRowCountSql:

select num_rows as row_count from all_tables where table_name = :table and owner = :owner

Mikheil

[John Currier]

Thanks for the SQL Mikheil. It's included in revision 461.

[John Currier]

Implemented in release 4.0.0.