code logs -> 2015 -> Fri, 24 Jul 2015< code.20150723.log - code.20150725.log >
--- 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
code logs -> 2015 -> Fri, 24 Jul 2015< code.20150723.log - code.20150725.log >

[ Latest log file ]