| 07:03.15 | *** join/#asterisk-doc oej (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 07:31.32 | *** join/#asterisk-doc oej_ (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 07:42.04 | *** join/#asterisk-doc oej_ (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 08:52.02 | *** join/#asterisk-doc oej (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 08:52.59 | *** join/#asterisk-doc oej_ (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 08:53.59 | *** join/#asterisk-doc oej (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 08:54.57 | *** join/#asterisk-doc oej_ (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 12:22.44 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 12:22.44 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 13:00.47 | *** join/#asterisk-doc eliel (n=eliels@200.61.172.61) |
| 13:19.43 | *** join/#asterisk-doc ctooley (n=ctooley@12.230.123.195) |
| 13:43.23 | *** join/#asterisk-doc ctooley (n=ctooley@12.230.123.195) |
| 14:12.26 | *** join/#asterisk-doc oej (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 14:32.04 | *** join/#asterisk-doc morpheus08 (n=agoradf@88-149-140-45.dynamic.ngi.it) |
| 14:32.08 | *** part/#asterisk-doc morpheus08 (n=agoradf@88-149-140-45.dynamic.ngi.it) |
| 14:54.28 | *** join/#asterisk-doc oej_ (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 14:56.58 | *** join/#asterisk-doc oej (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 15:01.26 | *** join/#asterisk-doc oej (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 15:02.08 | *** join/#asterisk-doc oej_ (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 15:10.53 | *** join/#asterisk-doc wierdo (n=jimmy@wifi-traf5.networx-bg.com) |
| 15:22.04 | *** join/#asterisk-doc oej (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 15:22.58 | *** join/#asterisk-doc oej__ (n=olle@170.Red-88-2-166.staticIP.rima-tde.net) |
| 15:24.03 | *** join/#asterisk-doc oej (n=olle@240.Red-83-33-40.dynamicIP.rima-tde.net) |
| 16:01.30 | *** join/#asterisk-doc Juggie (n=Juggie@CPE001601df17fb-CM001ceac25ada.cpe.net.cable.rogers.com) |
| 17:30.27 | Juggie | jsmith: ping |
| 17:30.38 | jsmith | Juggie: pong |
| 17:30.50 | Juggie | can you look @ a query i'm having a performance issue with? |
| 17:31.47 | Juggie | http://www.pastebin.ca/1474421 |
| 17:33.17 | Juggie | problem is when there is only one SiteID in the where clause its slow, anything above 1 is fine. |
| 17:33.42 | Juggie | i figure i should change the query over to innerjoins but due to all the cross table joins and the same table being included twice, i fail. |
| 17:38.37 | jsmith | Well, there are a couple of things I'd look at... |
| 17:38.46 | jsmith | First of all, I'm sure the COUNT(DISTINCT ReportHeader) is killing performance |
| 17:39.07 | jsmith | Second, I'm not understanding why you're joining sort_table twice |
| 17:39.22 | Juggie | the sort table contains specific sorting |
| 17:39.33 | Juggie | the clients wants two types of data sorted in specific orders |
| 17:39.39 | Juggie | so it needs to be joined twice |
| 17:41.36 | jsmith | OK... there also seem to be a *lot* of columns in your GROUP BY clause |
| 17:42.17 | jsmith | One other thing... I'd also look at re-ordering your WHERE clause |
| 17:42.23 | Juggie | ya, i'm not dumping the specific rows, the query produces snapshots from a set of rows |
| 17:42.26 | jsmith | To try to get the most restrictive conditions first |
| 17:42.37 | jsmith | Gotcha |
| 17:42.59 | Juggie | i figured the time was the most restrictive? |
| 17:46.32 | Juggie | moving the sorting to be proper joins and removing the distinct (which was a failed feature attempt) seems to have improved things |
| 17:49.12 | Juggie | how do i do an inner join on queues twice? |
| 17:49.34 | Juggie | eg, for the sort and also to match w/ the catagories table |
| 17:56.46 | Juggie | well it works myuch better now this will do :) |
| 17:56.57 | Juggie | i want to blow this report anyway anyways and do it based off archived data |
| 17:57.17 | Juggie | rather then do this sql voodoo on the fly |
| 17:58.54 | Juggie | on another note its frigen hot |
| 17:59.12 | Juggie | humidex is 96. |
| 23:16.43 | *** join/#asterisk-doc marcus (n=mark@c-71-199-107-125.hsd1.pa.comcast.net) |
| 23:16.54 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 23:16.54 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 23:29.20 | *** join/#asterisk-doc eliel (n=eliels@120-17-235-201.fibertel.com.ar) |