Received: by 10.114.61.1 with SMTP id j1mr67617waa.7.1216940345039; Thu, 24 Jul 2008 15:59:05 -0700 (PDT)Date: Thu, 24 Jul 2008 15:59:04 -0700 (PDT)X-IP: 141.162.101.50User-Agent: G2/1.0X-Google-Token: QbwmywwAAACPtUqvQDob7pb3j9K_m4PmX-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.0.3705; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022),gzip(gfe),gzip(gfe)Message-ID: <7d302646-ee0b-470e-8af4-44b64a7c958d@q5g2000prf.googlegroups.com>Subject: Creating tables on diskFrom: sk To: “Kdb+ Personal Developers” X-Google-Approved: simon.garland@gmail.com via email at 2008-07-25 06:17:13I am a newbie to Kdb+. I would like to move my MySQL db to Kdb+. TheDb size is about 50Gb. I will be running the 32 bit evalaution editionon 4 CPU ~ 8gb ram- sles10 box. I have all my MySQL data in csvformat (Largest table csv file is around 15gb) . I know we can loadcsv files using this commandq)testtable:(“IFSC”;enlist “,”)1:`test.csvbut i am guessing this loads into memory..How do i make it write to adisk? any help would be appreciated.Thanks
yes, that would load it into memorysimple save would just be:q):savename set testtableorq):savename/ set testtableif you want to save it splayedhave a look at:http://kx.com/q/e/csvguess.qthat includes an option to generate a load script which you can thenuse to incrementally load&save your csvs2008/7/25 sk :>> I am a newbie to Kdb+. I would like to move my MySQL db to Kdb+. The> Db size is about 50Gb. I will be running the 32 bit evalaution edition> on 4 CPU ~ 8gb ram- sles10 box. I have all my MySQL data in csv> format (Largest table csv file is around 15gb) . I know we can load> csv files using this command> q)testtable:(“IFSC”;enlist “,”)1:`test.csv> but i am guessing this loads into memory..How do i make it write to a> disk? any help would be appreciated.>> Thanks