| *** tosky has quit IRC | 00:01 | |
| *** jamesmcarthur has joined #storyboard | 01:37 | |
| *** whoami-rajat has joined #storyboard | 01:53 | |
| *** jamesmcarthur has quit IRC | 02:08 | |
| *** jamesmcarthur has joined #storyboard | 02:39 | |
| *** jamesmcarthur has quit IRC | 02:46 | |
| *** jamesmcarthur has joined #storyboard | 03:02 | |
| *** jamesmcarthur has quit IRC | 03:39 | |
| *** jamesmcarthur has joined #storyboard | 03:40 | |
| *** diablo_rojo has quit IRC | 03:41 | |
| *** jamesmcarthur has quit IRC | 03:45 | |
| *** jamesmcarthur has joined #storyboard | 04:11 | |
| *** jamesmcarthur has quit IRC | 04:18 | |
| *** hogepodge has quit IRC | 06:32 | |
| *** johnsom has quit IRC | 06:32 | |
| *** dangtrinhnt has quit IRC | 06:44 | |
| *** johnsom has joined #storyboard | 06:55 | |
| *** hogepodge has joined #storyboard | 06:56 | |
| *** tosky has joined #storyboard | 07:23 | |
| *** jpich has joined #storyboard | 08:03 | |
| *** johnsom has quit IRC | 08:04 | |
| *** johnsom has joined #storyboard | 08:05 | |
| *** dtantsur|afk is now known as dtantsur | 09:35 | |
| *** lxkong has left #storyboard | 09:47 | |
| *** jpich has quit IRC | 10:58 | |
| *** jpich has joined #storyboard | 10:59 | |
| *** jpich has quit IRC | 11:12 | |
| *** jpich has joined #storyboard | 11:13 | |
| *** jpich has quit IRC | 11:14 | |
| *** jpich has joined #storyboard | 11:30 | |
| *** jpich has quit IRC | 11:30 | |
| *** dtantsur is now known as dtantsur|brb | 11:45 | |
| *** jamesmcarthur has joined #storyboard | 12:21 | |
| *** jpich has joined #storyboard | 12:25 | |
| *** jamesmcarthur has quit IRC | 12:30 | |
| *** scherbatsky has quit IRC | 12:44 | |
| *** jamesmcarthur has joined #storyboard | 12:48 | |
| *** jamesmcarthur has quit IRC | 12:58 | |
| *** mkarray has quit IRC | 13:20 | |
| *** dtantsur|brb is now known as dtantsur | 13:24 | |
| *** jpich has quit IRC | 13:25 | |
| *** jpich has joined #storyboard | 13:26 | |
| *** scherbatsky has joined #storyboard | 13:30 | |
| *** mkarray has joined #storyboard | 13:35 | |
| openstackgerrit | Malek Karray proposed openstack-infra/storyboard-webclient master: Allowing the user to choose what Columns are seen https://review.openstack.org/651270 | 13:41 |
|---|---|---|
| *** ericbarrett has quit IRC | 14:16 | |
| *** dtantsur has quit IRC | 14:27 | |
| openstackgerrit | Malek Karray proposed openstack-infra/storyboard-webclient master: Allowing the user to choose what Columns are seen https://review.openstack.org/651270 | 14:29 |
| *** dtantsur has joined #storyboard | 14:31 | |
| *** jamesmcarthur has joined #storyboard | 14:56 | |
| *** jpich has quit IRC | 16:04 | |
| *** jamesmcarthur has quit IRC | 16:04 | |
| *** jamesmcarthur has joined #storyboard | 16:13 | |
| *** jamesmcarthur_ has joined #storyboard | 16:48 | |
| *** jamesmcarthur has quit IRC | 16:52 | |
| *** diablo_rojo has joined #storyboard | 17:21 | |
| *** dtantsur is now known as dtantsur|afk | 17:36 | |
| *** jamesmcarthur_ has quit IRC | 18:25 | |
| *** jamesmcarthur has joined #storyboard | 18:26 | |
| *** jamesmcarthur has quit IRC | 18:35 | |
| *** irclogbot_0 has quit IRC | 18:39 | |
| *** jamesmcarthur has joined #storyboard | 18:40 | |
| *** irclogbot_0 has joined #storyboard | 18:42 | |
| *** Rou has joined #storyboard | 19:12 | |
| Rou | Hola! | 19:12 |
| Rou | I want to ask about something concerning SB API | 19:12 |
| Rou | The database side is all handled using SQLAlchemy, which doesn't use SQL precisely, rather some built-in functions | 19:14 |
| Rou | I don't see much optimization would happen using their same queries | 19:14 |
| Rou | I mean, it always follows this way, to select ALL data in a table first, then start filtering, and this is definitely not the best approach for retrieving data from a db. | 19:15 |
| Rou | It'd be better if I can start filtering from the very initial query, which will make the retrieved data much less, and hence the query would be faster | 19:16 |
| Rou | But there's no way to use mere SQL queries instead of functions of SQLAlchemy, is there? | 19:17 |
| *** mkarray has quit IRC | 19:43 | |
| *** Rou has quit IRC | 19:45 | |
| *** tsmith_ has joined #storyboard | 19:51 | |
| *** tsmith2 has quit IRC | 19:54 | |
| *** tsmith_ is now known as tsmith2 | 19:54 | |
| diablo_rojo | Rou, I think the main way to speed things up would be better indexing? | 19:55 |
| *** jamesmcarthur has quit IRC | 20:00 | |
| *** jamesmcarthur has joined #storyboard | 21:01 | |
| *** Rou has joined #storyboard | 21:21 | |
| Rou | diablo_rojo, could you explain what you mean more? | 21:27 |
| diablo_rojo | Rou, basically instead of getting everything all at once and not showing results until that all comes back, you would index it so a chunk at a time would come back/be processed and get added to the resutls. | 21:31 |
| Rou | Like getting one page at a time? | 21:52 |
| Rou | Of the list | 21:52 |
| Rou | I have an offset and limit for each page | 21:52 |
| diablo_rojo | Yeah something like that could help | 21:54 |
| diablo_rojo | I would do some benchmarking of how slow it is right now | 21:55 |
| Rou | Great | 21:56 |
| diablo_rojo | Easier to show improvement when you know how bad it used to be | 21:57 |
| Rou | How can I do so, though?? | 22:02 |
| diablo_rojo | Rou, if I knew the answer to that right now I probably would have made the changes myself already ;) | 22:06 |
| Rou | Huh | 22:08 |
| Rou | You've a point XD | 22:08 |
| Rou | I'll try to see how can I limit the retrieval queries so data would be less & hence operates faster | 22:09 |
| Rou | and whenever I go on to the next page, only the range of the page is processed or sent to the the web-client anyway | 22:09 |
| diablo_rojo | Haha yep :) | 22:11 |
| diablo_rojo | Sounds like a good start | 22:11 |
| *** Rou has quit IRC | 22:31 | |
| *** scherbatsky has quit IRC | 22:56 | |
| *** whoami-rajat has quit IRC | 23:02 | |
| *** jamesmcarthur has quit IRC | 23:06 | |
| *** jamesmcarthur has joined #storyboard | 23:07 | |
| *** jamesmcarthur has quit IRC | 23:11 | |
| *** tosky has quit IRC | 23:19 | |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!