Thanks Evgenij! One last question: Does it have a cost involved for creating a Linked Table? Like $ value per call Redirected to Target Table?
On Thursday, October 29, 2020 at 10:10:24 AM UTC-4 Evgenij Ryazanov wrote: > Hello. > > >> 1. How does Linked Table work? >> > It simply redirects all queries and data modification commands to the > target database. > > >> When i create a Linked Table in H2 Database - does it continuously >> monitor the actual database table that it is linked to - for changes? >> > No. > > >> and if changes are identified does it deletes all records and insert them >> again or does it updates only new /or updated entry? >> > They aren't detected, but all your attempts to do something with a linked > table are passed to the target database and it will obliviously know the > current data in the table, because it its own real table. > > >> 2. What performance impact it would have on original database table? >> > It depends on performance of calls into target database and complexity of > your queries. H2 tires to read information about indexes from the target > database to optimize complex queries better, but in some cases execution > plan may be far from being perfect, optimizer of H2 is not very advanced. > -- 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/fa705fa7-c799-4bc8-9cdd-1f7356871203n%40googlegroups.com.
