KDB IDE error

Community Support
1

Hi,I am using Script0 IDE for kdb+, after loading a huge csv file into atemporary table by the following code:q> t2:(“ISSSSSSSSSSS”; enlist “\t”) 0: `:c:/q/data/TRDWEquityUniverseTEST.txtq> select from t2After running the second statement, this exception is thrown:Out of Memory whilst communicating with :The result set is probably too large.Try increasing the memory available to studio through the command lineoption -J -Xmx512mCan somebody give me any pointers to solve this?Also, when I am running the same statement from console, then theselect doesn’t show the entire rows…how to view them piecemeal?Even changing console size doesn’t seem to fix this.Thanks a lot,Sayankdb+ Infant :)

2

i think you can run in command line and the exe will pass on args to java… so do something like this in dos:

?

pheonix.exe -J -Xmx512m

3

…and check out \c for console size

?

4

You can get the latest version of studio from

https://code.kx.com/trac/browser/contrib/cskelton/studio/releases

if you don’t have an account for code.kx.com you can use username anonymous with password anonymous.

Then you can set the amount of memory available to Studio for kdb+ on the command line as follows

studioForKdb+.exe -J -Xmx512m

(pheonix.exe was an early version of studio for kdb+ and is out of date)

5

Thanks Charlie and Manish…Following Manish’s pointer, I changed the console size, and I’m seeingmore records coming up.Although I downloaded the new version of the IDE, and ran the commandto increase the memory size, still I’m getting the same error. FYI thetable I’m referring is containing 364097 records only. Any why it isnot loading in the IDE?Greetings,SayanOn Apr 22, 6:46?pm, “Charlie Skelton,Kx” <char…> wrote:> You can get the latest version of studio from>> https://code.kx.com/trac/browser/contrib/cskelton/studio/releases&gt;&gt; if you don’t have an account for code.kx.com you can use username anonymous> with password anonymous.>> Then you can set the amount of memory available to Studio for kdb+ on the> command line as follows>> studioForKdb+.exe -J -Xmx512m>> (pheonix.exe was an early version of studio for kdb+ and is out of date)>> On Wed, Apr 22, 2009 at 3:40 PM, Manish Patel <manni.pa…> wrote:> > …and check out \c for console size>> > On Wed, Apr 22, 2009 at 2:25 PM, Sayanosauras <sayandee…>wrote:>> >> Hi,>> >> I am using Script0 IDE for kdb+, after loading a huge csv file into a> >> temporary table by the following code:>> >> q> t2:(“ISSSSSSSSSSS”; enlist “\t”) 0: `:c:/q/data/> >> TRDWEquityUniverseTEST.txt>> >> q> select from t2>> >> After running the second statement, this exception is thrown:>> >> Out of Memory whilst communicating with :> >> The result set is probably too large.> >> Try increasing the memory available to studio through the command line> >> option -J -Xmx512m>> >> Can somebody give me any pointers to solve this?>> >> Also, when I am running the same statement from console, then the> >> select doesn’t show the entire rows…how to view them piecemeal?> >> Even changing console size doesn’t seem to fix this.>> >> Thanks a lot,> >> Sayan>> >> kdb+ Infant :)</sayandee…></manni.pa…></char…>

6

you can see roughly how much memory you would need for studio with

count -8!your select statement here

your result set is simply too big for the current memory setting.

364097 rows, but how many columns and of what types?

you have to consider how much sense it makes to bring that much data back into studio.