| *** altlogbot_0 has quit IRC | 03:44 | |
| *** altlogbot_2 has joined #storyboard | 03:46 | |
| *** whoami-rajat has joined #storyboard | 04:31 | |
| *** altlogbot_2 has quit IRC | 04:38 | |
| *** altlogbot_0 has joined #storyboard | 04:42 | |
| *** ankita-2798 has joined #storyboard | 04:54 | |
| *** dtantsur|afk is now known as dtantsur | 06:00 | |
| *** tosky has joined #storyboard | 07:11 | |
| *** ankita-2798 has quit IRC | 07:23 | |
| *** tosky has quit IRC | 07:40 | |
| *** tosky has joined #storyboard | 07:42 | |
| *** ankita-2798 has joined #storyboard | 07:45 | |
| *** ankita-2798 has quit IRC | 07:59 | |
| *** ankita-2798 has joined #storyboard | 08:00 | |
| *** ankita-2798 has quit IRC | 09:54 | |
| *** ankita-2798 has joined #storyboard | 10:06 | |
| *** dtantsur is now known as dtantsur|lunch | 10:43 | |
| *** ankita-2798 has quit IRC | 12:21 | |
| *** ankita-2798 has joined #storyboard | 12:21 | |
| *** ankita-2798 has quit IRC | 12:22 | |
| *** ankita has joined #storyboard | 12:23 | |
| *** udesale has joined #storyboard | 12:25 | |
| *** whoami-rajat has quit IRC | 12:51 | |
| *** dtantsur|lunch is now known as dtantsur | 13:35 | |
| *** whoami-rajat has joined #storyboard | 14:03 | |
| corvus | i've enabled the slow query log; later today or tomorrow i'll collect that and post it somewhere | 14:16 |
|---|---|---|
| SotK | nice, thanks | 14:27 |
| SotK | hopefully it can provide some useful guidance | 14:28 |
| fungi | thanks corvus!!! | 14:33 |
| fungi | is that on storyboard.o.o or storyboard-dev.o.o? | 14:33 |
| fungi | (if the latter we likely need to go bang around on it some to generate activity) | 14:34 |
| corvus | prod | 14:35 |
| fungi | awesome, looking forward to new revelations | 14:37 |
| diablo_rojo_phon | +2 | 15:01 |
| diablo_rojo_phon | SotK: ankita meeting in an hour then? | 15:01 |
| SotK | Yeah :) | 15:10 |
| diablo_rojo_phon | Sweet. | 15:10 |
| diablo_rojo_phon | I'll get a link to my zoom and email it to you both in a bit. | 15:10 |
| ankita | Okay! | 15:29 |
| *** altlogbot_0 has quit IRC | 15:34 | |
| *** irclogbot_0 has quit IRC | 15:36 | |
| *** altlogbot_1 has joined #storyboard | 15:37 | |
| *** irclogbot_0 has joined #storyboard | 15:38 | |
| *** dtantsur is now known as dtantsur|afk | 15:51 | |
| diablo_rojo_phon | SotK: joining? :) | 16:02 |
| SotK | diablo_rojo_phon: I don't seem to have an email with the link :( | 16:05 |
| diablo_rojo_phon | Sent now :) | 16:09 |
| SotK | got it, be there in a few, thanks | 16:11 |
| *** ankita has quit IRC | 16:56 | |
| *** tosky__ has joined #storyboard | 17:59 | |
| *** tosky has quit IRC | 18:00 | |
| *** tosky__ is now known as tosky | 18:00 | |
| fungi | wow, the /var/lib/mysql/storyboard01-slow.log on storyboard.o.o is already 12mb in size | 18:57 |
| fungi | 16347 lines | 18:57 |
| fungi | and we do indeed have some *massive* looking queries | 18:58 |
| fungi | though some of that is probably bloated by explicit canonicalization | 18:59 |
| fungi | still a lot of nested logic with cases on inequalities of sums of subqueries in joins of joins | 19:00 |
| fungi | here's a query which took >3 minutes to complete | 19:02 |
| SotK | wow, >3 minutes is ridiculous | 19:05 |
| SotK | sounds like there's lots of room for improvement | 19:05 |
| fungi | gimme a sec to get pastebinit reinstalled properly and i'll paste it | 19:05 |
| * SotK wonders just how much of it is his fault | 19:05 | |
| fungi | here we go... http://paste.openstack.org/show/752274 | 19:11 |
| diablo_rojo_phon | Ankita ^^ | 19:15 |
| SotK | ah, so its the story summary stuff which is doing all the cases on sums to get the number of tasks in each state | 19:17 |
| SotK | and then all the joins are from the private stories code | 19:17 |
| SotK | I wonder if the query generated with https://review.opendev.org/#/c/643323/1 applied is better | 19:18 |
| fungi | that was an egregious example, but there are lots of different ones too | 19:18 |
| diablo_rojo_phon | ...I assume we aren't meeting? | 19:19 |
| fungi | skimming, but seems likely | 19:19 |
| fungi | diablo_rojo_phon: oh, i was just making idle chitchat while waiting for the meeting | 19:19 |
| diablo_rojo_phon | SotK: ? | 19:20 |
| SotK | we can if you like, I wasn't sure if you were around | 19:20 |
| diablo_rojo_phon | We'd be starting 20 min late but I'm game if other people are. You'll just have to lardon my typing from phone. | 19:20 |
| diablo_rojo_phon | *pardon | 19:20 |
| fungi | heh | 19:20 |
| diablo_rojo_phon | Lol | 19:20 |
| fungi | you're lardoned! | 19:21 |
| diablo_rojo_phon | My point exactly | 19:21 |
| * SotK goes to get the agenda | 19:21 | |
| SotK | alright, lets do it | 19:21 |
| SotK | so, what should we rename storyboard to? :D | 20:01 |
| fungi | second story | 20:01 |
| fungi | therealstoryboard | 20:02 |
| fungi | altstoryboard | 20:02 |
| * fungi is breaking his personal no-bikesheds rule | 20:03 | |
| diablo_rojo_phon | fireball | 20:03 |
| fungi | but yeah, i'd say "sboard" has the benefits of being short, a contraction of the actual name, and most importantly available | 20:03 |
| diablo_rojo_phon | fungi: I think pypi names are the best thing you could break the rule for. | 20:04 |
| fungi | or "sbord" if we want it to seem decidedly more swedish? | 20:06 |
| diablo_rojo_phon | Haha I think sboard | 20:07 |
| diablo_rojo_phon | Or opendev-storyboard | 20:07 |
| fungi | the distribution name for the package changes very little, ultimately. it determines the pypi url and the package name someone will enter in a pip install command | 20:09 |
| fungi | the repo name, python module name, et cetera don't need to be changed | 20:10 |
| diablo_rojo_phon | Makes sense. | 20:13 |
| diablo_rojo_phon | I suppose the decision is between if we want to tie storyboard to opendev for eternity or not. | 20:14 |
| diablo_rojo_phon | SotK: opinions? | 20:14 |
| SotK | yeah that is the real decision here | 20:15 |
| diablo_rojo_phon | I can see pros and cons for both options. | 20:15 |
| SotK | I don't really have a super strong opinion either way, and its not like its impossible to change in the future (though obviously not ideal) | 20:17 |
| SotK | I guess the concern is basically the same as it would be if we'd suggested `openstack-storyboard` a year ago, but I feel like opendev is generic enough to be fine | 20:18 |
| fungi | so... here's an idea | 20:19 |
| fungi | we have several projects anyway | 20:19 |
| diablo_rojo_phon | #freebrainstorm | 20:19 |
| fungi | how about storyboard-api | 20:19 |
| fungi | might even be worth renaming the repo and module to that (down the road) | 20:20 |
| fungi | that fits in with storyboard-webclient | 20:20 |
| diablo_rojo_phon | That makes sense to me. | 20:20 |
| diablo_rojo_phon | I could be down with that. | 20:20 |
| SotK | that seems like a really obvious and sensible solution to me | 20:21 |
| diablo_rojo_phon | +2 | 20:21 |
| fungi | storyboard-server would be similar though slightly longer | 20:21 |
| diablo_rojo_phon | I vote api | 20:21 |
| fungi | and with that epiphany, i must venture out into the wilds of my yard to deploy weapons of grass destruction | 20:22 |
| SotK | Yeah, +1 for api | 20:23 |
| fungi | next... what version should we start with? 1.0.0? | 20:25 |
| * SotK wonders if it would be better to wait until things like attachments are finished before releasing something called 1.0.0 | 20:39 | |
| fungi | maybe? but... meh, number are numbers | 20:41 |
| fungi | the main thing to think about when it comes to versioning policy is what we want to consider worthy of major vs minor vs patch increments from a semver perspective, and whether we want the api itself versioned independently of the server which provides it | 20:42 |
| diablo_rojo_phon | Yeah I would wait for attachments and then do the1.0 | 20:42 |
| * SotK nods | 20:50 | |
| SotK | maybe the question I should've asked is should we hold off doing any kind of release until we have attachments implements | 20:50 |
| SotK | s/implements/implemented/ | 20:51 |
| fungi | i can see the allure, but then again esr says "release early, release often" | 20:52 |
| fungi | the risk is if you put off an initial release, you may end up "moving the goalposts" and never consider it ready to release | 20:53 |
| fungi | as opposed to just considering it "good enough" (i mean, it's in use and people are relying on it in production) | 20:53 |
| fungi | 1.0.0 can mean "hey this is cool and people are using it so we should declare a version to be able to give them better insight into future developments" | 20:54 |
| fungi | while 1.1.0 can mean "and now we bring you... story attachments" | 20:55 |
| *** jtomasek has quit IRC | 20:55 | |
| SotK | yeah that makes sense, I think that is better than waiting (probably for longer than expected) | 20:56 |
| SotK | I've been spending too much time around folk who are extra conservative about releases and it must be rubbing off on me | 20:57 |
| fungi | numbers are free | 20:57 |
| fungi | or at least extremely inexpensive | 20:57 |
| diablo_rojo_phon | Hahaha that's fair. I'm fine with that. | 20:58 |
| *** whoami-rajat has quit IRC | 21:13 | |
| *** udesale has quit IRC | 21:43 | |
| *** tosky has quit IRC | 21:49 | |
| *** ianychoi has quit IRC | 22:32 | |
| *** ianychoi has joined #storyboard | 22:33 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!