BTW: there are usually about 30 tables. Some approaching 100K rows, the big one being the only that goes into the millions.
On Friday, 30 September 2022 at 12:52:49 UTC+2 Silvio wrote: > Thanks Noel, > > Also see my other remark. I will look into that table. Actually, we did > some stuff directly on the INFORMATION_SCHEMA tables before but the H2 > versions above 200 had some modified layout/content in there so we switched > to the JDBC call for this one. > > On Friday, 30 September 2022 at 12:47:12 UTC+2 Noel Grandin wrote: > >> How many tables do you have, that should return in milliseconds. >> >> You could try rinning the built in profiler (see the docs) and see what >> it is doing. >> >> You could also directly query the metadata table >> INFORMATION_SCHEMA.INDEXES >> >> -- 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 view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/a98164da-90f2-42af-94c4-c031c23e1e3dn%40googlegroups.com.
