#perl
17 October 2007
Total 46 pages. You are browsing page 4/46.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last
01:29 <****> Ah.
01:29 <****> Got my vowels wrong
01:29 <****> perhaps a vowel movement is in order?
01:29 <****> haha
01:30 <****> Let's see how this ignore change goes.
01:32 <****> i'm having an awful time writing a functioning socket client using active state perl in windows. details:
01:32 <****> "concave" at 68.112.170.161 pasted "the client and server code bel" (111 lines, 3.3K) at http://sial.org/pbot/28075
01:43 <****> mauprogress?:)
01:43 <****> wat, he left
01:53 <****> what is faster, 4 queries or 1 join?
01:53 <****> 1 join
01:53 <****> really?
01:53 <****> depends on what the queries are, and this isn't a database channel?
01:53 <****> er
01:53 <****> whoops
01:53 <****> meant to hit mysql :P
01:53 <****> np :)
01:54 <****> [domon]: in that case, it's a real tossup. Mysql sucks serious ass at query planning :)
01:54 <****> yeah, deopends of course, but in general. :)
01:54 <****> plus 1 join is more cacheable
01:54 <****> i am using DBH of course
01:54 <****> ie: prepare/execute
01:54 <****> dkr: not exactly :)
01:54 <****> "of course"? heh
01:54 <****> er...DBI*
01:55 <****> [domon]: generally speaking it's best to save the roundtrips.
01:55 <****>prepare('SELECT * FROM `ticket` WHERE mask = ?');
01:55 <****>prepare('SELECT * FROM `message` WHERE ticket_id = ?');
01:55 <****>prepare('SELECT content FROM `message_content` WHERE message_id = ?');
01:55 <****> and not paste.
01:55 <****> all three of those have 1 common field.
01:55 <****> hobbs: 3 line paste = okay
01:55 <****> says who? :)
01:55 <****> that's what i was told.
01:56 <****> I see. It was "them". :)
01:56 <****> anyway
01:56 <****> :P
01:56 <****> looks like a good candidate for a join. yes
01:56 <****> you have lousy field names if those are all supposed to be the same thing. But yeah, that should probably be joined to do it all in one trip to the server
01:56 <****> only thing is, at the moment, i'm only selecting one row in the last query
01:56 <****> hobbs: nah, they aren't the same thing
01:56 <****> message_id isn't ticket_id
01:57 <****> oh, nevermind. :)
01:57 <****> I think by 1 common field, he meant 2
01:57 <****> message shared ticket_id with ticket, which uses id.
01:57 <****> message_content uses message_id, which is shared with message.id
01:57 <****> yes, which means "all three of those have 1 common field." was false. that was the point. we programmers are very exacting. :)
01:58 <****> lol. 2. sorry :P
01:58 <****> okay, i'll join 'em then
01:58 <****> why doesn't that work? http://rafb.net/p/qPKcxH71.html. I want only '1'
01:59 <****> my @foo = (1, 11, 12, 13);
01:59 <****> dkr, hmm
01:59 <****> argh
01:59 <****> my $array_reference = [1, 11, 12, 13];
01:59 <****> yes
02:00 <****> ok. thanks dkr
02:07 <****> Damn it.
02:08 <****> I need more hookup wire.
02:08 <****> I forgot ketchup again =[
02:10 <****> cfedde: Much of the wire on the poles out there is redundant.
02:11 <****> Yaakov: I was just thinking that.
02:11 <****> Hello.
02:11 <****> here's a neatly packaged little unit: http://www.arduino.cc/
02:13 <****> There's a neatly packaged little unit in my pants
02:14 <****> iank: we weren't going to say naything about the 'little' part but it's nice you know you need help
02:14 <****>' mode would clobber the file first.
02:15 <****> truncate, delete all the data
02:15 <****> make empty?
02:16 <****> make empty. yes
02:16 <****> thank you!
02:16 * iank kicks mst in the cock
02:16 <****> english (or rather american) as a second language.
02:17 <****> off color is one thing. vulgar is another.
02:17 * Somni toggles iank's offensive bit back off
02:17 <****> hello Somni would you like a crumpet?
02:17 <****> why yes, don't mind if I do
02:18 <****> jolly good crumpets, iank
02:18 <****> ok now toggle my bits again
02:18 <****> cfedde are you talking to me?
02:18 <****> i'm sorry if i said something wrong
02:19 <****> cheater: naw, he's talking to me -_-
02:19 * SubStack invites GumbyGumby and GumbyBRAIN to tea.
02:19 <****> what are the moments that you don't bring someone uneducated with you and gumbygumby?
02:19 <****> Gumbygumby is a gland used for hearing, and it is gumbybrain code.
02:19 <****> sukria: fail
02:19 <****> OK
02:19 <****> er
02:19 <****> SubStack: fail
02:19 <****> BOTHAX
02:19 * iank gumbygumby gumbybrain
02:19 <****> Gumbygumby is a cli to check out http://www.gumbybrain.
02:19 <****> if you could msg your instructions to chanserv to do is pray for a gumbygumby.
02:19 <****> fail!
02:19 <****> carp
02:19 <****> I know a MegaHAL when I see one
02:19 * iank sleep 60
02:20 * SubStack wrote a postgres-based markov chatter bot recently
02:20 <****> much nicer on the memory usage
02:20 * MooingLemur wrote a perl-based one
02:20 <****> in perl too
Total 46 pages. You are browsing page 4/46.
First :: Prev :: [...] [2] [3] [4] [5] [6] [...] :: Next :: Last