Append to a splayed table

Community Support
1

Hi all,I would like to append new rows to an existing splayed table in themost memory-efficient way.If my splayed table is sp1 and the table to append is called t1, isthere something better thansp1:get :C:/sp1;sp2: sp1,t1;:C:/sp1/ set sp2;Thank for your help!,Vassili

2

charset=us-ascii
Message-Id:
Cc: Kdb+ Personal Developers
X-Mailer: iPhone Mail (8C148)
From: Attila Vrabecz <attila.vrabecz>
Subject: Re: [personal kdb+] Append to a splayed table
Date: Wed, 23 Feb 2011 17:56:03 +0000
To: “personal-kdbplus@googlegroups.com”

upsert

Attila</attila.vrabecz>

3

Thanks Attila, but how do you use it? In the PLAY version of KDB+ Iuse, if I dosp2:sp1 upsert t1;returns me an 'splay error…VassilisOn Feb 23, 5:56?pm, Attila Vrabecz <attila.vrab…> wrote:> upsert>> ? ?Attila>> On 23 Feb 2011, at 17:51, Vassilis Dimitrakas <vdimitra…> wrote:>> > Hi all,>> > I would like to append new rows to an existing splayed table in the> > most memory-efficient way.>> > If my splayed table is sp1 and the table to append is called t1, is> > there something better than>> > sp1:get :C:/sp1;&gt; &gt; sp2: sp1,t1;&gt; &gt; :C:/sp1/ set sp2;>> > Thank for your help!,>> > Vassili>> > –> >

Submitted via Google Groups</vdimitra…></attila.vrab…>

4

charset=us-ascii
X-Mailer: iPad Mail (8C148)
In-Reply-To: <1a1c0afb-a944-4390-87b2-b0104422bd38@s18g2000vbe.googlegroups.com>
Message-Id:
Date: Wed, 23 Feb 2011 18:16:28 +0000
To: “personal-kdbplus@googlegroups.com”

Mime-Version: 1.0 (iPad Mail 8C148)

>>> `:C:/sp1/ upsert t1

Check code.kx.com

Attila