| 01:37.18 | leifmadsen | jsmith: I'm sorry |
| 01:37.39 | leifmadsen | just watched the Rangers beat the Capitals |
| 02:04.56 | ctooley | well, phooey |
| 02:51.28 | leifmadsen | was a good game! |
| 07:11.00 | *** join/#asterisk-doc telecos (n=sergio@19.167.219.87.dynamic.jazztel.es) |
| 07:40.31 | *** join/#asterisk-doc Rochdi (n=abid@196.203.51.17) |
| 08:32.48 | *** join/#asterisk-doc DarkFlib (n=DarkFlib@cpc2-nfds9-0-0-cust77.lei3.cable.ntl.com) |
| 12:01.45 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 12:01.45 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 13:06.20 | *** join/#asterisk-doc Juggie (n=Juggie@CPE001601df17fb-CM001ceac25ada.cpe.net.cable.rogers.com) |
| 13:12.01 | *** part/#asterisk-doc Rochdi (n=abid@196.203.51.17) |
| 14:13.18 | *** join/#asterisk-doc Rochdi (n=abid@196.203.51.17) |
| 14:13.46 | *** part/#asterisk-doc Rochdi (n=abid@196.203.51.17) |
| 14:56.33 | Juggie | morning |
| 15:07.02 | *** join/#asterisk-doc telecos (n=sergio@44.167.219.87.dynamic.jazztel.es) |
| 15:12.08 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 15:12.08 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 18:45.58 | *** join/#asterisk-doc ctooley_ (n=ctooley@adsl-68-95-137-152.dsl.rcsntx.swbell.net) |
| 20:08.39 | *** join/#asterisk-doc leifmadsen (n=Leif@asterisk/documenteur-extraordinaire/blitzrage) |
| 20:08.40 | *** mode/#asterisk-doc [+o leifmadsen] by ChanServ |
| 20:30.57 | Juggie | cries |
| 20:31.54 | jsmith | ~console Juggie |
| 20:31.55 | infobot | ACTION gives Juggie the consolation moose |
| 20:32.04 | Juggie | soo i'm working on qmetrics for a client |
| 20:32.23 | Juggie | and the perl script they have to load data from queue_log into a db has been running for a full day |
| 20:32.27 | Juggie | and only loaded 1.5mil records |
| 20:32.34 | Juggie | so i start reading the perl code |
| 20:32.45 | jsmith | starts crying with Juggie |
| 20:32.52 | Juggie | before *EVERY* insert, they do a select to see if the record exists. |
| 20:32.55 | jsmith | Uh.... yeah.... |
| 20:33.01 | jsmith | Totally ungood, right? |
| 20:33.13 | Juggie | well i mean i'm not the brightest bulb |
| 20:33.23 | Juggie | but dont we have keys for that |
| 20:33.40 | jsmith | I would sure hope so :-) |
| 20:33.57 | Juggie | they are checking 4 vars, partition, time, callid and the verb which is what happened to the call |
| 20:34.00 | Juggie | so you make a PK of that |
| 20:34.00 | jsmith | Althought keys do slow down your inserts as well... but you know that :-) |
| 20:34.03 | Juggie | and call it a day |
| 20:34.09 | jsmith | No kidding... |
| 20:34.24 | jsmith | Doesn't even have to be the PK... as long as it is a unique key |
| 20:34.38 | Juggie | i'd imagine they do, but ummm i'd imagine a key is way better then doing a count(*) every time |
| 20:34.41 | Juggie | its not even a select |
| 20:34.45 | Juggie | to see ifthere is a result |
| 20:34.48 | Juggie | its a count on it as well |
| 20:35.56 | Juggie | does 'desc table' show pk's as well? |
| 20:36.01 | Juggie | or is there another command |
| 20:36.20 | Juggie | nm i'm blind |
| 20:36.50 | Juggie | super |
| 20:36.52 | Juggie | it has no keys. |
| 20:37.00 | Juggie | only the partition which is set a s a 'Multiple' Key |
| 20:38.12 | jsmith | sighs |
| 20:38.33 | jsmith | So, sounds like you're in the wrong line of work... |
| 20:39.02 | Juggie | what do you mean |
| 20:39.49 | jsmith | Sounds like you should be writing a queue reporting and metrics system! |
| 20:40.06 | jsmith | ~taunt Juggie |
| 20:40.07 | infobot | ACTION taunts Juggie a second time |
| 20:40.40 | Juggie | heh |
| 20:40.44 | Juggie | bad code just displeases me |
| 20:40.58 | Juggie | and this is terrible. |
| 20:41.39 | Juggie | i've never seen someone do a select before every insert before |
| 20:41.41 | Juggie | thats a new one |
| 20:41.49 | Juggie | i thought we had constraints for that reason |
| 20:43.47 | *** join/#asterisk-doc jpeeler (n=jpeeler@asterisk/digium-software-dev/jpeeler) |
| 20:46.05 | leifmadsen | ~taunt jsmith |
| 20:46.06 | infobot | ACTION taunts jsmith a second time |
| 21:00.28 | jsmith | Juggie: Some people obviously don't understand relational theory |
| 21:19.16 | leifmadsen | jsmith: ping? |
| 21:19.54 | jsmith | leifmadsen: pong! |
| 21:19.58 | Juggie | leifmadsen: pong |
| 21:20.00 | jsmith | ~scare leifmadsen |
| 21:20.01 | infobot | ACTION puts on a hockey mask and jumps out at leifmadsen |
| 21:20.12 | leifmadsen | ah! |
| 21:20.19 | Juggie | jason no! |
| 21:20.30 | leifmadsen | jsmith: do you have a couple minutes to read an email I just put together regarding taking on some documentation duties? |
| 21:20.39 | leifmadsen | I'd like your thoughts about how I'm proposing it before I send it on |
| 21:20.42 | jsmith | leifmadsen: Sure... fire it on over my way |
| 21:20.47 | leifmadsen | on its way! |
| 21:21.34 | leifmadsen | sent! |
| 21:21.50 | Juggie | leifmadsen: http://tech.slashdot.org/article.pl?sid=09/04/16/0045240&from=rss |
| 21:22.51 | leifmadsen | Juggie: UBB isn't really a terrible idea, but the fact that it never gets implemented at a fair rate is what concerns me |
| 21:23.30 | leifmadsen | for example, my phone bill is significantly cheaper by using UBB with Unlimitel vs. a Bell landline, but that's because they can actually compete with Bell without having to use their lines (directly) |
| 21:24.16 | Juggie | ya but to push it on all isps is a bit retarded |
| 21:24.35 | leifmadsen | agreed... bell is trying to kill them |
| 21:24.37 | Juggie | adsl doesnt use bell internet bandwith |
| 21:24.44 | Juggie | just their copper to the home |
| 21:25.01 | Juggie | and i suppose the dslam back to one of the bigger co's |
| 21:25.06 | Juggie | then its out on the other isps gear |
| 21:26.09 | Juggie | it would not be so bad for the isps if they did something like say |
| 21:26.17 | Juggie | 100gb per DSL line |
| 21:26.22 | Juggie | but for the wholesaler it pools |
| 21:26.39 | Juggie | so if they have 40 clients they get 4000gb |
| 21:26.55 | Juggie | and if user A uses 250gb but the other users dont add up to 3750 |
| 21:26.59 | Juggie | they would still be ok |
| 22:00.51 | leifmadsen | jsmith: see PM |
| 22:01.00 | jsmith | leifmadsen: Aye |