IRC log of #schooltool for Wednesday, 2013-11-20

*** replaceafill has quit IRC00:13
*** th1a has quit IRC01:33
*** menesis has quit IRC02:57
*** yvl has joined #schooltool09:09
*** th1a has joined #schooltool13:00
*** menesis has joined #schooltool13:35
*** khildin has joined #schooltool14:23
*** replaceafill has joined #schooltool15:22
th1ahi replaceafill, menesis, yvl.15:30
replaceafillgood afternoon15:30
menesishello15:31
th1aOK, I just pushed half the journal documentation update to the book.15:31
th1areplaceafill was riding my ass about it last night, justifiably.15:31
replaceafill:D15:31
th1aI also filed some bugs in the process, as usual.15:32
th1aA couple easy ones that should be jammed into 2.6.2 if possible.15:33
replaceafilli don't understand the "split cell view" one15:33
replaceafillis that one of the "new" views in the journal?15:33
replaceafillmaybe i haven't seen it yet15:33
th1aIt is the homeroom view.15:34
replaceafillah ok15:34
th1aOr, the attendance view when there is homeroom data.15:34
th1aIt is jammed in the top half of the cell.15:34
replaceafilli'll set up some journal data to see it15:35
th1aWe should tweak it a bit, but it isn't critical.15:35
th1aOK, the book revisions should be uploaded.15:37
th1aWhere are we on the bugfix release menesis?15:37
yvlgood morning / afternnoon15:37
menesisth1a: everything that I expected was fixed15:38
menesisI made a few report tests work, and nothing broke15:39
th1ahi yvl.15:39
menesisso today I was merging translations15:39
menesisand updating changes15:40
menesiswill start uploading the releases shortly15:41
menesiswill be finished tonight15:41
th1aCan we get that quick "Done" > "Save" fix and the journal navigation fix (warning about unsaved data) in first?15:42
th1areplaceafill:  I assume the unsaved data thing is pretty much copy paste from the other gradebooks?15:42
replaceafillth1a, yeah, probably15:42
* replaceafill goes look15:42
menesisth1a: I have changed to Save already15:43
th1aOK.  Cool15:44
th1aExcellent. menesis, anything else?15:45
menesisI have played a little with selenium testing of reports15:46
menesisBut the options I tried, to bypass tasks queue, did not help15:47
menesistesting of new-style reports from the old skin did not work either.15:48
menesisso quite unsuccessful :(15:48
* menesis done15:49
th1aOK.  thanks menesis.15:49
th1ayvl?15:49
yvltried to evolve the database replaceafill gave me15:50
yvlgave up after 24 hours15:50
yvltotal memory consumption did no exceed 7 GB15:50
yvlresident memory did not exceed 4 FB15:51
yvlGB15:51
yvlso at least in theory it should be possible to evolve it in a system with little ram15:51
yvltotal being RAM + allocated swap15:51
yvlalso did some profiling15:52
yvltemporal relationships do slow things down, but I can speed them up15:52
yvlnow writing an experimental relationships implementation that should make everything15:52
yvla) faster15:52
yvlb) use less memory15:52
yvlbut I don't know by how much yet15:53
yvlin any case, views should not do 10.000.000 relationship checks, they will always be slow15:53
th1aWhat should they do instead?15:53
th1aSmarter querying?15:54
th1aIndexes?15:54
yvlyes15:54
yvlsmarter querying15:54
th1aLess brute force, basically?15:54
yvlyep15:54
th1aMeaning?15:54
yvlI don't know how to answer that15:55
yvlbasically just look at the offending views15:55
yvland optimize15:55
yvlsee if you can query some things once instead of many times15:55
th1aOK.15:56
yvlalso relationships I15:56
yvlI'm playing with15:56
yvlshould load less objects into memory15:56
th1aI mean, basically with ZODB you don't have the option of just doing a SQL-ish query?  You pretty much always have to sort through all the things at least once?15:57
yvlalso, their caches will be smaller15:57
th1aI'm not sure this has ever completely sunk in to me...15:57
yvlalso, they'll be a bit more careful not to unghost objects unless necessary15:57
yvlwell15:57
yvlyes, you can't do a SQL-ish query15:57
yvland no15:57
yvlyou can, but you have to, well, implement it manually15:58
yvlor you can just walk through all the objects15:58
yvlbut that's why we put objects in different "containers"15:58
yvlfor example:15:59
yvldirect person relationships are stored on person object15:59
yvland only links to related things are stored there15:59
th1aOK.15:59
yvlso - less walking there15:59
th1aWell, again, this is the time to do this mucking about.16:00
th1aJust make sure you get done before the end of the year!16:00
yvlI'd rather get that done earlier ;)16:00
th1aIndeed.16:00
yvlI'll keep you updated as things progress16:01
th1aOK.16:02
*** replaceafill has quit IRC16:02
th1aThanks yvl.16:02
th1aAnd... replaceafill...16:02
th1aSo, in the meantime, I guess things might be happening in Nigeria?!?!?16:04
th1aAlways a little hard to tell there...16:04
th1aI did forward that to you, right?16:05
th1a...16:09
*** th1a has quit IRC16:10
*** th1a has joined #schooltool16:10
th1aHello?16:11
yvlhello16:12
yvlhow are you this fine day?16:12
yvlwelcome to this fine parallel universe16:12
th1aDid I disappear there?16:12
yvlreplaceafill is still gone :|16:13
yvland it seems you just relaunched your xchat16:13
th1aOK.  I wasn't sure if I was in a parallel univers.16:13
th1ae16:13
th1aOK... I need to go to the bank.16:15
* th1a drops the bag of gravel.16:15
th1aHave a good week/end guys!16:15
yvlthanks guys!16:16
*** replaceafill has joined #schooltool17:27
replaceafillth1a, just sent you an email17:34
replaceafillsee you guys tomorrow17:35
*** replaceafill has quit IRC17:35
*** mibofra has quit IRC20:53
*** mibofra has joined #schooltool20:56
*** menesis has quit IRC21:19
*** menesis has joined #schooltool21:52
*** mibofra has quit IRC21:55
*** mibofra has joined #schooltool21:57
*** th1a has quit IRC21:58
*** khildin has quit IRC23:31

Generated by irclog2html.py 2.15.1 by Marius Gedminas - find it at mg.pov.lt!