| 01:01.02 | *** join/#utah bmidgley (~bmidgley@c-71-199-11-226.hsd1.ut.comcast.net) |
| 01:51.21 | *** join/#utah bmidgley (~bmidgley@c-71-199-11-226.hsd1.ut.comcast.net) |
| 01:56.02 | *** join/#utah bmidgley (~bmidgley@70.102.172.254) |
| 02:06.51 | *** join/#utah bmidgley_ (~bmidgley@c-71-199-11-226.hsd1.ut.comcast.net) |
| 02:07.38 | *** join/#utah bmidgley_ (~bmidgley@70.102.172.254) |
| 04:54.22 | *** part/#utah Nemus (~Nemus@unaffiliated/nemus) |
| 05:05.17 | *** join/#utah Trilog (~Trilog@205.197.210.92) |
| 05:08.39 | *** join/#utah ldav15 (~ldavis@65-130-182-204.slkc.qwest.net) |
| 05:11.55 | *** join/#utah mrpull (~jpollmann@216.51.56.98) |
| 05:29.17 | *** join/#utah JalenJade (~JalenJade@c-24-10-186-68.hsd1.ut.comcast.net) |
| 06:19.53 | *** join/#utah Nemus (~Nemus@unaffiliated/nemus) |
| 06:28.28 | *** join/#utah factor (~factor@74.195.160.221) |
| 06:56.49 | *** part/#utah Nemus (~Nemus@unaffiliated/nemus) |
| 09:18.35 | *** join/#utah youtah (~youtah@216.51.42.66) |
| 09:19.45 | *** join/#utah jlp_work (~japeterso@216.51.42.66) |
| 13:52.45 | *** join/#utah factor (~factor@74.195.160.221) |
| 14:07.37 | *** join/#utah emcnabb (emcnabb@nat/redhat/x-soknqdlzzojmwinl) |
| 14:07.38 | *** mode/#utah [+v emcnabb] by ChanServ |
| 14:29.42 | *** join/#utah BLZbubba (~mark@tpsit.com) |
| 14:39.11 | *** join/#utah thaddeusq (thaddeusq@conference/ldstech/x-axcxraphkjqiuasm) |
| 14:45.03 | *** join/#utah macnewbold (~macnewbol@69.169.182.227.provo.static.broadweavenetworks.net) |
| 14:56.37 | *** join/#utah utlemming (~ben@67.199.187.66) |
| 15:10.53 | *** join/#utah resplin (~resplin@esplins.org) |
| 15:16.28 | *** join/#utah jalbretsen (~jalbretse@sonic.itransact.com) |
| 15:17.08 | *** join/#utah JalenJade2nd (~JalenJade@c-24-10-186-68.hsd1.ut.comcast.net) |
| 15:36.05 | *** join/#utah pdayton1 (~pjdayton@63.251.sfcn.org) |
| 15:57.56 | *** join/#utah craigj (~craig@c-24-10-156-85.hsd1.ut.comcast.net) |
| 15:57.58 | *** join/#utah manithree (~blr@li4-76.members.linode.com) |
| 15:59.15 | *** join/#utah fungus (~olsonl@bromine.sosstaffing.com) |
| 16:02.37 | manithree | My tv is officially a relic:http://www.zdnet.com/mitsubishi-latest-to-leave-dying-rptv-market-7000008200/ |
| 16:11.25 | *** join/#utah mabes (~mabes@24-104-67-234-ip-static.hfc.comcastbusiness.net) |
| 16:19.22 | *** join/#utah kendsnyder (~kendsnyde@70-57-86-203.slkc.qwest.net) |
| 16:24.52 | *** join/#utah Nemus (~Nemus@unaffiliated/nemus) |
| 16:27.56 | *** join/#utah mahelious (~mahelious@65.46.59.10) |
| 16:33.31 | *** join/#utah mrpull (~jpollmann@216.51.56.98) |
| 16:46.11 | *** join/#utah Heartsbane_ (tsharpe@shell.xmission.com) |
| 16:46.12 | *** join/#utah Heartsbane_ (tsharpe@unaffiliated/heartsbane) |
| 16:53.12 | *** join/#utah macnewbold1 (~macnewbol@69.169.182.227) |
| 16:54.53 | *** join/#utah atoponce (~aaron@oalug/member/eightyeight) |
| 16:54.53 | *** mode/#utah [+v atoponce] by ChanServ |
| 17:08.47 | *** join/#utah jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 17:17.58 | *** join/#utah BLZbubba (~mark@tpsit.com) |
| 17:30.10 | *** join/#utah tiwula (~lane@70.89.246.241-Busname-UT.hfc.comcastbusiness.net) |
| 17:32.16 | Gate | heh, I had an rptv for a while, a roommate left it as collateral for rent he never paid |
| 17:32.38 | Gate | but then my sister wanted it, and she fights dirty. |
| 17:38.24 | *** join/#utah ezakimak (~nick@ns1.nickleippe.com) |
| 17:39.18 | *** join/#utah bmidgley (~bmidgley@70.102.172.254) |
| 17:41.02 | *** join/#utah pdayton (~pjdayton@67.21.63.138) |
| 17:48.52 | jima | i'm starting to get the impression that if you can't spell the name of the company you work for, maybe you shouldn't be working there. |
| 17:49.48 | jsmith | jima: One of those days, eh? |
| 17:50.17 | jima | dozens of employee records with our domain name misspelled. |
| 17:50.29 | jsmith | Ouch |
| 17:51.55 | Gate | lol |
| 17:52.07 | Gate | jima: mind if I ask what the domain is? |
| 17:52.21 | jima | i don't mind. i also might not answer. ;-) |
| 17:52.37 | Gate | well, what is the domain? |
| 17:53.11 | jima | i'll show you mine if you show me yours. :-D |
| 17:53.22 | Gate | rocketmade.com |
| 17:53.47 | Gate | I'm an exhibitionist. |
| 17:53.55 | Gate | flips his non-existant hair back |
| 17:53.59 | Gate | ;) |
| 17:57.48 | *** join/#utah jima (jima@fedora/jima) |
| 18:01.14 | jima | :-| |
| 18:27.50 | *** join/#utah dkelson (~dkelson@74.118.32.5) |
| 18:34.21 | manithree | Running SQL1: update ZIP_CODE z set AFFLUENCE_INDEX = (select AFFLUENCE_INDEX from ZIP_CODE_bk where zip_code = z.zip_code) |
| 18:34.28 | manithree | Doh. |
| 18:40.05 | *** join/#utah dkelson (~dkelson@74.118.32.5) |
| 18:45.51 | *** join/#utah mahelious (~mahelious@65.46.59.10) |
| 19:00.46 | Gate | eek! subquery! BURN THE WITCH |
| 19:01.00 | manithree | I didn't write that. |
| 19:12.03 | Gate | One of my favorite moments in my career was when I was given a page that was timing out and told "fix it." A few removed subqueries later the SQL runtime went from 45m to 45s. |
| 19:24.05 | manithree | Gate: was that Oracle, or MySQL, or some other db? |
| 19:28.55 | Gate | MSSQL |
| 19:30.19 | Gate | I was in a windows shop at the time, where at least %50 of their code was in MSSQL stored procedures. |
| 19:40.55 | Tene | ;_; |
| 19:56.07 | *** join/#utah craigj (~craig@c-24-10-156-85.hsd1.ut.comcast.net) |
| 19:57.03 | *** join/#utah gshipley (~gshipley@cpe-174-099-013-158.nc.res.rr.com) |
| 20:18.11 | *** join/#utah kendsnyder (~kendsnyde@70-57-86-203.slkc.qwest.net) |
| 20:20.34 | *** part/#utah manithree (~blr@li4-76.members.linode.com) |
| 20:45.34 | *** join/#utah macnewbold (~macnewbol@wfw.vivint.com) |
| 20:46.58 | Gate | Tene: at least it was more tolerable than the ASP VBScript. |
| 20:47.10 | Tene | :( |
| 20:48.28 | Tene | Gate: the marketing folks here refuse to stop using this absurd template for their queries that someone wrote ages ago; I've seen so many queries like: select foo, bar from ( select foo, bar from ... ); |
| 20:49.22 | Tene | mysql doesn't optimize that at all, just loads up a massive temp table. |
| 20:50.05 | Gate | Tene: it can't really optimize it at all, and I would consider it a waste of effort to try. |
| 20:50.06 | jsmith | Tene: If only MySQL could use more than one index on a query like that... Oh, wait... it's MySQL we're talking about :-p |
| 20:50.25 | Tene | even worse is when they try to EXPLAIN them, as mysql first runs the subquery to build the temp table, then shows them the query plan for the temp table |
| 20:50.43 | Tene | Gate: postgresql optimizes out the subquery |
| 20:51.07 | Gate | Why am I not surprised :) |
| 20:51.10 | jsmith | Tene: My point exactly :-) Why are you still using MySQL again? |
| 20:51.14 | jsmith | ducks and hides |
| 20:51.53 | Gate | Subqueries are bad design, and your engine optimizing them out is a crutch. Like most everything else in high-level languages, but still :) |
| 20:52.28 | Gate | Without having any meaningful database training, all you have to do is a simple, mental big-O analysis to realize that they are a *really* bad idea |
| 20:52.30 | Tene | jsmith: I'm very glad I'm not in engineering here. We've got a massive horrible PHP codebase. |
| 21:48.50 | *** join/#utah macnewbold (~macnewbol@wfw.vivint.com) |
| 22:00.12 | *** join/#utah pdayton (~pjdayton@74.123.198.5) |
| 22:04.09 | *** join/#utah pdayton1 (~pjdayton@67.21.63.138) |
| 22:04.19 | *** join/#utah tiwula (~lane@70.89.246.241) |
| 22:35.30 | *** join/#utah bmidgley_ (~bmidgley@71.sub-70-196-199.myvzw.com) |
| 23:52.13 | unum | this is coming to you from my new office |
| 23:53.02 | jsmith | unum: You have a new office? |
| 23:53.02 | *** join/#utah bmidgley_ (~bmidgley@71.sub-70-196-199.myvzw.com) |
| 23:53.37 | unum | jsmith: yep |
| 23:53.48 | unum | company is still in the same place |
| 23:53.50 | jsmith | unum: New employer? |
| 23:53.55 | unum | I'm just in a new office |
| 23:54.05 | jsmith | unum: Ah, just a different office in the same building |
| 23:54.19 | unum | same employer, same building |
| 23:54.21 | jsmith | Whose office did you steal? |
| 23:54.29 | unum | hire manager's... |
| 23:54.34 | unum | hiring manager's... |