Home › Forums › kdb+ › insert into global table in peach › Re: insert into global table in peach
-
What is the use case that you want to insert the same data into two different tables?
I can see the topic names resemble stocks but there is no filter on the data so would appear all records go into each.
The only use case I can think of having the same schema and upserting to two tables is where you maintain two versions the same schema but one with keyed columns to maintain both the full trail and current “state”.
E.g. all FX quotes in one table and the other keyed by Currency Pair and LP to display the current quoted depth.
Cheers,
Sam