<stellar-slack>
<lab> 60k+ accounts created and tps is very slow now
<stellar-slack>
<lab> i think postgres server is required for a serious deployment.
<stellar-slack>
<lab> the sqlite file is about 600MB now
<stellar-slack>
<matschaffer> interesting. Wouldn't expect sqlite to be a bottleneck to early, but could be. graydon might also have some thoughts there
<stellar-slack>
<graydon> yeah that's odd, I would expect sqlite to keep up well for a lot longer. hard to say without a version in front of me. what does perf say as far as hotspots?
<stellar-slack>
<lab> any possible cause is debuger
<stellar-slack>
<graydon> which sort of machine is this on, windows or linux?
<stellar-slack>
<lab> i attached debugger in this run for catching crash
<stellar-slack>
<lab> windows, just upgraded to TDM gcc 5.1
<stellar-slack>
<graydon> right. is this an msvc debug build by any chance?
<stellar-slack>
<graydon> hm
<stellar-slack>
<graydon> I really haven't a clue how sqlite performs in that environment. could be a lot of things, I'd really just be speculating at this point.
<stellar-slack>
<graydon> in general though I expect sqlite to perform quite well
<stellar-slack>
<lab> i will keep eyes on it.
de_henne_ has joined #stellar-dev
de_henne has quit [Ping timeout: 264 seconds]
sv-logger has quit [Remote host closed the connection]
sv-logger has joined #stellar-dev
sacarlson1 has joined #stellar-dev
sacarlson has quit [Ping timeout: 244 seconds]
<stellar-slack>
<graydon> fwiw when I run the autoload test on my ~2 year old linux ssd workstation under sqlite I get:
<stellar-slack>
<graydon> 2015-07-30T20:17:09.011 test [] [LoadGen] INFO Tx/s: 48 target (auto), 34.6 actual (1m EWMA). Pending: 488 acct, 89 tx. ETA: 0h16m 2
<stellar-slack>
<graydon> after 100k accounts
<stellar-slack>
<graydon> sqlite solidly outperforms postgres on that config / small size db
TheSeven has quit [Ping timeout: 246 seconds]
TheSeven has joined #stellar-dev
sacarlson1 has left #stellar-dev [#stellar-dev]
stellar-slack has quit [Remote host closed the connection]
stellar-slack has joined #stellar-dev
de_henne_ has quit [Remote host closed the connection]
de_henne has joined #stellar-dev
pixelbeat_ has joined #stellar-dev
sacarlson has joined #stellar-dev
de_henne has quit [Remote host closed the connection]
<stellar-slack>
<fredolafritte> who is supposed to write to the table history_ledgers ?
<stellar-slack>
<fredolafritte> ruby horizon ?
_whitelogger____ has joined #stellar-dev
<stellar-slack>
<scott> @fredolafritte: presently, yes. You should be running the ruby horizon server with IMPORT_HISTORY=true in the environment of the process. Alternatively, you can run `rake db:rebuild_history` from the ruby horizon directory to re-import all data from the connected stellar-core process
<stellar-slack>
<fredolafritte> @scott: : thanks a lot
<stellar-slack>
<fredolafritte> go-horizon queries this table but is empty in my local env
<stellar-slack>
<fredolafritte> rake db:rebuild_history: History::BrokenHistoryChainError: Ledger 12159 not found