Hi Gareth, Sorry for the stupid question but does your query work on a smaller database, one a tenth the size or so?
Maybe by using a #haltIf: that checks for memory usage growth will show something interesting. e.g. self haltIf:[Smalltalk vm memoryEnd > 100000000]. "100MB" And then running Smalltalk reportCPUandRAM to get a few text files of what's using the RAM & CPU. Hope this helps Paul riverdusty wrote > Hi > > I've managed to create a large database, with PUnqLite, that is 562.1MB. > I can't seem to query it though. > I've set fetchBufferSize: (1024*1024*1023). > I've set SmalltalkImage current vm extraVMMemory: (1024*1024*1023). > I've played around in the info.plist setting the SqueakMaxHeapSize to > ridiculous things. > But I keep getting either out of memory or PqFetchError (probably > because it can't fit the whole stream into the image?). > This is why I was asking about the JX9 query and running a query like > that to only return to the image with results I want. > Any suggestions on how I can handle this? > > Info.plist: >> > <key> > SqueakMaxHeapSize > </key> >> > <integer> > 1073741824 > </integer> > Pharo: >> Image >> ----- >> *****/Pharo4.0.image >> Pharo4.0 >> Latest update: #40611 >> Unnamed >> >> Operating System/Hardware >> ------------------------- >> Mac OS 1093 intel > > > > Kind Regards > -- > Gareth Cox > IT Manager/Developer > Inspired Org (PTY) Ltd -- View this message in context: http://forum.world.st/PUngLite-can-t-query-large-database-tp4829931p4830028.html Sent from the Pharo Smalltalk Users mailing list archive at Nabble.com.
