Hi,
I'm making some data storage in SQLite, because of its self-contained nature and because it let me focus on visualization by delegating some query and storage matters to the little database. But for some moments I have the data in an ordered collection, which starts to lag for 10.000 items. I would like to explore fast table as a way to storage my temporal objects before putting them in the database, but when I'm trying to install Glamour-FastTable there is a warning message about a dependency on FTTreeDataSource. I tried running the following code: ===== Gofer it smalltalkhubUser: 'estebanlm' project: 'FastTable'; package: 'FTTreeDataSource'; load. ===== but is not working. How can I solve that dependency? Thanks, Offray Ps: See some of you soon in Smalltalks Argentina. I'm already on Buenos Aires. Is a really beautiful city and having the opportunity to reconnect face to face with smalltalkers will be great after my last Squeak Fest talk in 2007. |
Well,
In fact seems that my problem is not that. Is to storage a "large" Smalltalk collection (10k items) in a SQLite database. When I try to do it the environment becomes unresponsive. Any hint on how to do it is welcomed. Cheers, Offray On 08/11/15 16:18, Offray Vladimir Luna Cárdenas wrote: > Hi, > > I'm making some data storage in SQLite, because of its self-contained > nature and because it let me focus on visualization by delegating some > query and storage matters to the little database. But for some moments > I have the data in an ordered collection, which starts to lag for > 10.000 items. I would like to explore fast table as a way to storage > my temporal objects before putting them in the database, but when I'm > trying to install Glamour-FastTable there is a warning message about a > dependency on FTTreeDataSource. I tried running the following code: > > ===== > Gofer it > smalltalkhubUser: 'estebanlm' project: 'FastTable'; > package: 'FTTreeDataSource'; > load. > ===== > > but is not working. How can I solve that dependency? > > Thanks, > > Offray > > Ps: See some of you soon in Smalltalks Argentina. I'm already on > Buenos Aires. Is a really beautiful city and having the opportunity to > reconnect face to face with smalltalkers will be great after my last > Squeak Fest talk in 2007. > > |
On 08/11/15 22:55, Offray Vladimir Luna Cárdenas wrote:
> In fact seems that my problem is not that. Is to storage a "large" > Smalltalk collection (10k items) in a SQLite database. When I try to do > it the environment becomes unresponsive. Any hint on how to do it is > welcomed. How are you using SQLite? You might get some improvement ideas from http://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite Is the performance ok if you just commit a fuel-ed collection to a blob field? Stephan |
Dear Stephan,
Thanks for your quick answer and your pretty detailed information on SQLite optimization. Because my data was taken from several files, what I did was to split the importation into the database in several batches of 10 files at the time. That did it. Cheers, Offray On 08/11/15 17:39, Stephan Eggermont wrote: > On 08/11/15 22:55, Offray Vladimir Luna Cárdenas wrote: >> In fact seems that my problem is not that. Is to storage a "large" >> Smalltalk collection (10k items) in a SQLite database. When I try to do >> it the environment becomes unresponsive. Any hint on how to do it is >> welcomed. > > How are you using SQLite? You might get some improvement ideas from > http://stackoverflow.com/questions/1711631/improve-insert-per-second-performance-of-sqlite > > > Is the performance ok if you just commit a fuel-ed collection to a > blob field? > > Stephan > > > |
Free forum by Nabble | Edit this page |