Hi kenlo, thanks you for help me. Hi Uli, thaks you to.you to help me but i need only database size kenlo's answer worked for me.
i asked bonus :) I do not need but out of curiosity; it is possible select query for table_name,calculated_table_size ? Thanks for all. On Wednesday, May 13, 2015 at 12:14:44 PM UTC+3, kenlo wrote: > > I use this. > > > select > (select cast(value as bigint) > from information_schema.settings > where name = 'info.PAGE_COUNT') * > (select cast(value as bigint) > from information_schema.settings > where name = 'info.PAGE_SIZE') as fileSize; > > > On Tuesday, May 12, 2015 at 3:49:14 AM UTC+8, Hasan Mumin wrote: >> >> I started a new one h2 database. I looked on their website and google >> group, but I did not learn how to calculate the size of the database. Can >> you help with this? >> > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
