| 00:26.16 | *** join/#utos AlmostThere (n=Woody@75.141.213.221) |
| 00:27.39 | *** part/#utos AlmostThere (n=Woody@75.141.213.221) |
| 00:54.54 | *** join/#utos tristanbob___ (n=quassel@c-67-164-249-113.hsd1.ut.comcast.net) |
| 01:00.52 | mindjuju | ~apb heartsbane |
| 01:00.53 | infobot | ACTION hires baby Lyssa to find heartsbane |
| 01:11.53 | *** join/#utos mindjuju (n=mindjuju@mail.billgood.us) |
| 01:22.20 | *** join/#utos mindjuju (n=mindjuju@mail.billgood.us) |
| 01:22.24 | Supaplex | hiya mindjujujujujujujujujuju |
| 01:22.35 | mindjuju | heya supaplex |
| 01:22.45 | mindjuju | for some reason my pidgin install keeps crashing |
| 01:22.47 | Supaplex | ow's it goin? |
| 01:22.56 | Supaplex | humm |
| 01:23.08 | Supaplex | it's buggy? |
| 01:25.45 | mindjuju | not usually |
| 01:25.48 | mindjuju | but today it is |
| 01:30.24 | *** join/#utos mindjuju (n=mindjuju@mail.billgood.us) |
| 01:36.30 | *** join/#utos tristanbob___ (n=quassel@c-67-164-249-113.hsd1.ut.comcast.net) |
| 01:39.35 | *** join/#utos justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 02:03.26 | Heartsbane | mindjuju: wut? |
| 02:16.55 | herlo | mindjuju: I'd suggest using empathy if you wanna try it |
| 02:18.02 | mindjuju | try what? |
| 02:18.52 | mindjuju | herlo^^ |
| 02:23.04 | *** join/#utos justincarmony__ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 02:24.21 | mindjuju | d00d herlo, i've just had an epiphany--lightning just struck my brain |
| 02:24.53 | herlo | empathy |
| 02:24.54 | mindjuju | chicken wings + hawt sauce == buffalo wings (yum) but what about turkey wings which have like 10x the meat |
| 02:25.01 | herlo | mindjuju: the app is called empathy |
| 02:25.07 | mindjuju | what app |
| 02:25.12 | mindjuju | ~wiki empathy |
| 02:25.16 | herlo | 18:22 < mindjuju> for some reason my pidgin install keeps crashing |
| 02:25.33 | herlo | mindjuju: that's not going to work :) |
| 02:25.37 | herlo | 18:22 < mindjuju> for some reason my pidgin install keeps crashing |
| 02:25.41 | mindjuju | oh |
| 02:25.44 | herlo | haha |
| 02:25.47 | herlo | :) |
| 02:25.53 | mindjuju | is empathy cross platform? |
| 02:25.54 | herlo | 19:16 <@herlo> mindjuju: I'd suggest using empathy if you wanna try it |
| 02:26.01 | herlo | mindjuju: dunno, you could check... |
| 02:26.11 | mindjuju | and moar importantly, what do you think about my wings idea |
| 02:26.41 | mindjuju | them would be like Texan sized buffalo wangs |
| 02:27.13 | mindjuju | course turkey wings have a stronger taste than chicken wings |
| 02:29.32 | *** join/#utos redbeard2 (n=jphall@techhat.dsl.xmission.com) |
| 02:32.48 | herlo | doesn't enjoy buffalo wings, though he loves hot wings |
| 02:33.08 | herlo | I also think that turkey wings are a bit tougher as well |
| 02:34.25 | mindjuju | @herlo - hot wings == buffalo wings |
| 02:34.34 | herlo | mindjuju: awesome! |
| 02:34.45 | herlo | mindjuju: I think I'll still like chicken wings better :) |
| 02:37.03 | *** join/#utos utahcon (n=utahcon@li51-147.members.linode.com) |
| 02:37.47 | *** join/#utos utahcon (n=utahcon@li51-147.members.linode.com) |
| 02:42.12 | *** join/#utos utahcon_ (n=utahcon@72.14.185.147) |
| 02:54.09 | goozbach | mindjuju: elephant wings |
| 02:55.22 | mindjuju | that's an awesome name for that! |
| 02:57.15 | herlo | well, well, well. Look who finally came up with something useful, Mr. goozbach |
| 02:57.16 | herlo | :) |
| 03:01.11 | goozbach | herlo: no fair, you got to celebrate turkeyday early |
| 03:03.02 | herlo | :) I get to celebrate it again on Thursday :) |
| 03:03.29 | herlo | goozbach: I get two of my Favorite holiday. The only better thing could have been that my son was at one or both :/ |
| 03:03.53 | goozbach | is that your family in the Kentucky thanksgiving? |
| 03:04.24 | goozbach | why is gnucash so difficult to use? |
| 03:04.33 | goozbach | I try again and again to use it |
| 03:04.39 | goozbach | I can never get over the hump |
| 03:06.30 | herlo | goozbach: no, that's Jennifer's family |
| 03:06.31 | herlo | and a few friends |
| 03:06.43 | herlo | goozbach: what don't you understand? I use gnucash a lot |
| 03:06.53 | goozbach | I don't know |
| 03:07.04 | goozbach | I can't get my head around the different accounts |
| 03:07.17 | goozbach | I want a savings account and a checking account |
| 03:07.36 | goozbach | and I want 10-15 expense categories |
| 03:07.41 | goozbach | and two income streams |
| 03:07.47 | peno | ms money!! |
| 03:07.49 | peno | ducks |
| 03:07.50 | *** join/#utos tristanbob___ (n=quassel@67.164.249.113) |
| 03:07.55 | goozbach | anyone used mint.com |
| 03:08.01 | goozbach | I'm thinking of giving it a shot |
| 03:10.21 | herlo | goozbach: interesting, it's pretty easy imo |
| 03:10.31 | herlo | will have to open his gnucash to help though... |
| 03:10.35 | herlo | hang on a bit |
| 03:15.02 | goozbach | hmmm |
| 03:15.13 | goozbach | I just logged into mint.com |
| 03:15.26 | goozbach | it automaticly calculated my categories |
| 03:15.31 | herlo | k |
| 03:15.36 | goozbach | I'm gonna ride this wave for a bit |
| 03:15.38 | herlo | if that's what you wanna do :) |
| 03:15.40 | Gate | wow, someone actually had the bot explain the roots of the word empathy? |
| 03:15.47 | herlo | I'm headed out ofr a bit anyway... |
| 03:15.49 | ilan | goozbach: ive been using it for a bit for personal tracking. |
| 03:17.25 | *** join/#utos fozzmoo (n=fozz@174.52.44.58) |
| 03:20.45 | *** join/#utos undertakingyou (n=will@undertakingyou.dsl.xmission.com) |
| 03:20.45 | *** join/#utos fozzmoo (n=fozz@174.52.44.58) |
| 03:20.45 | *** join/#utos tristanbob___ (n=quassel@67.164.249.113) |
| 03:20.45 | *** join/#utos optikal (i=optikal@failcore.com) |
| 03:20.45 | *** join/#utos Nafai (n=Nafai@travishartwell.net) |
| 03:20.45 | *** join/#utos harleypig (n=harleypi@harleypig.com) |
| 03:20.45 | *** join/#utos unum (n=unum@207.192.70.23) |
| 03:20.45 | *** join/#utos bgerber (n=gerberb@suse103.zenez.com) [NETSPLIT VICTIM] |
| 03:20.45 | *** join/#utos ChanServ (ChanServ@services.) |
| 03:20.45 | *** mode/#utos [+oo undertakingyou ChanServ] by irc.freenode.net |
| 03:21.24 | goozbach | holy crap! mint.com might be just what I want |
| 03:21.24 | goozbach | pull the data and figure it out |
| 04:15.12 | Nafai | goozbach: http://wiki.github.com/jwiegley/ledger |
| 04:25.11 | *** join/#utos justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 05:16.04 | *** join/#utos maquis (n=maquis@c-98-247-72-114.hsd1.wa.comcast.net) |
| 05:26.46 | *** join/#utos fozzmoo (n=fozz@c-174-52-44-58.hsd1.ut.comcast.net) |
| 06:23.27 | *** join/#utos jpc (n=jw@unaffiliated/javawizard2539) |
| 06:27.37 | *** join/#utos mindjuju (n=mindjuju@mail.billgood.us) |
| 06:27.37 | *** join/#utos peno (i=peno@peno.com) |
| 06:28.10 | *** join/#utos herlo (n=clints@fedora/herlo) |
| 06:28.10 | *** join/#utos stderr (n=stderr@truedat.org) |
| 06:28.10 | *** join/#utos sontek (n=janderso@opensuse/member/Sontek) |
| 06:28.10 | *** join/#utos uxp (n=uxp@uxp.dsl.xmission.com) |
| 06:28.10 | *** mode/#utos [+o herlo] by irc.freenode.net |
| 06:42.53 | josephnexus | gnucash is amazing |
| 06:43.17 | josephnexus | gnucash does double entry accounting |
| 06:43.20 | josephnexus | i could teach you how to do it |
| 06:43.25 | josephnexus | goozbach |
| 06:57.49 | Supaplex | goozbach ohhhh goozbach |
| 08:59.50 | *** part/#utos josephnexus (n=josephne@174-19-239-95.bois.qwest.net) |
| 14:13.46 | *** join/#utos fugue88 (n=dsowen@fugue88.dsl.xmission.com) |
| 14:39.31 | *** join/#utos thaddeusq (n=thaddeus@216.49.181.128) |
| 15:02.11 | *** join/#utos josephnexus (n=josephne@174-19-239-95.bois.qwest.net) |
| 15:30.06 | *** join/#utos justincarmony_ (n=justinca@98.202.44.233) |
| 15:32.08 | *** join/#utos nibb13 (n=nibb13@206.71.87.254) |
| 15:40.01 | *** join/#utos redbeard2 (n=jphall@208.110.152.42) |
| 15:42.05 | *** join/#utos Jayce^ (n=Jayce^@66.147.243.115) |
| 15:52.54 | *** join/#utos tristanbob_ (n=tristanb@ubuntu/member/tristanbob) |
| 16:25.02 | *** join/#utos jpc (n=jw@unaffiliated/javawizard2539) |
| 16:30.32 | *** join/#utos neybar (n=jalance@pool-71-116-84-222.snfcca.dsl-w.verizon.net) |
| 16:37.00 | *** join/#utos fozzmoo (n=fozz@67.214.226.66) |
| 16:51.10 | *** join/#utos cro (n=cro@166-70-222-105.ip.xmission.com) |
| 17:54.10 | *** join/#utos jpc (n=jw@unaffiliated/javawizard2539) |
| 18:01.27 | *** join/#utos cro (n=cro@70.90.213.14) |
| 18:02.18 | *** part/#utos cro (n=cro@70.90.213.14) |
| 18:59.26 | *** join/#utos jpc (n=jw@unaffiliated/javawizard2539) |
| 19:19.35 | *** join/#utos undertak1ngyou (n=will@undertakingyou.dsl.xmission.com) |
| 19:19.40 | *** join/#utos Nafai` (n=Nafai@travishartwell.net) |
| 19:19.57 | *** join/#utos harleypig (n=harleypi@70.87.222.137) [NETSPLIT VICTIM] |
| 19:19.58 | *** join/#utos optikal (i=optikal@70.85.16.213) |
| 20:07.41 | *** join/#utos fugue88_ (n=dsowen@fugue88.dsl.xmission.com) |
| 20:27.21 | mindjuju | ~apb eggyknap |
| 20:27.22 | infobot | ACTION summons Tim to spray mace at eggyknap |
| 20:28.10 | herlo | whiteinge: ping |
| 20:43.07 | whiteinge | herlo: pong |
| 20:43.54 | herlo | whiteinge: how was the 11? :) |
| 20:44.03 | herlo | did you share with others?... |
| 20:45.39 | peno | they're passing the leftovers around the office now |
| 20:47.27 | herlo | lol, nice |
| 20:50.40 | whiteinge | herlo: The 11 is one of those life experiences that everyone must go through in the journey toward enlightenment. |
| 20:51.23 | herlo | exactly!! |
| 20:51.41 | *** join/#utos fozzmoo (n=fozz@67.214.226.66) |
| 20:51.58 | herlo | After you have experienced the 11, you can enlighten others and experience the joy of their experience :) |
| 20:52.25 | herlo | said experience three times in that sentence, not sure if that's a good idea in the future |
| 20:52.41 | maquis | 11? |
| 20:53.52 | herlo | maquis: http://wingcoop.com/menu-sauces.php |
| 20:54.38 | maquis | ah |
| 20:56.35 | utahcon | DexterTheDragon: I expect a good answer from your... ATI or Nvidia: who has better Linux support? |
| 20:56.48 | utahcon | mmm wingcoop |
| 21:01.15 | whiteinge | utahcon: Don't listen to DexterTheDragon. He's going to say Nvidia and he is utterly, completely, and blasphemously wrong. |
| 21:02.20 | josephnexus | whiteinge: except the ati drivers are usually broken |
| 21:02.48 | herlo | josephnexus: not for me |
| 21:03.01 | whiteinge | I've had good experiences with the closed-source drivers overall. |
| 21:03.03 | herlo | I use the free radeon driver all the time and it performs perfectly and has for a good year or more |
| 21:03.27 | josephnexus | i've got a 3200 that always throws fits for me |
| 21:03.40 | fozzmoo | The nouveau driver is alright. The proprietary nvidia driver works better, especially with hibernate and what not. |
| 21:04.04 | fozzmoo | josephnexus: I also have had problems getting the 3200 working right in Linux. |
| 21:04.13 | josephnexus | intel has been improving a lot though |
| 21:04.20 | josephnexus | as of late |
| 21:04.22 | whiteinge | The ATI open-source drivers are king if they have 3d-support for your card (which is all card but ones that have come out in the last two years or so). |
| 21:04.45 | josephnexus | except warzone 2100 chokes w/ them |
| 21:04.58 | josephnexus | :-( |
| 21:05.02 | fozzmoo | herlo: You know what I'm going to ask you. :-D |
| 21:05.02 | josephnexus | which is sad |
| 21:05.05 | whiteinge | The closed-source Nvidia drivers don't support RANDR which makes them a non-starter in my book. |
| 21:05.31 | josephnexus | the quadro cards are hard to beat for a good workstation though |
| 21:05.55 | fozzmoo | 01:00.0 VGA compatible controller: nVidia Corporation Quadro NVS 140M (rev a1) |
| 21:06.03 | fozzmoo | That's what I have in my Dell Latitude D830 |
| 21:06.08 | josephnexus | woohoo! |
| 21:06.15 | whiteinge | I have an Nvidia card in my work laptop and every time I plug/unplug a monitor I have to restart X (and even that has problems, for an ideal situtation I have to start X with a custom xorg.conf for each mode). |
| 21:06.16 | herlo | fozzmoo: pm |
| 21:06.16 | josephnexus | the driers for those are nice |
| 21:06.38 | josephnexus | and drivers are nice for that matter |
| 21:10.16 | *** join/#utos jpc (n=jw@unaffiliated/javawizard2539) |
| 21:20.03 | utahcon | does ATI support RANDR? |
| 21:20.31 | DexterTheDragon | and does it work with compositing? |
| 21:20.50 | utahcon | DexterTheDragon: You're supposed to tell me :D |
| 21:21.00 | Jayce^ | most computer hardware doesn't compost very well :-D |
| 21:21.17 | herlo | utahcon: I don't believe it does |
| 21:21.24 | DexterTheDragon | well I haven't used ATI for like 4-5 years |
| 21:21.24 | herlo | at least not the proprietary ones |
| 21:22.32 | DexterTheDragon | utahcon: I've been using nvidia for the past few years and loving it. but lately the lack of RANDR support has sucked |
| 21:22.58 | utahcon | so really it comes down to ... they both work equally as well for most people... great! |
| 21:23.13 | DexterTheDragon | yep |
| 21:23.55 | fozzmoo | utahcon: Just pays to make sure your card doesn't have any red flags. |
| 21:24.02 | fozzmoo | Like the ATI/AMD 3200 |
| 21:26.44 | *** part/#utos nibb13 (n=nibb13@206.71.87.254) |
| 21:54.21 | josephnexus | ati "mostly" does compositing |
| 21:54.36 | josephnexus | it fails with some stuff (cairo dock doesn't work) but most compiz stuff works fine |
| 21:54.38 | whiteinge | utahcon: both ATI closed and open support RANDR |
| 21:55.50 | josephnexus | someday, my card will have real drivers! |
| 21:56.00 | utahcon | whiteinge: so then it sounds like ATI is the way to go |
| 21:56.06 | DexterTheDragon | RANDR works with the nvidia binary but then Composite doesn't work |
| 21:56.38 | utahcon | whiteinge: does composite work with RANDR on ATI? |
| 21:56.48 | whiteinge | The Nvidia support for RANDR is hackish at best. Compositing doesn't work on a rotated display with any X drivers, afaik. |
| 21:56.58 | DexterTheDragon | :( |
| 21:57.03 | utahcon | ah crud |
| 21:57.23 | DexterTheDragon | why must I choose |
| 21:58.10 | whiteinge | utahcon: imo, ATI is the way to go right now. If you're not going for a gaming machine, get a slightly older card so the OSS drivers will do 3d. |
| 21:58.44 | Gate | isn't ATI claiming that they are pulling out of the gaming graphics market anyway? |
| 21:59.18 | whiteinge | I haven't heard that. I sure hope that's not the case. |
| 21:59.41 | utahcon | the rig is planned for 75% coding (in linux, with some flare) and 25% gaming |
| 22:01.43 | Gate | utahcon: you building on your own or just reaplacing a graphics card? |
| 22:01.54 | utahcon | Gate: building my own |
| 22:02.01 | Gate | cool |
| 22:02.22 | Gate | Nvidia's drivers have problems with the new xwindows config files, that much I can tell you |
| 22:02.34 | Gate | or at least their config utility |
| 22:03.23 | Gate | utahcon: AMD or Intel? Dual or Quad? |
| 22:03.42 | utahcon | looking at AMD Quad-Core |
| 22:03.46 | Gate | cool |
| 22:04.09 | Gate | what chipset are you looking at for the mobo? |
| 22:04.14 | utahcon | Newegg has the Phenom II X4 955 (3.2GHz) + Mobo for $231 |
| 22:04.31 | Gate | sexy |
| 22:04.38 | whiteinge | utahcon: FYI: http://www.x.org/wiki/RadeonFeature |
| 22:04.40 | utahcon | Gate: http://www.newegg.com/Product/Product.aspx?Item=N82E16813131402 |
| 22:04.44 | whiteinge | utahcon: FYI: http://www.x.org/wiki/RadeonProgram |
| 22:05.33 | utahcon | whiteinge: nice, thanks |
| 22:07.44 | whiteinge | Executive overview: I think the binary Nvidia drivers are probably better for no-frills straight 3D and they're easier to install than tht binary ATI drivers. The binary Nvidia drivers are not keeping up with X advancements though so the ATI binary and OSS drivers are less performant and more featurefull. |
| 22:08.12 | utahcon | is paying slightly less than he did for his first machine ($500) and getting approx 48x the processing power |
| 22:08.19 | whiteinge | lol |
| 22:08.56 | herlo | utahcon: very nice job man! |
| 22:10.33 | Gate | utahcon: cool, you are spending a little less than I did on my machine I build 2 years ago |
| 22:10.43 | Gate | s/build/built/g |
| 22:11.25 | utahcon | yeah this one supports up to 7 drives in RAID 5 (native hardware support) |
| 22:11.27 | utahcon | sick |
| 22:11.40 | Gate | Now, of course, I have put more money into a new graphics card (I have flip-flopped between the two ATI/Nvidia) |
| 22:11.41 | utahcon | now... to convince the wife I _need_ this. |
| 22:11.44 | Gate | cool! |
| 22:12.00 | Gate | I have been VERY happy with my ASUS mobo as well |
| 22:12.54 | Gate | I went ASUS for the mobo/optical dives, WD for the HDD and I think Asus for the original graphics as well |
| 22:13.22 | utahcon | see now if I could find a lappy with that much power, for around the same price I would be very happy :D |
| 22:14.06 | Gate | I have been seeing some nice ones on Newegg |
| 22:14.19 | Gate | not Phenom II x4s, but still |
| 22:14.42 | Gate | ~$400 you can get a damned fine machine |
| 22:14.46 | josephnexus | i have a quad core amd |
| 22:14.49 | josephnexus | it works quite nicely |
| 22:14.51 | josephnexus | :-D |
| 22:14.56 | Gate | josephnexus: lappy? |
| 22:15.03 | josephnexus | no |
| 22:15.06 | josephnexus | desktop |
| 22:15.08 | josephnexus | my laptop sucks |
| 22:15.13 | Gate | heh |
| 22:15.26 | Gate | I might have to build a new mahchine when I change jobs in January |
| 22:15.32 | Gate | :) put the raise to good use |
| 22:15.33 | utahcon | yeah see... I would love something with 4 cores in my laptop, but that is just not feasible right now |
| 22:15.44 | utahcon | I wants the power, but I wants the portability too |
| 22:15.49 | peno | model name: Intel(R) Core(TM) i7 CPU 950 @ 3.07GHz |
| 22:15.51 | peno | heh. |
| 22:15.58 | josephnexus | utahcon, you can't handle the power!!! |
| 22:16.09 | josephnexus | apparently peno can though |
| 22:16.12 | josephnexus | :-p |
| 22:16.31 | utahcon | seen the new core i9 specs? |
| 22:16.33 | utahcon | crazy |
| 22:17.53 | josephnexus | it's amazing what cpus are doing nowadays |
| 22:18.05 | josephnexus | i remember when i had to turn off "turbo" so my old games wouldn't run too fast |
| 22:21.56 | *** join/#utos justincarmony_ (n=justinca@c-98-202-44-233.hsd1.ut.comcast.net) |
| 22:29.17 | *** join/#utos mindjuju (n=mindjuju@mail.billgood.us) |
| 22:34.30 | Gate | are the videos being posted from UTOS |
| 22:36.35 | utahcon | Gate: eventually. |
| 22:40.10 | *** join/#utos neybar (n=jalance@pool-71-116-84-222.snfcca.dsl-w.verizon.net) |
| 22:42.07 | herlo | Gate: ask fozzmoo when he comes on line |
| 22:44.32 | eggyknap | mindjuju: did you ping a while back? |
| 22:44.58 | Gate | ok |
| 22:45.01 | Gate | thanks |
| 22:45.11 | mindjuju | eggyknap -- yup |
| 22:45.18 | eggyknap | Que pasa? :) |
| 22:45.29 | mindjuju | tengo una problema con sql |
| 22:45.40 | mindjuju | tienes tiempo? |
| 22:45.45 | mindjuju | hmm, misspell |
| 22:45.52 | eggyknap | Sure, a little... but I've just run out of available Spanish. :) |
| 22:46.03 | mindjuju | k, so here is the deal |
| 22:46.19 | mindjuju | i have an events table that records when clients do this or that |
| 22:46.43 | mindjuju | so there are multiple records for client 1 when he hit resource A, another record when he hit resource B, etc |
| 22:46.48 | mindjuju | soooo |
| 22:46.59 | mindjuju | I want to now get a list of the 100 most recent events |
| 22:47.19 | mindjuju | but i don't want to have all of the events made by client 1, just one of them |
| 22:47.49 | mindjuju | so |
| 22:47.53 | mindjuju | i've tried group by |
| 22:47.56 | mindjuju | subselects |
| 22:47.57 | eggyknap | So if client 1 is responsible for each of the most recent hundred events, you actually want to see just the latest from client 1, and recent events from 99 other clients... ? |
| 22:48.14 | mindjuju | yes! that's it! |
| 22:48.16 | mindjuju | :) |
| 22:48.39 | mindjuju | well, and even that in and of itself isn't that hard |
| 22:48.45 | mindjuju | but here is where the problem is |
| 22:49.07 | eggyknap | stirs gently, watching the plot thicken |
| 22:49.16 | mindjuju | if i do it the easy way, that's 100 look ups either through a subquery or what have you |
| 22:49.26 | mindjuju | i was hoping to slam it all together with one query |
| 22:50.39 | mindjuju | am i just being obsessive? |
| 22:51.58 | eggyknap | So join the events table to a subquery, something like this: SELECT events.* FROM events JOIN (SELECT client, MAX(event_time) AS etime FROM events GROUP BY MAX(event_time) ORDER BY MAX(event_time) DESC LIMIT 100) e ON (e.client = events.client AND e.etime = events.event_time) ORDER BY event_time DESC; |
| 22:53.42 | mindjuju | k |
| 22:53.51 | eggyknap | That will start to have problems if a client has two events at the same time -- to resolve *that* problem, you'll need to resort to some non-standard stuff (like PostgreSQL would let you use DISTINCT ON -- dunno about other databases). Anyway, you'd need to include the primary key of the events table in the subquery, and have some sort of aggregate function that simply returns the first row you push into it. |
| 22:55.06 | eggyknap | But theoretically, at least, that query will avoid the 100+ subscans you were worried about. If you're using MySQL, which, astoundingly, still only supports nested loop joins, you've still effectively got 100 subscans, but it just won't look as much like it when you look at the EXPLAIN output. |
| 22:55.52 | *** join/#utos neybar (n=jalance@pool-71-116-84-222.snfcca.dsl-w.verizon.net) |
| 22:56.04 | mindjuju | thx eggyknap |
| 22:56.22 | eggyknap | yw... hope that works. |
| 22:56.34 | mindjuju | yeah, it gives me a direction to go in |
| 22:56.54 | mindjuju | sadly, i have to take this a level of difficulty further and prep your idea for ms sql |
| 22:57.04 | mindjuju | but it gives me a great direction to head |
| 22:57.40 | eggyknap | wonders if mssql supports some DISTINCT ON -like aggregate |
| 22:57.51 | mindjuju | i'm going to have to check on that |
| 22:58.28 | eggyknap | I sometimes think it would be interesting to learn my way around the ever-increasing set of MySQL storage engines, so as to speak conversantly about 'em. But not while preparing turkeys, etc. |
| 23:30.23 | josephnexus | INSERT into TURKEYS (ingredients) VALUES(stuffing) |
| 23:30.28 | josephnexus | or something like that |
| 23:35.04 | justincarmony_ | lol |
| 23:36.07 | josephnexus | and if you are using PDO then you can actually do someting like |
| 23:47.53 | josephnexus | object->prepare($turkey) |
| 23:48.00 | josephnexus | which looks rather interseting |