| 02:25.50 | *** join/#uphpu carmony (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 02:25.50 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 02:26.10 | carmony | sup |
| 02:26.32 | *** join/#uphpu romanovic (n=romanovi@c-67-166-101-133.hsd1.ut.comcast.net) |
| 04:16.46 | *** join/#uphpu carmony (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 04:16.46 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 05:10.15 | *** join/#uphpu Utah_Dave (n=David@75-169-167-46.slkc.qwest.net) |
| 05:10.15 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 05:10.32 | Utah_Dave | any TF2 fans here? |
| 07:38.36 | *** join/#uphpu romanovic (n=romanovi@c-67-166-101-133.hsd1.ut.comcast.net) |
| 15:05.42 | *** join/#uphpu mrkrow (n=chad@166.70.178.114) |
| 15:05.42 | *** mode/#UPHPU [+v mrkrow] by ChanServ |
| 15:47.29 | *** join/#uphpu Utah_Dave (n=David@72-166-51-162.dia.static.qwest.net) |
| 15:47.29 | *** mode/#UPHPU [+o Utah_Dave] by ChanServ |
| 15:56.36 | *** join/#uphpu SunSparc (n=sparky@173.8.91.177) |
| 15:56.36 | *** mode/#UPHPU [+v SunSparc] by ChanServ |
| 15:57.50 | *** join/#uphpu eggyknap (n=jtolley@jtolley.dsl.xmission.com) |
| 15:58.28 | mindjuju1 | there is something very wrong with this - http://www.amazon.com/Star-Wars-Transformers-Crossovers-Slave/dp/B001GXRNWI/ref=pd_sim_t_2 |
| 15:58.32 | mindjuju1 | on like so many levels |
| 15:58.38 | mindjuju1 | utah_dave, did you buy TF2 ? |
| 15:59.28 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 15:59.28 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:59.53 | *** join/#uphpu josephscott (n=josephsc@75-169-252-142.slkc.qwest.net) |
| 15:59.53 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 16:01.03 | *** join/#uphpu carmony (n=justin@c-67-164-249-224.hsd1.ut.comcast.net) |
| 16:01.03 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 16:01.21 | carmony | good morning |
| 16:01.35 | mindjuju1 | morning carmony |
| 16:05.13 | *** join/#uphpu mgeary (n=mgeary@166.70.44.49) |
| 16:05.13 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 16:05.55 | carmony | so I've totally underestimated the # of people who download iPhone apps |
| 16:06.33 | mgeary | you've got an app live? |
| 16:06.42 | mgeary | what kind of #s you seeing? |
| 16:06.46 | Utah_Dave | mindjuju1: I didn't last night |
| 16:06.56 | Utah_Dave | It's still in my cart for $9.99 |
| 16:07.06 | Utah_Dave | You like it, right? |
| 16:07.08 | carmony | it went live sunday morning |
| 16:07.16 | carmony | we're seeing about 1-3 users every 5 minutes |
| 16:07.18 | carmony | its a free ap |
| 16:07.20 | carmony | app* |
| 16:07.44 | carmony | but going from 50-100 user sign ups a day, to 1000-2000 user sign ups a day is HUGE |
| 16:08.28 | carmony | and that is without being on the "featured" or "whats new" page |
| 16:08.35 | carmony | just people searching dating |
| 16:09.09 | *** join/#uphpu redroy (n=kenner@69.169.153.60.provo.static.broadweave.net) |
| 16:09.46 | *** join/#uphpu carmony_ (n=justinca@c-67-164-249-224.hsd1.ut.comcast.net) |
| 16:10.11 | mgeary | carmony: awesome |
| 16:10.30 | mgeary | is it an html iphone app? or objC? |
| 16:10.59 | mindjuju1 | utah_dave, it is a lot of fun |
| 16:11.15 | *** join/#uphpu redroy (n=kenner@69.169.153.60.provo.static.broadweave.net) |
| 16:11.19 | mindjuju1 | and they just released another patch on it where they tweaked a few things to better balance the game |
| 16:11.28 | Utah_Dave | ok, I think I'm going to go ahead and buy it |
| 16:11.53 | carmony_ | Obj-c |
| 16:12.04 | carmony_ | we have a web based app |
| 16:12.08 | carmony_ | had one for awhile |
| 16:12.35 | carmony_ | but the attention our iPhone App is getting compared to the HTML app is vastly different |
| 16:20.00 | mgeary | but i do wish i didn't have to deal with garbage collection/memory management. PHP and Python have spoiled me |
| 16:22.30 | carmony | that is the biggest pain |
| 16:25.34 | SunSparc | Got any good resources for Objective C beginners? I have the ADC iPhone Dev Center resource. Any others you think are good? |
| 16:25.52 | mgeary | there's a Stanford class on it that has online docs that look good |
| 16:26.00 | mgeary | http://www.stanford.edu/class/cs193p/cgi-bin/index.php |
| 16:26.17 | mgeary | wish the course lectures were likewise online |
| 16:26.47 | mgeary | also #iphone and #iphonedev |
| 16:26.50 | carmony | I would also start playing out with regular Cocoa development |
| 16:27.55 | SunSparc | Good tips. Thanks. |
| 16:28.23 | SunSparc | I also found an iphone channel on irc.saurik.net |
| 16:28.44 | mgeary | how does it compare to freenodes? |
| 16:29.08 | SunSparc | Looks like a personal server. But has quite a few people on it. |
| 16:29.26 | SunSparc | I got the reference from one of the freenode channel topics. |
| 16:56.17 | Utah_Dave | mindjuju1: in TF2, do you play on teams together? Or do you play it by yourself? |
| 16:56.42 | mindjuju1 | teams |
| 16:57.12 | mindjuju1 | and depending on where you play, some guys take it real serious and play with strategies, otherwise, it's loose |
| 16:57.29 | mindjuju1 | but ways is fun, but i like the less regulated, just straight up play |
| 16:57.49 | SunSparc | TF2++ |
| 16:58.10 | Utah_Dave | OK, I'm going to buy it. You'll have to give me pointers |
| 16:58.21 | mindjuju1 | fo sho |
| 16:58.25 | SunSparc | If you are going to buy it, you may as well just buy the Orange Box. |
| 16:58.35 | SunSparc | That way to get Portal as well. |
| 16:58.54 | Utah_Dave | What's the Orange Box? |
| 16:59.17 | SunSparc | Good question: http://whatistheorangebox.com/ |
| 16:59.19 | SunSparc | :) |
| 16:59.37 | mindjuju1 | i should get that |
| 16:59.40 | mindjuju1 | i wonder how much it is |
| 16:59.51 | SunSparc | $30 is a steal |
| 17:00.15 | mgeary | SunSparc: do you know if any of those work in Parallels/Crossover Games? |
| 17:00.24 | SunSparc | They do not. |
| 17:00.25 | mindjuju1 | well hold off then utah_dave, if i recall, if id do buy orangebox, i can give you my TF2 license |
| 17:00.26 | SunSparc | :( |
| 17:00.37 | mgeary | what version of DirectX do they run on? |
| 17:00.39 | mindjuju1 | seems like i read that somewhere |
| 17:00.52 | SunSparc | mgeary: Hmmm, not sure |
| 17:01.12 | *** join/#uphpu eggyknap (n=jtolley@jtolley.dsl.xmission.com) |
| 17:01.34 | Utah_Dave | SunSparc: is Portal a half life game as well? |
| 17:01.45 | SunSparc | A Valve game, yes. |
| 17:01.59 | mindjuju1 | and supposedly WAY FREAKIN' cool |
| 17:02.02 | mindjuju1 | but i haven't played it |
| 17:02.07 | SunSparc | Not supposedly. :) |
| 17:02.32 | SunSparc | I would have paid $40 for Portal alone. |
| 17:02.44 | Utah_Dave | all right, fine. I'll buy the freaking Orange Box! Darn SunSparc! |
| 17:02.51 | SunSparc | lol |
| 17:02.57 | SunSparc | You will thank me. |
| 17:03.24 | DexterTheDragon | I payed $40 for portal alone, just happened to get TF2 and HL as a bonus |
| 17:03.38 | SunSparc | DexterTheDragon: Heh, good way to look at it. |
| 17:03.47 | mindjuju1 | so, my question about orange box is though, i played hl2 on xbox |
| 17:03.50 | mindjuju1 | twas awesome |
| 17:04.03 | mindjuju1 | but is there much diff between xbox play of hl2 and computer play? |
| 17:04.29 | DexterTheDragon | well the orange box has HL2, episode 1 and episode 2 |
| 17:04.35 | mindjuju1 | yeah, i know |
| 17:04.43 | mindjuju1 | i'd have bought it for the xbox, but only 1 prob |
| 17:04.49 | mindjuju1 | i don't own an xbox 360 |
| 17:05.08 | mindjuju1 | don't know if i want to spring for one anytime soon, either |
| 17:05.24 | mindjuju1 | maybe wait till after Christmas |
| 17:05.56 | mindjuju1 | not like i have th emoney for it anyway |
| 17:06.00 | DexterTheDragon | I just think HL controls better on the pc than the xbox |
| 17:06.07 | mindjuju1 | hmmm |
| 17:06.14 | DexterTheDragon | but thats a FPS preference I guess |
| 17:06.26 | mindjuju1 | well, i did play HL on comp |
| 17:06.28 | mindjuju1 | twas fun |
| 17:08.02 | SunSparc | Comfy? |
| 17:08.49 | carmony | yeah, but I got one that had really good posture and controls :P |
| 17:09.05 | carmony | I lean back way to much when I work :P |
| 17:09.33 | SunSparc | I hear ya. My lower back is so weak from all the slouching I do. |
| 17:09.47 | Utah_Dave | just bought my Orange Box |
| 17:10.00 | SunSparc | Utah_Dave: Congrats! |
| 17:10.12 | Utah_Dave | I'm excited about the guest passes |
| 17:10.19 | carmony | uggg... this bug is frustrating |
| 17:10.25 | Utah_Dave | I have a couple buddies here at work that wanted to try out TF2 first. |
| 17:10.43 | SunSparc | Utah_Dave: Yeah, those guest passes will hook them. |
| 17:10.45 | mindjuju1 | utah_dave, we ought to setup a time to play |
| 17:10.48 | carmony | let me know if you run out of guest passes, since I have several |
| 17:10.49 | SunSparc | carmony: What's up? |
| 17:10.51 | Utah_Dave | let's do that |
| 17:10.53 | mindjuju1 | sunsparc, you still running that server? |
| 17:10.56 | SunSparc | Yep |
| 17:11.07 | SunSparc | games.mediarain.com |
| 17:11.08 | carmony | k, every now and then, a user reports they are unable to upload their photo to their profile |
| 17:11.14 | Utah_Dave | carmony: thanks. It looks like I have 1 guest pass. I have 2 buddies that I'd like to have try it out |
| 17:11.21 | mindjuju1 | utah_dave, let's meet up over at Sunsparc's place where you can learn the controls before you hit noob TF2 servers |
| 17:11.32 | mindjuju1 | i promise not to dominate you too much |
| 17:11.34 | carmony | and the only relation is that every time it seems the file is names photo.jpg |
| 17:11.35 | mindjuju1 | ;) |
| 17:11.36 | Utah_Dave | :) |
| 17:11.50 | carmony | and I can't get it to reproduce for the life of me |
| 17:11.57 | carmony | but we've had 4 people email already today. |
| 17:12.09 | SunSparc | Those kind of bugs are hard. |
| 17:12.25 | carmony | I have no clue |
| 17:12.31 | carmony | as to wtf:P |
| 17:12.43 | Utah_Dave | Hey, it looks like it's going to take a while to download TF2 through Steam. Will it screw things up if I have to shut my computer down during the download? |
| 17:12.51 | Utah_Dave | Or will it just pick up where it left off? |
| 17:13.02 | carmony | pick up where it left off |
| 17:13.20 | SunSparc | carmony: Take a break with this -> http://funnyvideos.todaysbigthing.com/2008/11/12 |
| 17:13.35 | SunSparc | Utah_Dave: Steam rocks. |
| 17:13.40 | Utah_Dave | cool |
| 17:14.16 | carmony | LOL SunSparc, what the heck is up with that dog? |
| 17:14.39 | SunSparc | lol, I don't know. |
| 17:14.47 | SunSparc | Too much coffee perhaps |
| 17:15.51 | carmony | http://www.todaysbigthing.com/2008/11/10 hahahaha |
| 17:16.17 | SunSparc | LOL, yeah, saw that one already. Funny. |
| 17:16.33 | SunSparc | Love the paperclip |
| 17:19.15 | carmony | have you seen the 1994 verion of 24? |
| 17:19.55 | carmony | http://www.collegehumor.com/video:1788161 |
| 17:24.30 | SunSparc | lol |
| 17:24.54 | *** join/#uphpu eggyknap (n=jtolley@jtolley.dsl.xmission.com) |
| 17:27.01 | *** join/#uphpu fungus (n=olsonl@bromine.sosstaffing.com) |
| 17:27.01 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 17:28.35 | mindjuju1 | for fungus and other sysadmins who might have IE running - http://www.computerworld.com/action/article.do?command=viewArticleBasic&articleId=9123338&intsrc=hm_ts_head |
| 17:28.58 | mindjuju1 | i wish there was at least 1 month go by that I didn't feel like I had to scramble to patch |
| 17:31.59 | carmony | lol |
| 17:32.04 | carmony | I'm glad I'm not a sys admin |
| 17:33.03 | SunSparc | Especially a windows sysadmin |
| 17:33.23 | carmony | Anyone here play the new CoD? |
| 17:34.04 | SunSparc | No, but heard it is alright. |
| 17:34.23 | SunSparc | Seen some footage. The gore seems a bit overboard. |
| 17:35.22 | mindjuju1 | SunSparc - that's why i dig on TF2 |
| 17:35.41 | mindjuju1 | it has gore, but with the animation and stuff, it isn't the central point |
| 17:36.06 | SunSparc | Yeah, it is not realistic. |
| 17:39.23 | carmony | anyone know of anything like myipneighbors.com? its down atm |
| 17:41.33 | mindjuju1 | don't, sorry |
| 17:42.21 | mindjuju1 | sad story of barely literate computer user who got foobed by pron pop ups - knowing some of the poeple here and thier skill set, i believe it - http://www.computerworld.com/action/article.do?command=viewArticleBasic&taxonomyName=Networking+and+Internet&articleId=9121839&taxonomyId=16&pageNumber=1 |
| 17:42.39 | mindjuju1 | sad that it ws school teacher |
| 17:49.15 | SunSparc | Lame |
| 17:54.29 | *** join/#uphpu thebigdog (n=thebigdo@zeus.thebigdog.biz) |
| 17:54.29 | *** mode/#UPHPU [+o thebigdog] by ChanServ |
| 18:17.49 | *** join/#uphpu orsonj (n=orson@b22222.bookstore.usu.edu) |
| 18:17.49 | *** mode/#UPHPU [+v orsonj] by ChanServ |
| 18:20.39 | carmony | okay..... wow... my DB is at 90% usage |
| 18:27.35 | SunSparc | 90% of what? |
| 18:31.00 | carmony | CPU |
| 18:31.25 | SunSparc | Ah, that is no fun |
| 18:42.02 | unum | 90% usage of all your cpu's? |
| 18:50.10 | carmony | yup |
| 18:50.23 | carmony | I know what I need to do to fix it |
| 18:50.40 | carmony | I'd say about 80% of the queries could be cached |
| 18:51.15 | unum | a materialized view did wonders for my database issues :) |
| 19:10.04 | fungus | memcached |
| 19:46.11 | carmony | yikes, no good |
| 19:47.18 | mindjuju1 | yeah |
| 19:48.06 | carmony | think you're job is at risk? |
| 19:48.08 | carmony | your* |
| 19:48.17 | mindjuju1 | yes and no |
| 19:48.29 | mindjuju1 | my boss and I are the only tech guys left |
| 19:48.40 | mindjuju1 | he doesn't know my end of things and i don't know his |
| 19:48.46 | mindjuju1 | we don't overlap enough |
| 19:49.15 | mindjuju1 | so, no i don't think my job is at risk at this time, yes i think the whole company is at risk |
| 19:49.43 | mindjuju1 | in the interim though, i do get to see a side of business that is very interesting and good to learn from |
| 19:51.28 | carmony | and what side is that? |
| 19:52.32 | mindjuju1 | i'll prolly get laughed at for quoting him, but |
| 19:52.58 | mindjuju1 | in one of Bill Gates books, he talks about industry not staying ahead of the curve |
| 19:53.30 | mindjuju1 | and that companies that don't realize the market / market trends / market forecasts correctly are doomed to failure - long term |
| 19:53.38 | mindjuju1 | kinda like what's happening with them and google |
| 19:53.48 | carmony | lol, yeah |
| 19:54.38 | mindjuju1 | so even a several years ago when I first got here, I prepared for the company a list of likely competitors and my suggestions of what they do about it. |
| 19:54.52 | mindjuju1 | funny, those guys are eating our lunch now |
| 19:55.36 | mindjuju1 | yipes! |
| 19:55.47 | mindjuju1 | actually, i had some little caesar's pizza today |
| 19:55.57 | mindjuju1 | small celebration for December bdays |
| 19:56.10 | SunSparc | Eeewww |
| 19:56.27 | mindjuju1 | LC pizza isn't bad |
| 19:56.30 | mindjuju1 | it's decent |
| 19:56.38 | SunSparc | Compared to what? |
| 19:56.59 | carmony | mindjuju1, what did they say? |
| 19:57.09 | SunSparc | I have had it too much to think of it as anything but heartburn inducing cardboard. |
| 19:57.09 | mindjuju1 | cardboard with tomato sauce, pizza hut, etc |
| 19:57.20 | SunSparc | lol |
| 19:57.25 | mgeary | heh. here's another cardboard vote |
| 19:57.37 | mgeary | though it's edible, if it's all you can get |
| 19:57.40 | mindjuju1 | carmony, they just nodded and shelved my ideas / dire3ction |
| 19:57.53 | SunSparc | ~good pizza |
| 19:57.53 | jbot | Good pizza, good! Have a cookie... oh no! The cookie jar is dry! |
| 19:58.03 | SunSparc | ~goodpizza |
| 19:58.07 | mindjuju1 | so out of curiosity, where do you get good pizza? |
| 19:58.22 | SunSparc | jbot, goodpizza is Papa John's |
| 19:58.22 | jbot | okay, SunSparc |
| 19:58.36 | SunSparc | jbot, badpizza is Little Ceaser's |
| 19:58.36 | jbot | okay, SunSparc |
| 19:58.57 | carmony | jbox, carmony is the man! |
| 19:59.05 | carmony | :P |
| 19:59.13 | SunSparc | Actually, that Nicolitalia is good stuff too. |
| 19:59.31 | SunSparc | ~carmony |
| 20:00.22 | orsonj | although, Papa John's > Little Ceaser's |
| 20:03.35 | thebigdog | by far |
| 20:03.59 | carmony | Anyone here been to the Ogden Pizzaria> |
| 20:04.05 | carmony | That place is pretty good :) |
| 20:04.26 | herlo | carmony: you should go to firehouse pizza in Logan or Centerville :) |
| 20:05.08 | tierra | I don't really like Firehouse |
| 20:05.26 | carmony | I like spicy pizza sauce |
| 20:05.35 | mgeary | i like only a very little sauce |
| 20:05.36 | tierra | you might like it then |
| 20:05.43 | mgeary | too much sauce really tanks a pizza |
| 20:05.51 | mgeary | i want sauce, i'll eat pasta |
| 20:06.16 | tierra | yeah, I like a good amount of sauce |
| 20:06.28 | tierra | personally, I don't think anywhere beats The Pie |
| 20:06.44 | mindjuju1 | was just going to say The Pie was good eats |
| 20:06.59 | carmony | I had a bad experience with The Pie by weber state |
| 20:07.35 | SunSparc | $mgeary = new MGeary($favoritePizza = null); |
| 20:07.59 | mindjuju1 | was it a bad pie or bad service? |
| 20:08.00 | SunSparc | mgeary: Update your $favoritePizza propery. |
| 20:08.05 | carmony | bad service |
| 20:08.11 | mindjuju1 | ah |
| 20:08.22 | mindjuju1 | did they "add something extra" to your pizza? |
| 20:08.29 | mgeary | $mgeary->favoritePizza = "Brick Oven Pizza"; |
| 20:08.31 | carmony | Last winter, during one of those nasty storms, we lived about 5 mins from the pie |
| 20:08.50 | SunSparc | jbot, goodpizza is also Brick Over Pizza |
| 20:08.50 | jbot | okay, SunSparc |
| 20:09.06 | carmony | we called up, order a Chicken Ranch (or something Chicken) pizza, told us it would an 1 1/2 wait |
| 20:09.25 | carmony | we said that was fine, cause we didn't have any food at the house, and our cars couldn't leave the apartment parking lot :P |
| 20:09.59 | carmony | so they get there about 2 hours, and with the weather, we understood. However, we were STARVED. |
| 20:10.14 | carmony | Pay for the pizza, the guy leaves, we open it up..... and its a Greek Pizza |
| 20:10.35 | mindjuju1 | bummer |
| 20:10.38 | carmony | with greese lamb and stuff |
| 20:10.44 | mindjuju1 | i've had it before |
| 20:10.55 | carmony | we call them up, and it takes another 1 1/2 to get our correct pizza |
| 20:10.56 | mindjuju1 | i ordered it with Tierra, that one geek lunch, remember? |
| 20:12.02 | tierra | the chicken ranch you mean? |
| 20:12.08 | mindjuju1 | twas over by U of U |
| 20:12.20 | tierra | yeah, it was only me, mindjuju1, and eco at that geek lunch, heh |
| 20:12.44 | mindjuju1 | and some U of U sorority of hawties that it was hard not to look at |
| 20:13.06 | carmony | LOL |
| 20:13.51 | jsmith-teaching | mindjuju1: No wonder you only have one good eye! |
| 20:14.21 | *** mode/#UPHPU [+o mindjuju] by ChanServ |
| 20:14.27 | mindjuju | sup jsmith-teaching |
| 20:14.35 | mindjuju | i saw your pic on facebook, that's freakin awesome |
| 20:14.39 | mindjuju | gotchi 2.0 |
| 20:46.57 | carmony | yuckie... this sql query is being joined across 26 tables |
| 20:48.32 | mindjuju | no way, 26 table join? |
| 20:48.44 | carmony | no joke |
| 20:49.01 | mindjuju | really? |
| 20:49.37 | carmony | yup, and this query is executed on all over the place :P |
| 20:49.38 | DexterTheDragon | mindjuju: you mean you've never joined 26 tables? |
| 20:51.24 | mindjuju | most joins has to be about 4 |
| 20:51.28 | mindjuju | i doubt 5 but maybe |
| 20:51.50 | DexterTheDragon | your just not living |
| 20:51.59 | carmony | lol |
| 20:57.24 | thebigdog | carmony, that is crazy...what are you in nf5? |
| 20:58.12 | carmony | the problem is that member's profile information is spread across a 15 page survey |
| 20:58.14 | mindjuju | nf5 or no, i can't imagine it being very efficent |
| 20:58.34 | carmony | each survey page has its own table |
| 20:58.39 | mindjuju | oh nice |
| 20:58.57 | carmony | Right now I'm modifying the system to "cache" that information :) |
| 20:59.10 | mindjuju | i mean, sure everybody wants a survey, but who'd want to slap the info into a graph?? |
| 20:59.26 | mindjuju | extrapoliate survey data? psh! |
| 20:59.35 | unum | the most join I do is because of all my subqueries |
| 20:59.36 | carmony | lol, the problem is this is a dating site :P |
| 20:59.45 | unum | I think there's only three tables... |
| 21:00.02 | mindjuju | unum, it's funny you say that |
| 21:00.19 | mindjuju | cause every now and then, we have a holy war on what's better, joins or subqueries |
| 21:00.31 | mindjuju | and depending on the situation, i go one way or the other |
| 21:00.43 | mindjuju | but seems like macnewbold has some data that joins are more efficent |
| 21:00.57 | mindjuju | seems like he said that once, though i'm sure db and NF play factors |
| 21:01.30 | unum | I only use subqueries when I'm quering the table twice |
| 21:01.33 | mindjuju | maybe brasto or eggyknap have a comment |
| 21:03.48 | eggyknap | All subqueries are not equal. Joins are always better than correlated subqueries, if you can write your query that way, but some queries aren't possible without correlated subqueries |
| 21:04.47 | mindjuju | does that hold true for all databases or just some? |
| 21:04.47 | carmony | sounds about right to me |
| 21:06.02 | eggyknap | A correlated subquery is one where a subquery is run once for every row in some outer query. That's really slow in any database, but some databases (postgresql is one of these, for instance) will try to find ways to rewrite your query as a join to make it work faster. |
| 21:06.43 | unum | SELECT gender,blue_count,brown_count,green_count FROM people NATURAL LEFT JOIN(SELECT gender,COUNT(*) AS blue_count FROM people WHERE eye_color=1) AS blues etc etc etc |
| 21:06.48 | unum | is how I use subqueries |
| 21:07.19 | eggyknap | That's perfectly normal, and doesn't generate nested loops. |
| 21:07.37 | eggyknap | (note that you're doing both a join and a subquery, for the holy warriors out there) |
| 21:07.48 | mindjuju | Natural left join? i'm going to have to read up on what the natural is |
| 21:08.00 | mindjuju | there is always more that needs to be studied! |
| 21:08.19 | jsmith-teaching | Why use both a JOIN *and* a subquery? |
| 21:08.25 | unum | it tells the database to guess which columns should be used for a join |
| 21:08.32 | unum | jsmith-teaching: because I don't know any better |
| 21:08.47 | eggyknap | jsmith-teaching: so you can treat the results of the subquery as a table, and join against those. It's a really common thing to do, and not at all a bad idea. |
| 21:08.57 | unum | whew |
| 21:09.04 | jsmith-teaching | unum: Sure... I'd just do that as another join though... |
| 21:09.17 | jsmith-teaching | Sure, it works... it's just computationally expensive |
| 21:09.17 | eggyknap | mindjuju: natural joins mean you don't have to tell it explicitly what columns to join on. It just chooses all columns that are named identically in both tables. |
| 21:09.31 | mindjuju | ah |
| 21:09.34 | mindjuju | that's cool! |
| 21:09.35 | unum | jsmith-teaching: how would you do that as a join without the subquery |
| 21:09.44 | eggyknap | jsmith-teaching: if your query planner is any good, it will prefer the subquery version. That way the rows from one table get filtered before being joined, which is less work for the database in total |
| 21:10.28 | unum | mindjuju: just be careful I accidental name mutilple columns of two tables the same thing |
| 21:10.38 | unum | when ever I try to natural join those I get bad results |
| 21:10.57 | unum | so you could end up with issues if someone add new columns later on as well |
| 21:13.26 | mgeary | i don't like natural joins |
| 21:13.28 | mgeary | too much "magic" |
| 21:13.41 | unum | http://unum5.org/sub.txt <- so is there an other way to this(I mean with out the sub queries) |
| 21:13.56 | unum | though I guess eggyknap says this is the fastest way anyways |
| 21:14.01 | unum | so it doesn't matter |
| 21:14.15 | eggyknap | mgeary: I agree. Like select * |
| 21:14.20 | mgeary | yeah |
| 21:14.33 | mgeary | i fully-qualify every field in my sql |
| 21:14.41 | thebigdog | unum, what are you trying to do? |
| 21:14.42 | mgeary | well, not to the DB, but to the table |
| 21:15.15 | unum | mgeary: I think I'm regretting using them so much, because if people add columns it will screw up my selects |
| 21:15.36 | thebigdog | i dont think you need to do joins on that query |
| 21:18.44 | eggyknap | unum: on that query, you should only need one subquery anyway, though I still claim the join is a good idea. It seems you'd get problems with the query as pasted on that site, though, because you're using an aggregated column with an unaggregated column and no group by clause. |
| 21:43.56 | unum | eggyknap: I knew I was forgetting something |
| 21:44.03 | unum | my group clause |
| 21:45.36 | unum | there I think that is better |
| 21:46.01 | unum | oh and I see how I can do the one subquery |
| 21:46.19 | unum | I do COUNT(eye_color=1) right? |
| 21:46.51 | unum | I could probably simplify some of my real queries that way. |
| 21:47.33 | eggyknap | I'd try count(1) group by gender, eye_color |
| 21:47.43 | eggyknap | ...or count(*) if you prefer |
| 21:48.09 | eggyknap | I just do count(1) out of habit. I've an unproven idea that it's faster than count(*) because it doesn't require fetching the entire row |
| 21:48.33 | unum | that makes sense |
| 21:49.53 | unum | my real queries are a lot more complicated because I'm doing sums |
| 21:50.23 | unum | now I see what else is different, that was a really bad example |
| 21:57.35 | olds_ | SELECT gender, COUNT(eye_color=1) AS blues, COUNT(eye_color=2) AS brown, COUNT(eye_color=3) AS greens FROM people GROUP BY gender; |
| 21:57.39 | olds_ | seems like that should work |
| 22:06.59 | macnewbold | joins++ ; subqueries-- |
| 22:08.13 | SunSparc | being able to trust your abstraction layer to do it all for you++ |
| 22:08.31 | synic | eating icecream instead of working: priceless |
| 22:08.41 | SunSparc | lol |
| 22:08.44 | SunSparc | synic: ftw |
| 22:08.54 | synic | :) |
| 23:06.46 | mindjuju | utah_dave, tell me when you're going to game TF2 |
| 23:06.50 | mindjuju | and I'll try to be online then |
| 23:07.00 | mindjuju | i could be on around 8ish |
| 23:07.04 | mindjuju | or 7:ish |
| 23:37.30 | *** join/#uphpu eggyknap (n=jtolley@c-67-172-238-126.hsd1.ut.comcast.net) |