A shared table is only route the query to correct table,do not store any data.Shared by primary key, or use some secondary index.
But I got some problem here. Select will not pass the limit and offset to TableLink, The result set will iterate to apply the limit and offset.when use TableLink,this is very expensive.Is this consider good ? 在 2015年3月10日星期二 UTC+8上午1:14:58，Thomas Mueller写道： > > Hi, > > I'm not sure what features you want to add so I can't be certain, but I > think it is possible. > > I suggest to read all the documentation about linked tables. Then, you may > want to read (part of) the implementation of that feature. It is probably > more complex for what you need. > > Regards, > Thomas > > > > On Sunday, March 8, 2015, wener <[email protected] <javascript:>> wrote: > >> I want to use the h2 server to serve other database and shared them. >> >> This what I think how to do this: >> >> Create a subtype of LinkedIndex >> Override the find,add,remove >> Based on the pk column and chose a correct connect for the Row. >> >> Any suggestions ? >> >> What about the transactions, only use the in auto commit mode ? >> What if there is no pk in Row, need a secondary index ? >> What should I be careful ? >> >> -- >> 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. >> > -- 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.
