*** jungleboyj has quit IRC | 00:13 | |
*** diablo_rojo_phon has quit IRC | 00:18 | |
*** jungleboyj has joined #storyboard | 00:20 | |
*** gmann has quit IRC | 00:20 | |
*** jungleboyj has quit IRC | 00:27 | |
*** gmann has joined #storyboard | 00:42 | |
*** jungleboyj has joined #storyboard | 00:42 | |
*** jamesmcarthur has joined #storyboard | 01:21 | |
*** jamesmcarthur has quit IRC | 01:26 | |
*** jamesmcarthur has joined #storyboard | 01:27 | |
*** jamesmcarthur has quit IRC | 02:18 | |
*** whoami-rajat has joined #storyboard | 03:13 | |
*** jamesmcarthur has joined #storyboard | 03:59 | |
*** jamesmcarthur has quit IRC | 04:03 | |
*** lxkong has quit IRC | 07:43 | |
*** lxkong has joined #storyboard | 07:44 | |
*** jungleboyj has quit IRC | 07:45 | |
*** hogepodge has quit IRC | 07:45 | |
*** jungleboyj has joined #storyboard | 07:47 | |
*** hogepodge has joined #storyboard | 07:48 | |
*** zbr has joined #storyboard | 08:00 | |
*** zbr|ssbarnea has joined #storyboard | 09:50 | |
*** zbr has quit IRC | 09:52 | |
*** whoami-rajat has quit IRC | 11:23 | |
*** jtomasek has joined #storyboard | 11:58 | |
*** tosky has joined #storyboard | 13:02 | |
*** cgoncalves has quit IRC | 14:23 | |
*** cgoncalves has joined #storyboard | 14:28 | |
*** gouthamr has quit IRC | 14:44 | |
*** gouthamr has joined #storyboard | 14:47 | |
*** whoami-rajat has joined #storyboard | 15:09 | |
*** tosky has quit IRC | 15:33 | |
*** jamesmcarthur has joined #storyboard | 15:46 | |
*** Rou has joined #storyboard | 16:21 | |
*** redrobot has quit IRC | 16:48 | |
*** tonyb has quit IRC | 16:48 | |
*** jamesmcarthur has quit IRC | 16:52 | |
*** jamesmcarthur has joined #storyboard | 16:55 | |
*** cgoncalves has quit IRC | 17:04 | |
*** cgoncalves has joined #storyboard | 17:05 | |
*** jamesmcarthur has quit IRC | 17:11 | |
*** whoami-rajat has quit IRC | 17:28 | |
*** jamesmcarthur has joined #storyboard | 17:29 | |
*** jamesmcarthur_ has joined #storyboard | 17:33 | |
*** jamesmcarthur has quit IRC | 17:34 | |
*** whoami-rajat has joined #storyboard | 18:20 | |
*** zbr|ssbarnea is now known as zbr | 18:30 | |
*** Rou has quit IRC | 18:39 | |
*** jtomasek has quit IRC | 19:37 | |
*** Rou has joined #storyboard | 19:42 | |
Rou | fungi, the website for generating the data is pretty awesome! I have checked what tables I would need to create a schema for and generate data for it, and now I have a file with over 10k lines of code, looks pretty scary, and I've been laughing for 5 minutes at it lol | 19:43 |
---|---|---|
Rou | Thanks for the tip XD | 19:43 |
Rou | I think I generated too many data lol | 19:43 |
*** jamesmcarthur_ has quit IRC | 20:05 | |
fungi | glad to know it's useful. i wish someone made an open source tool to do that locally, i'd feel better about recommending it | 20:09 |
Rou | that is rather an interesting idea | 20:17 |
Rou | Something odd is happening XD | 20:17 |
Rou | I generated 5000 stories, literally, in same project group, divided randomly between Active, Merged and Invalid | 20:17 |
Rou | But it still retrieves it fast! XD | 20:17 |
Rou | Will it ever be slow locally or is the issue only noticed on server? | 20:18 |
*** jamesmcarthur has joined #storyboard | 20:35 | |
*** jamesmcarthur has quit IRC | 20:43 | |
*** jamesmcarthur has joined #storyboard | 20:47 | |
*** jamesmcarthur has quit IRC | 20:56 | |
*** jamesmcarthur has joined #storyboard | 20:57 | |
*** jamesmcarthur has quit IRC | 21:00 | |
*** jamesmcarthur has joined #storyboard | 21:01 | |
fungi | it may have some to do with a combination of database size and server resources | 22:09 |
fungi | the server for storyboard.openstack.org has 8gb ram and 8x 2.6ghz vcpus (possibly with some contention for cycles from neighbors in the same cloud) | 22:11 |
fungi | 23232 rows in the stories table, 120881 in the comments table, 29547 tasks, 1004 storytags | 22:13 |
*** jamesmcarthur has quit IRC | 22:18 | |
*** whoami-rajat has quit IRC | 22:20 | |
Rou | Huh | 22:30 |
Rou | As for the server resources, my device is surely slower than that | 22:30 |
Rou | I increased data size up to 15k stories but still can't notice any slowness in the retrieval | 22:31 |
Rou | I'll double it tomorrow, and whichever happens, I'll start workin on the queries itself and test | 22:32 |
Rou | I'll go finish the project that is to be delivered tomorrow in college and hope I don't fall asleep on desk lol | 22:33 |
*** Rou has quit IRC | 22:33 | |
*** jamesmcarthur has joined #storyboard | 22:46 | |
*** jamesmcarthur has quit IRC | 23:07 | |
*** jamesmcarthur has joined #storyboard | 23:37 | |
*** jamesmcarthur has quit IRC | 23:42 |
Generated by irclog2html.py 2.15.3 by Marius Gedminas - find it at mg.pov.lt!