Greetings. On Mon, 2022-04-25 at 23:19 -0700, t603 wrote: > Hello, may I ask You few questions about LINK_SCHEMA function? > > 1) Is LINK_SCHEMA on 10+ or 100+ tables and views far more faster > that 10+ or 100+ times CREATE LINKED TABLE? In other words is there > time improvement due connection establishment? Or does LINK_SCHEMA > internally call of 10+ or 100+ CREATE LINKED TABLE and there is no > performance improvement?
I think, this will perform very similar, but may depend on the exact circumstances. As far as I understand it, the "LINKED" command only provide a framework for querying via a different JDBC connection and fetching records. Its an ETL alike mechanism. So LINKED SCHEMA would only provide the JDBC connection URL for accessing the schema's table -- same way as LINKED TABLE would do,. > > 2) When I do not need linked schema anymore, is there something like > UNLINK_SCHEMA? Would not that be a simple DROP SCHEMA? Best regards Andreas -- 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/304e641f868cb944cd660f6cb09fdd8dca9cd7b6.camel%40manticore-projects.com.
