--- Log opened Fri Jul 24 00:00:46 2015 |
00:03 | | thalass [thalass@Nightstar-m49.o7s.158.104.IP] has joined #code |
00:03 | | mode/#code [+o thalass] by ChanServ |
00:11 | | Kindamoody is now known as Kindamoody[zZz] |
00:19 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
00:19 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
00:33 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has quit [Ping timeout: 121 seconds] |
00:39 | <&McMartin> | Dumb SQL question |
00:39 | <&McMartin> | Can I basically assume that SELECT count(*) FROM tableName; runs in constant rather than linear time? |
00:39 | <&McMartin> | If not, is there a better way to get the size of a table |
00:40 | < [R]> | Depends on the DB i think. Try the query-analyzer/profiler? |
00:41 | <&McMartin> | Could be worth a shot. Let's see. |
00:41 | <&McMartin> | (Since I think this is always going to cap out at under 10k this isn't *crucial*, but if there's a right way to do this I'd rather use + than a loop of += 1s, as it were.) |
00:42 | <&McMartin> | Looks good on this version of SQLite. |
00:42 | <&McMartin> | EXPLAIN gives init/open/count/close |
00:43 | < [R]> | That's an obvious optimization case anyways. |
00:59 | | thalass is now known as Thalass|TF2 |
01:06 | | Derakon[AFK] is now known as Derakon |
01:07 | | Thalass|TF2 [thalass@Nightstar-m49.o7s.158.104.IP] has quit [Connection closed] |
01:09 | | thalass [thalass@Nightstar-m49.o7s.158.104.IP] has joined #code |
01:09 | | mode/#code [+o thalass] by ChanServ |
01:58 | | thalass is now known as Thalass|scrumpeh |
01:59 | | Thalass|scrumpeh is now known as Thalass|cowboy |
02:04 | | himi [fow035@Nightstar-dm0.2ni.203.150.IP] has joined #code |
02:04 | | mode/#code [+o himi] by ChanServ |
02:16 | | Thalass|cowboy [thalass@Nightstar-m49.o7s.158.104.IP] has quit [Ping timeout: 121 seconds] |
02:17 | | Thalass|cowboy [thalass@Nightstar-m49.o7s.158.104.IP] has joined #code |
02:50 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
03:03 | | Thalass|cowboy [thalass@Nightstar-m49.o7s.158.104.IP] has quit [Ping timeout: 121 seconds] |
03:21 | | gnolam [lenin@Nightstar-t1tbf0.cust.bahnhof.se] has quit [[NS] Quit: Quit.] |
04:57 | | catadroid` [catalyst@Nightstar-r1129u.dab.02.net] has joined #code |
05:01 | | catadroid [catalyst@Nightstar-r46fnd.dab.02.net] has quit [Ping timeout: 121 seconds] |
05:03 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has quit [Connection closed] |
05:11 | | Derakon is now known as Derakon[AFK] |
05:16 | | Checkmate [Z@Nightstar-r9lk5l.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
05:19 | | celticminstrel [celticminst@Nightstar-c0l57i.dsl.bell.ca] has quit [[NS] Quit: And lo! The computer falls into a deep sleep, to awake again some other day!] |
06:26 | | Kindamoody[zZz] is now known as Kindamoody |
07:30 | | Kindamoody is now known as Kindamoody|afk |
07:42 | | catadroid [catalyst@Nightstar-h1o4fd.dab.02.net] has joined #code |
07:42 | | catadroid` [catalyst@Nightstar-r1129u.dab.02.net] has quit [A TLS packet with unexpected length was received.] |
08:23 | | catadroid [catalyst@Nightstar-h1o4fd.dab.02.net] has quit [[NS] Quit: Bye] |
08:24 | | catadroid [catalyst@Nightstar-apje9k.dab.02.net] has joined #code |
09:19 | | himi [fow035@Nightstar-dm0.2ni.203.150.IP] has quit [Ping timeout: 121 seconds] |
09:50 | | Checkmate [Z@Nightstar-r9lk5l.cust.comxnet.dk] has joined #code |
09:50 | | mode/#code [+o Checkmate] by ChanServ |
10:02 | | * ErikMesoy has learned about implicit else today. This seems like a recipe for mysterious errors. |
10:03 | < ErikMesoy> | If (condition) \n { \n DoThing() \n } \n DoOtherThing() |
10:11 | < abudhabi> | What language? |
10:11 | < ErikMesoy> | C#. |
10:18 | < [R]> | That's... horrid |
10:22 | < ErikMesoy> | My coworker appears to be doing fine with it. Well, maybe not all that fine considering I've been called in for debugging and general project help a few times now. >_> |
10:24 | <@Wizard> | Is that legitimately an implicit else or does the if block just return before the program reaches DoOtherThing? |
10:24 | < ErikMesoy> | Really implicit else. The Things were variable assignments. |
10:24 | <@TheWatcher> | ... wat |
10:24 | <@TheWatcher> | That's insane |
10:25 | <@Wizard> | Can't really find any source on it being implicitly else |
10:26 | < ErikMesoy> | It may have looked slightly different from what I wrote above from memory, but it was definitely a non-indented statement not included in the if's braces that was nonetheless conditional on if() failing. |
10:26 | < ErikMesoy> | I stared at it for several minutes trying to figure out "why would you conditionally assign, then overwrite anyway" until I asked the right question to learn that it wasn't overwrite anyway. |
10:27 | <@Wizard> | Right |
10:59 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
10:59 | | VirusJTG_ [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
10:59 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Clap on! , Clap off! Clap@#&$NO CARRIER] |
11:00 | | VirusJTG_ [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [Connection closed] |
11:00 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
11:10 | | * TheWatcher eyes this typo |
11:10 | <@TheWatcher> | "this field should only contain conman separated file IDs" |
11:14 | < abudhabi> | 313213213conman3469348603conman4603473conman346096 |
11:19 | <@TheWatcher> | actually, I was thinking more like 348cameron8430blair8932clegg849 |
11:22 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has quit [[NS] Quit: Leaving] |
11:22 | | VirusJTG [VirusJTG@Nightstar-6i5vf7.sta.comporium.net] has joined #code |
11:52 | | himi [fow035@Nightstar-v37cpe.internode.on.net] has joined #code |
11:52 | | mode/#code [+o himi] by ChanServ |
12:24 | | Attilla [sid13723@Nightstar-h2b233.irccloud.com] has quit [[NS] Quit: ] |
12:25 | | * TheWatcher hairpulls, starts hand-building callgraphs for perl code |
12:25 | | Attilla [sid13723@Nightstar-ed0oqj.irccloud.com] has joined #code |
14:22 | <&ToxicFrog> | ErikMesoy: that doesn't work as described |
14:22 | <&ToxicFrog> | Might it instead have been: |
14:22 | <&ToxicFrog> | if (condition) { |
14:22 | <&ToxicFrog> | DoThing(); |
14:22 | <&ToxicFrog> | } else |
14:22 | <&ToxicFrog> | DoOtherThing(): |
14:22 | <&ToxicFrog> | ? |
14:23 | | celticminstrel [celticminst@Nightstar-c0l57i.dsl.bell.ca] has joined #code |
14:23 | | mode/#code [+o celticminstrel] by ChanServ |
14:26 | | macdjord is now known as macdjord|wurk |
14:36 | < catadroid> | DoToxicFrog(); |
14:37 | < abudhabi> | That's an unusual way to show interest. |
14:38 | < catadroid> | I'm unusual in many ways |
14:54 | | catadroid` [catalyst@Nightstar-3gh4rk.dab.02.net] has joined #code |
14:56 | | catadroid [catalyst@Nightstar-apje9k.dab.02.net] has quit [Ping timeout: 121 seconds] |
16:53 | | catadroid` is now known as catadroid |
18:03 | | catadroid [catalyst@Nightstar-3gh4rk.dab.02.net] has quit [The TLS connection was non-properly terminated.] |
18:12 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has quit [Connection closed] |
18:17 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has joined #code |
18:17 | | mode/#code [+o Alek] by ChanServ |
18:47 | | ErikMesoy [Erik@Nightstar-ki97ss.customer.cdi.no] has quit [Ping timeout: 121 seconds] |
19:03 | | catadroid [catalyst@Nightstar-3gh4rk.dab.02.net] has joined #code |
19:40 | | ErikMesoy [Erik@Nightstar-ki97ss.customer.cdi.no] has joined #code |
19:41 | | catadroid [catalyst@Nightstar-3gh4rk.dab.02.net] has quit [[NS] Quit: Bye] |
--- Log closed Fri Jul 24 20:04:03 2015 |
--- Log opened Fri Jul 24 20:04:12 2015 |
20:04 | | TheWatcher [chris@Nightstar-ksqup0.co.uk] has joined #code |
20:04 | | Irssi: #code: Total of 37 nicks [22 ops, 0 halfops, 0 voices, 15 normal] |
20:04 | | mode/#code [+o TheWatcher] by ChanServ |
20:04 | | Irssi: Join to #code was synced in 39 secs |
20:37 | | Kindamoody|afk is now known as Kindamoody |
20:48 | | Netsplit *.net <-> *.split quits: @Syloq, @Checkmate, @Reiver, @Orthia, @Reiv, @celticminstrel, PinkFreud, Xon, @himi, 693AAACAZ, (+6 more, use /NETSPLIT to show all of them) |
20:49 | | Netsplit over, joins: &Reiver, PinkFreud, &jeroud, &ToxicFrog, @Tamber, @Orthia, &McMartin, @Reiv, @JustBob, @himi (+5 more) |
20:53 | | Alek [Alek@Nightstar-03ja8q.il.comcast.net] has joined #code |
20:54 | | mode/#code [+o Alek] by ChanServ |
20:59 | | Netsplit *.net <-> *.split quits: @Syloq, @Checkmate, @Reiver, @Orthia, @Reiv, @celticminstrel, PinkFreud, Xon, @himi, 693AAACAZ, (+6 more, use /NETSPLIT to show all of them) |
21:01 | | Netsplit over, joins: PinkFreud, 693AAACAZ, &jeroud, Xon, &Reiver, &ToxicFrog, @Syloq, &McMartin, @Reiv, @JustBob (+6 more) |
21:01 | | PinkFreud [WhyNot@NetworkAdministrator.Nightstar.Net] has quit [Ping timeout: 121 seconds] |
21:02 | | PinkFreud [WhyNot@Pinkfreud.is.really.fuckin.lame.nightstar.net] has joined #code |
21:02 | | mode/#code [+o PinkFreud] by ChanServ |
21:08 | | Checkmate [Z@Nightstar-r9lk5l.cust.comxnet.dk] has quit [Ping timeout: 121 seconds] |
21:36 | | Thalass|cowboy [thalass@Nightstar-m49.o7s.158.104.IP] has joined #code |
21:37 | | Kindamoody is now known as Kindamoody[zZz] |
21:55 | | catadroid [catalyst@Nightstar-9th27o.dab.02.net] has joined #code |
22:29 | | Thalass|cowboy is now known as Thalass |
22:29 | | mode/#code [+o Thalass] by ChanServ |
23:54 | | Vornicus [Vorn@ServerAdministrator.Nightstar.Net] has joined #code |
23:54 | | mode/#code [+qo Vornicus Vornicus] by ChanServ |
23:58 | <~Vornicus> | <Vorn> Damn, the tech support guys at FaithNetwork are fast <Boss> Jesus Christ <Vorn> No, he takes three days to show up and then runs away before he answers any of your actual questions. |
--- Log closed Sat Jul 25 00:00:01 2015 |