| 06:17.51 | *** join/#storm dajac (~dajac@74-225.197-178.cust.bluewin.ch) |
| 07:31.38 | *** join/#storm evilaliv3 (~evilaliv3@nat-cataldo.sssup.it) |
| 07:37.45 | *** join/#storm dajac (~dajac@195.176.215.201) |
| 07:45.37 | *** join/#storm fcorrea (~fcorrea@nat/canonical/x-ddofgulozdzuctfr) |
| 09:16.19 | *** join/#storm dajac_ (~dajac@195.176.215.201) |
| 09:18.45 | *** join/#storm fcorrea (~fcorrea@nat/canonical/x-hmnlveuzzzrgefce) |
| 10:51.22 | *** join/#storm dajac (~dajac@195.176.215.201) |
| 11:06.13 | *** join/#storm mkv (~znc@ubuntu/member/m4v) |
| 11:31.09 | *** join/#storm niemeyer (~niemeyer@177.35.68.11) |
| 11:31.09 | *** mode/#storm [+o niemeyer] by ChanServ |
| 12:15.47 | *** join/#storm dajac (~dajac@195.176.215.201) |
| 14:29.27 | *** join/#storm WGG_Sakari (~Diego@91.182.81.242) |
| 15:44.40 | *** join/#storm jkakar (~jkakar@204.14.239.147) |
| 15:49.14 | jkakar | evilaliv3: There is no golden rule that ordering in the database vs in memory is faster or slower. |
| 15:49.54 | jkakar | evilaliv3: But generally, if you can order in the database, and if your query can take advantage of indexes, you will get better overall performance than loading the dataset into memory and sorting it there. |
| 15:50.30 | jkakar | evilaliv3: This is especially true if the number of rows returned by your query is quite large. For a small dataset of a few 10s of rows it probably doesn't matter but then you start dealing with 1000s or 10000s or rows it most likely will. |
| 15:50.42 | jkakar | evilaliv3: The only way to be really sure is to profile the different options. |
| 15:55.33 | evilaliv3 | i agree |
| 15:55.39 | evilaliv3 | thank you |
| 17:20.16 | *** join/#storm dajac (~dajac@254-113.63-188.cust.bluewin.ch) |
| 18:06.00 | *** join/#storm evilaliv3 (~evilaliv3@93-46-227-140.ip109.fastwebnet.it) |
| 18:07.58 | *** join/#storm nicedice (~nicedice@unaffiliated/nicedice) |
| 18:43.39 | *** join/#storm dajac (~dajac@254-113.63-188.cust.bluewin.ch) |
| 19:14.39 | *** join/#storm dajac (~dajac@254-113.63-188.cust.bluewin.ch) |
| 20:32.59 | *** join/#storm dajac (~dajac@254-113.63-188.cust.bluewin.ch) |
| 23:23.23 | *** join/#storm fcorrea (~fcorrea@194.168.195.98) |