| 00:00.56 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 00:28.37 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 00:32.05 | *** join/#uphpu jnbek (~jnbek@pdpc/supporter/active/jnbek) |
| 00:59.39 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-130-166.DNVR.QWEST.NET) |
| 02:24.13 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 02:43.50 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 02:57.51 | *** join/#uphpu carmony (~justin@ip70-181-211-152.sd.sd.cox.net) |
| 02:57.51 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 03:03.51 | *** join/#uphpu cedwards (~cedwards@unaffiliated/zelut) |
| 03:21.48 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 03:21.48 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 03:23.22 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 03:23.22 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 03:25.58 | josephscott | $chuck-fact |
| 03:25.59 | raifbot | Chuck Norris can kill two stones with one bird |
| 04:04.29 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-130-166.DNVR.QWEST.NET) |
| 05:01.55 | *** join/#uphpu itimber (~Adium@182.72.124.24.cm.sunflower.com) |
| 05:01.57 | *** mode/#UPHPU [+v itimber] by ChanServ |
| 05:33.52 | *** join/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 05:33.53 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 07:30.58 | *** part/#uphpu mgeary (~mgeary@69.169.142.45.provo.static.broadweavenetworks.net) |
| 13:53.35 | influx | mawnin |
| 14:04.14 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-130-166.DNVR.QWEST.NET) |
| 14:14.13 | *** join/#uphpu mastergunns (~mastergun@216.49.181.128) |
| 14:15.48 | *** join/#uphpu mahelious (~mahelious@64.0.29.254.ptr.us.xo.net) |
| 14:49.08 | herlo | morning |
| 14:49.15 | mindjuju | morning to you fine sir |
| 14:49.21 | mindjuju | did you get any sleep? |
| 14:51.02 | herlo | yeah, enough |
| 14:51.15 | herlo | mindjuju: stupid sun woke me this morning. |
| 14:51.31 | mindjuju | :) |
| 14:51.54 | mindjuju | pretty day for a wedding |
| 14:51.56 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 14:51.56 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 14:51.58 | herlo | yup |
| 14:52.02 | herlo | who's getting marred? |
| 14:52.14 | mindjuju | hmmm |
| 14:52.23 | herlo | THIS GUY!! |
| 14:52.29 | mindjuju | you today, my wife's uncle tomorrow! |
| 14:52.43 | herlo | oh, wow. Busy weekend for you. |
| 14:53.01 | mindjuju | it's all good |
| 14:53.48 | herlo | mindjuju: yeah, sounds like |
| 14:54.07 | herlo | sometimes, it's fun to have a busy weekend |
| 14:54.32 | mindjuju | i'm excited |
| 14:54.37 | herlo | anyway, I have a few last minute errands to run, I'd better get on them. See you this afternoon! |
| 14:54.44 | mindjuju | see you there! |
| 14:55.01 | macnewbold | ~friday |
| 14:55.01 | ibot | ! ! ! F R I D A Y ! ! ! |
| 14:55.18 | macnewbold | ~congratulate herlo |
| 14:55.18 | ibot | ACTION congratulates herlo on being a new owner of a $500 brick. |
| 14:55.20 | herlo | macnewbold: the 13th |
| 14:55.31 | herlo | macnewbold: thx |
| 15:00.13 | influx | ~congratulate herlo |
| 15:00.13 | ibot | ACTION congratulates herlo on being a new owner of a $500 brick. |
| 15:08.29 | *** join/#uphpu fungus (~olsonl@bromine.sosstaffing.com) |
| 15:08.29 | *** mode/#UPHPU [+o fungus] by ChanServ |
| 15:09.21 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 15:09.30 | *** mode/#UPHPU [+o wps] by ChanServ |
| 15:10.14 | mindjuju | so quick question, why doesn't this overwrite local files without me saying yes to every file? cp -Rf /home/pwr ./ |
| 15:11.33 | DexterTheDragon | mindjuju: cp -Rfi |
| 15:11.36 | fungus | do you have permissions to the destination? |
| 15:14.03 | mindjuju | i'm in as su @fungus |
| 15:15.11 | *** join/#uphpu cedwards (~cedwards@unaffiliated/zelut) |
| 15:16.16 | *** join/#uphpu mgeary (~mgeary@50.8.70.19) |
| 15:16.16 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 15:24.24 | *** join/#uphpu jtsnow (~jtsnow@VDSL-151-118-130-166.DNVR.QWEST.NET) |
| 15:28.26 | *** join/#uphpu cro (~cro@204-228-149-217.ip.xmission.com) |
| 15:32.28 | *** join/#uphpu bhosie (~bhosie@192.84.171.170) |
| 15:38.49 | *** join/#uphpu Monnok (~monnok@c-71-195-231-57.hsd1.ut.comcast.net) |
| 15:39.39 | *** join/#uphpu carmony (~justin@ip70-181-211-152.sd.sd.cox.net) |
| 15:39.39 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 15:48.44 | *** join/#uphpu carmony_ (~justin@ip70-181-211-152.sd.sd.cox.net) |
| 15:48.44 | *** mode/#UPHPU [+v carmony_] by ChanServ |
| 15:49.14 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 15:49.14 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 15:53.33 | *** join/#uphpu carmony_ (~justin@ip70-181-211-152.sd.sd.cox.net) |
| 15:53.33 | *** mode/#UPHPU [+v carmony_] by ChanServ |
| 16:22.53 | *** join/#uphpu PoeticIntensity (~jason@76.8.222.23) |
| 16:22.53 | *** mode/#UPHPU [+v PoeticIntensity] by ChanServ |
| 16:24.18 | *** join/#uphpu dharmatech (~hayduke@utriders.dsl.xmission.com) |
| 16:28.00 | *** join/#uphpu redroy (~Adium@c-174-52-210-81.hsd1.ut.comcast.net) |
| 16:33.27 | mindjuju | thx for your help on that DtD, for some reason that command with the Rfi didn't work, so i just blasted the dir from orbit and then just did the cp |
| 16:38.38 | mindjuju | fungus, did you see this? |
| 16:38.39 | mindjuju | http://forums.thinkingwithportals.com/downloads.php?cat=5 |
| 16:40.25 | *** join/#uphpu Monnok (~monnok@c-71-195-231-57.hsd1.ut.comcast.net) |
| 16:40.28 | *** part/#uphpu Monnok (~monnok@c-71-195-231-57.hsd1.ut.comcast.net) |
| 16:41.47 | redroy | $chuck-fact |
| 16:41.47 | raifbot | Chuck Norris does not sleep. He waits. |
| 16:54.48 | *** join/#uphpu ninnypants (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 17:01.45 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 17:01.45 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 17:02.46 | *** join/#uphpu mastergunns (~mastergun@216.49.181.128) |
| 17:03.53 | ninnypants | I wonder if Hatch will ever not support a censorship bill http://news.cnet.com/8301-31921_3-20062398-281.html |
| 17:13.27 | *** join/#uphpu techgurufloyd (~Adium@216.49.181.128) |
| 17:26.27 | mindjuju | i approve |
| 17:27.14 | carmony_ | lol, who wants to see the random thing of the day? |
| 17:27.41 | mgeary | anyone know if a kill -HUP works to reload a running mysqld? |
| 17:27.44 | josephscott | $random-number |
| 17:27.45 | raifbot | josephscott your number is : 279,173,984 |
| 17:27.57 | josephscott | mgeary: don't do that |
| 17:28.09 | mgeary | josephscott: i wasn't going to, but wondered if it was supported |
| 17:28.43 | josephscott | use the service manager for your OS/package |
| 17:28.46 | carmony_ | http://www.justincarmony.com/rtd/RTD.html -- my brother wrote this using HTML5's canvas |
| 17:42.17 | mindjuju | orrin hatch gives me gas |
| 17:46.05 | josephscott | ~de-gas mindjuju |
| 17:46.24 | mgeary | oh wait... |
| 17:47.23 | josephscott | haha, mindjuju as an old monitor :-) |
| 17:47.26 | josephscott | ~degauss mindjuju |
| 17:48.46 | mindjuju | this was a miscalculated step - http://www.deseretnews.com/article/705372498/Huntsman-says-his-Mormon-church-membership-is-tough-to-define.html?pg=1 |
| 17:49.19 | josephscott | haha, that was just strange |
| 17:49.23 | mindjuju | does his team honestly think they'll let him off easy by his obfuscation ? |
| 17:49.45 | mindjuju | sticks out like a sore thumb now |
| 17:50.15 | mgeary | mindjuju, ninnypants, it's always nice to see Dems and GOP agreeing on something: protecting their corporate sponsors |
| 17:52.20 | *** join/#uphpu CapnRazor (~razor@adsl-69-228-251-29.dsl.pltn13.pacbell.net) |
| 17:52.51 | mindjuju | ugh, that guy makes me mad, REALLY mad |
| 17:53.04 | CapnRazor | Hi All do you take newbe questions? |
| 17:53.16 | mgeary | CapnRazor: we just did! |
| 17:53.18 | mindjuju | i hate to say i voted for the guy because I thought that it was better to have an advocate in a high place, but he's no advocate of the citizen |
| 17:54.32 | CapnRazor | :) I need to split an array according to one of the values in the array, what search terms might help me find code examples to look at? |
| 17:55.39 | mgeary | CapnRazor: you mean if, for example, "foo" is the 15th item in an array, you want to split it into two arrays at that point? |
| 17:56.25 | CapnRazor | not really I have an associative array (trying to paste an example) Array |
| 17:56.26 | CapnRazor | ( |
| 17:56.26 | CapnRazor | <PROTECTED> |
| 17:56.26 | CapnRazor | <PROTECTED> |
| 17:56.26 | CapnRazor | <PROTECTED> |
| 17:56.26 | CapnRazor | <PROTECTED> |
| 17:56.26 | CapnRazor | <PROTECTED> |
| 17:56.27 | CapnRazor | <PROTECTED> |
| 17:56.27 | CapnRazor | <PROTECTED> |
| 17:56.28 | CapnRazor | <PROTECTED> |
| 17:56.28 | CapnRazor | <PROTECTED> |
| 17:56.29 | CapnRazor | <PROTECTED> |
| 17:56.29 | CapnRazor | <PROTECTED> |
| 17:56.30 | mgeary | uh oh |
| 17:56.50 | mindjuju | careful doing that CapnRazor, they'll kick you for spam if you send a bunch of text |
| 17:56.57 | mindjuju | that said, i think this might do what you need |
| 17:56.58 | mindjuju | http://stackoverflow.com/questions/4217048/array-divide-split-by-value |
| 17:57.37 | CapnRazor | and there are multiple materialtypes that I need to break into seperate divs. Checking the link... |
| 17:57.58 | mindjuju | the first answer in the gray box get's you close |
| 17:59.23 | CapnRazor | Great thanks Ill be lurking while I try to sort that out :) |
| 17:59.51 | mindjuju | feel free to ask any other questions, theres lots of senior PHPers here |
| 18:00.10 | mindjuju | just try to avoid the occasional political comment or you'll start a flamewar |
| 18:00.33 | CapnRazor | :) |
| 18:01.08 | mgeary | wth |
| 18:01.17 | mgeary | political commentary is our stock in trade |
| 18:01.49 | influx | North Korea is best Korea. |
| 18:02.33 | josephscott | $mindtrick politics |
| 18:02.33 | raifbot | (jedi hand wave) politics you don't need to see his identification. |
| 18:02.56 | mindjuju | ah kim jong il, there is a bastion of sanity |
| 18:03.26 | mgeary | mindjuju: you misspelled "bastard" |
| 18:03.37 | CapnRazor | Hmm those examples seem to evaluate for a numeric value being true. Im not sure I am following the logic |
| 18:03.45 | mindjuju | heh |
| 18:05.32 | mindjuju | srry CapnRazor, i've got to go photog a wedding, but ask people like josephscott or DtD or etc |
| 18:05.34 | mindjuju | they are good guys |
| 18:05.56 | CapnRazor | if I have say 12 returns in my array with 3 different materials would I parse the array into 3 new arrays? and then for > each those? |
| 18:05.56 | unum | $found=false foreach($array as $value){if($found){array_push($array1,$value)else{array_push($array2,$value)}if($value=$something){$found=true}} |
| 18:06.02 | CapnRazor | thanks ! |
| 18:06.57 | unum | not sure I understand what you're doing completely, but that's probably the solution I'd use |
| 18:07.20 | unum | of course I'm a fan of the correction solution is the one I can implement the fastest |
| 18:07.28 | unum | of course I'm a fan of "the correction solution is the one I can implement the fastest" |
| 18:08.25 | CapnRazor | its our internal website so I have to live with it :) |
| 18:12.11 | CapnRazor | at the risk of flooding here is the code I am trying to adapt |
| 18:12.23 | CapnRazor | <?php foreach ($swatchlist as $k => $v){ |
| 18:12.23 | CapnRazor | } ?> |
| 18:12.23 | CapnRazor | <div class='tiny'> |
| 18:12.23 | CapnRazor | <a href='/index.php?pg=resources_<?php echo ($v['materialname']); ?>_finish' title='<?php echo $v['color']; ?> <?php echo $v['materialtype']; ?>'> |
| 18:12.23 | CapnRazor | <PROTECTED> |
| 18:13.10 | CapnRazor | this outputs all the array as neat little color chips |
| 18:14.59 | CapnRazor | unum so using your example to output into seperate divs I would step through $array1 $array2 etc? |
| 18:18.49 | CapnRazor | and is $found simply holding the values for this process? |
| 18:22.07 | *** join/#uphpu carmony (~justin@ip70-181-211-152.sd.sd.cox.net) |
| 18:22.07 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 18:31.01 | ninnypants | CapnRazor: you could use array_search then array_slice without any looping I believe |
| 18:32.19 | CapnRazor | ninnypants would that method rely on the elements being ordered by the value I am slicing on? |
| 18:34.55 | ninnypants | hmm I'm not completely sure I understand what you're doing |
| 18:35.59 | ninnypants | are you just trying to slit an array into column of divs or something like that? |
| 18:37.35 | CapnRazor | sort of I have an array of materials based on a product SKU I want to break each materialtype into a seperate div |
| 18:38.12 | CapnRazor | so i can display Leather X X X Hardwood X X X etc. |
| 18:38.49 | CapnRazor | id put the whole thing on codepad so you could see me fumbling about but it seems to be down |
| 18:45.48 | ninnypants | CapnRazor: you could do something like this http://pastebin.com/kCMSy5t9 |
| 18:46.05 | CapnRazor | checking... |
| 18:46.42 | ninnypants | you'd have to loop through each of the groups after but that would sort them into groups for you |
| 18:49.43 | CapnRazor | What is $desc doing in that example? |
| 18:50.28 | CapnRazor | if I am following it, its holding the value that I am using as my key right? |
| 18:53.19 | ninnypants | yeah it's holding a lowercase item type guess I should've named it type |
| 18:53.44 | ninnypants | it uses that to group it with other items in the $materialgroups array |
| 18:54.37 | CapnRazor | Thanks for showing me pastebin! here is a better picture of what i have. http://codepad.org/MAldugdu |
| 18:56.12 | CapnRazor | I think Im on the right track with this. unless you see something to indicate otherwise Ill play with what you gave me and see if i can learn something in the process |
| 18:57.09 | CapnRazor | I suspect that getting array manipulation down is going to open worlds for me |
| 18:57.35 | ninnypants | yeah it should do it I think you may be able to use one of the array sort functions too depending on what you need exactly |
| 18:58.51 | CapnRazor | OH! a general question, in terms of overhead, which is generally cheaper parsing an array in php or building a custom view in MySQL? |
| 19:07.41 | mgeary | CapnRazor: a well-optimized view would probably be cheaper, i'd think |
| 19:08.00 | mgeary | but i haven't been following your thread, so i may be speaking out of context |
| 19:09.45 | CapnRazor | mgeary I was looking for a general answer, at this time I dont have significant overhead but if I get uto thousands of items in my DB I would like to still be able to host on somwat normal hardware :) |
| 19:10.18 | mgeary | well, generally speaking your DB performance shouldn't really change as content is added |
| 19:10.22 | mgeary | that's the whole point of indexes |
| 19:10.31 | mgeary | until/unless your indexes become so large they can't be stored in memory |
| 19:10.43 | mgeary | but if you're only dealing with thousands of records, i wouldn't worry too much about that |
| 19:13.05 | CapnRazor | cool so in general terms it is a better idea to cerate a tailored view for the desired output than to manipulate the data after the fact, true? |
| 19:13.53 | mgeary | well |
| 19:13.58 | mgeary | i'd have to know more about your app to answer that |
| 19:14.26 | mgeary | i don't use views very often. Using them a lot might suggest your architecture needs a review |
| 19:14.30 | mgeary | but it also might not ;) |
| 19:16.01 | CapnRazor | Got it View better = true unless false! :) |
| 19:17.20 | CapnRazor | going into lurk mode while i try to sort this out. thanks for everyones help/patience! |
| 19:21.35 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 19:22.47 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 19:38.25 | *** join/#uphpu xtrementl (~xtrementl@neutroninteractive-xmission.xmission.com) |
| 19:45.23 | ninnypants | $chuck-fact |
| 19:45.24 | raifbot | The quickest way to a man's heart is with Chuck Norris's fist. |
| 19:51.32 | mgeary | hrm. well, i went from 100 max_connections to 200, and even so i just got a "too many connections" error |
| 19:53.23 | mgeary | hrm. looks like it's getting about 30k connections an hour |
| 19:58.02 | mgeary | wow. huge # of Handler_read_rnd_next. Need to figure out where those are coming from |
| 20:12.46 | *** join/#uphpu techgurufloyd (~Adium@216.49.181.128) |
| 20:13.51 | mgeary | does the slow query log just log things to the .err file? or does it stick them in a separate file? |
| 20:16.27 | *** join/#uphpu wps (~wps@76.8.223.101) |
| 20:16.27 | *** mode/#UPHPU [+o wps] by ChanServ |
| 20:19.51 | mgeary | nm |
| 20:22.22 | *** join/#uphpu ninnypants1 (~ninnypant@69.169.155.132.provo.static.broadweavenetworks.net) |
| 20:32.39 | ninnypants1 | $chuck-fact |
| 20:32.40 | raifbot | Chuck Norris once broke the land speed record on a bicycle that was missing its chain and the back tire. |
| 20:34.56 | *** join/#uphpu josephscott (~josephsco@104.2.233.72.static.reverse.ltdomains.com) |
| 20:34.56 | *** mode/#UPHPU [+v josephscott] by ChanServ |
| 20:36.13 | mgeary | hey stderr-, you see McCain's long speech on the Senate floor about torture the other day? |
| 20:43.41 | *** join/#uphpu jkr801 (~jkr801@c-67-186-232-131.hsd1.ut.comcast.net) |
| 20:50.10 | *** join/#uphpu jtsnow (~jtsnow@74-95-52-198-Utah.hfc.comcastbusiness.net) |
| 20:50.55 | *** join/#uphpu carmony (~justin@cpe-66-75-7-80.san.res.rr.com) |
| 20:50.55 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 21:31.19 | *** join/#uphpu redroy (~Adium@c-174-52-210-81.hsd1.ut.comcast.net) |
| 21:59.13 | *** join/#uphpu mahil (~mahelious@64.0.29.254.ptr.us.xo.net) |
| 22:00.28 | *** join/#uphpu wps_ (~wps@wfw.apxalarm.com) |
| 22:00.28 | *** mode/#UPHPU [+o wps_] by ChanServ |
| 22:02.13 | DexterTheDragon | josephscott: how can I delete a linked blog from wordpress.com? |
| 22:02.55 | josephscott | is this for the stats plugin? |
| 22:03.20 | DexterTheDragon | I dunno |
| 22:03.48 | josephscott | so you mean linked and is linked to your account? |
| 22:03.48 | DexterTheDragon | I just know wordpress.com has a linked blog on my account that doesn't exist and Im tired of seeing error messages in my logs |
| 22:04.10 | josephscott | can you tell me which blog it is? |
| 22:04.50 | DexterTheDragon | it's pointing to dev.dexterthedragon.com/wordpress |
| 22:05.55 | josephscott | what is your wordpress.com username? |
| 22:06.32 | DexterTheDragon | DexterTheDragon |
| 22:06.42 | josephscott | for those I think they can only be removed by staff |
| 22:07.33 | josephscott | ok, just a sec |
| 22:10.36 | *** join/#uphpu sheri (~sheri@cpe-184-153-22-16.nycap.res.rr.com) |
| 22:10.41 | josephscott | DexterTheDragon: bringing in help from the wordpress.com happiness team :-) |
| 22:10.47 | sheri | oh hai |
| 22:11.14 | josephscott | sheri: go for it |
| 22:11.32 | DexterTheDragon | I could use some wordpress.com happiness |
| 22:11.55 | sheri | k, I've unlinked your WordPress blog from dexterthedragon for you :) |
| 22:12.13 | DexterTheDragon | yay! thanks sheri |
| 22:12.15 | josephscott | thanks |
| 22:12.23 | sheri | np :) |
| 22:12.38 | DexterTheDragon | that seems like a lot more work than it should be ;) |
| 22:12.58 | josephscott | well, that particular case is a bit special |
| 22:13.26 | sheri | yeah, you can also hide it yourself using the My Blogs page, but I just completely unlinked it for you |
| 22:13.28 | sheri | DexterTheDragon: are you testing out stats type things? Jetpack? |
| 22:13.33 | DexterTheDragon | I don't even know what a linked blog is so.... |
| 22:14.11 | sheri | it's a blog linked to your WordPress.com account using the API (i.e. using the stats plugin) |
| 22:14.11 | DexterTheDragon | sheri: I had it hidden but it was always hitting my server looking for it and my logs were full of 404's |
| 22:14.21 | sheri | interesting |
| 22:15.01 | DexterTheDragon | and my actual site isn't linked in there. and I use the stats plugin |
| 22:15.22 | sheri | might be under a different account then |
| 22:17.49 | sheri | hrm, I think the name might have actually just have been off |
| 22:17.56 | DexterTheDragon | sheri yeah |
| 22:18.18 | DexterTheDragon | I just noticed my site is no longer allowed to use the stats plugin |
| 22:18.24 | sheri | that's not typical :) fixing |
| 22:18.27 | DexterTheDragon | so it must have been linked wird |
| 22:19.20 | sheri | try now |
| 22:19.33 | DexterTheDragon | sheri: very nice |
| 22:19.37 | DexterTheDragon | ~sheri++ |
| 22:19.43 | sheri | yay :) |
| 22:20.28 | sheri | so, I should have checked before unlinking before, but yeah, it seems the name was just mixed up which isn't very typical but happens sometimes |
| 22:32.50 | *** part/#uphpu mgeary (~mgeary@50.8.70.19) |
| 22:35.51 | *** join/#uphpu wps_ (~wps@wfw.apxalarm.com) |
| 22:35.51 | *** mode/#UPHPU [+o wps_] by ChanServ |
| 22:51.45 | *** join/#uphpu mgeary (~mgeary@50.8.70.19) |
| 22:51.45 | *** mode/#UPHPU [+v mgeary] by ChanServ |
| 22:54.49 | mgeary | hey |
| 22:54.52 | mgeary | let's talk more MySQL optimization |
| 22:55.30 | mgeary | so i have this query: http://dpaste.org/S4nE/ |
| 22:55.32 | mgeary | super simple |
| 22:55.38 | mgeary | note the commented-out line |
| 22:55.52 | mgeary | now, there are indexes on the id, parentID and status |
| 22:56.11 | mgeary | that query, run as-is, without the status='public', runs very quickly: .0012 sec |
| 22:56.40 | mgeary | if i uncomment the status line, it jumps to 2.2 seconds |
| 22:57.20 | mgeary | if i search just by status, and don't sort, it's also fast: .0008 seconds |
| 22:57.30 | mgeary | if i search by status AND sort, i get back up to 2.2 seconds :/ |
| 22:58.04 | josephscott | what does the explain look like for the variations of the query? |
| 22:58.13 | xtrementl | was just going to say that :) |
| 22:58.19 | mgeary | well, that's the weird thing |
| 22:58.51 | mgeary | http://dpaste.org/JHdT/ |
| 22:59.04 | mgeary | it sees the 3 keys, but doesn't actually USE any of them |
| 23:00.12 | josephscott | myisam or innodb table? |
| 23:00.18 | mgeary | myisam |
| 23:00.22 | *** join/#uphpu macnewbold (~Adium@66.60.115.30) |
| 23:00.22 | *** mode/#UPHPU [+o macnewbold] by ChanServ |
| 23:02.36 | mgeary | i guess since it can't use more than one index it just decides to use none at all |
| 23:02.39 | mgeary | :( |
| 23:03.02 | josephscott | that might be |
| 23:03.06 | mgeary | i could make a multi-column index, i suppose |
| 23:03.09 | josephscott | tried it with just one conditional |
| 23:03.32 | mgeary | but would it be on all 3 columns? I wouldn't think so... |
| 23:04.43 | *** join/#uphpu wps (~wps@wfw.apxalarm.com) |
| 23:04.43 | *** mode/#UPHPU [+o wps] by ChanServ |
| 23:05.42 | josephscott | I'm just thinking about getting it to use one index first, then build up options from there |
| 23:05.54 | mgeary | yeah, the 3-col index doesn't do anything |
| 23:06.09 | xtrementl | if not the multi-column index, you could possibly union two queries together separately. SELECT {data} FROM stuff where colA=id UNION select { data } from stuff where colB=id; |
| 23:06.14 | mgeary | josephscott: well, if i take out the status WHERE statement, it uses an index just fine |
| 23:06.30 | xtrementl | that way both queries run using independent indeces |
| 23:06.53 | mgeary | i don't think that will work here because i have an OR |
| 23:07.04 | josephscott | will probably do a temp table to manage the union |
| 23:07.26 | xtrementl | josephscott: that's probably true |
| 23:07.34 | xtrementl | to handle the results |
| 23:07.45 | josephscott | kind of tricky without knowing the schema either |
| 23:08.22 | mgeary | well |
| 23:08.26 | mgeary | okay, i've got a solution |
| 23:08.32 | mgeary | works beautifully |
| 23:08.39 | mgeary | just use "having" to filter the status |
| 23:09.00 | mgeary | .0011 seconds |
| 23:09.33 | josephscott | nice |
| 23:09.46 | mgeary | and it uses both keys |
| 23:09.56 | mgeary | type = index_merge |
| 23:10.00 | mgeary | i've never seen that before |
| 23:10.12 | mgeary | says, "Using union(PRIMARY,parentID);" |
| 23:10.18 | mgeary | okay. gotta run. later |
| 23:10.19 | *** part/#uphpu mgeary (~mgeary@50.8.70.19) |
| 23:11.32 | *** part/#uphpu CapnRazor (~razor@adsl-69-228-251-29.dsl.pltn13.pacbell.net) |
| 23:33.32 | *** join/#uphpu carmony (~justin@ip70-181-216-159.sd.sd.cox.net) |
| 23:33.32 | *** mode/#UPHPU [+v carmony] by ChanServ |
| 23:56.00 | *** join/#uphpu TuxToaster (~TuxToaste@c-24-10-187-146.hsd1.ut.comcast.net) |