#mysql
12 October 2007
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last
--- Log opened Fri Oct 12 00:00:10 2007
00:00 <****> (So depressing to have 4 GB of RAM and be forced to use 32 bit windows)
00:00 <****> kurlj: wikipedia some relational databases http://en.wikipedia.org/wiki/Relational_database
00:00 <****> So depressing to use windows?
00:00 <****> Mads: why windows
00:01 <****> Forced to: We run some custom telephony application
00:01 <****> Therion: Does the bot have a karma feature?
00:01 <****> which is the reason why we can't even use 64 bit win
00:01 <****> vmware!
00:01 <****> kurlj: and then read http://en.wikipedia.org/wiki/Database_normalization
00:02 <****> Bah, read http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html
00:02 <****> The author's a crack smoking hippy but the article is ok.
00:02 <****> heh
00:02 <****> damn hippies
00:03 <****> i dont mind the reefer but i cant stand the ptchouli
00:03 <****> Indeed.
00:03 <****> Well, anyone? Or only linux users present?
00:03 <****> Well, time to run.
00:04 <****> its beer thirty
00:04 <****> yeah but I didn't get to work until close to 9...
00:04 <****> its 6
00:04 <****> quittin time
00:04 <****> seekwill: For the billionth time no
00:05 <****> Therion: Oh...
00:05 <****> you have to tell seekwill stuff repeatedly
00:05 <****> seekwill: Didn't feel like writing it, and no longer interested in writing anything for that particular bot
00:05 <****> haha
00:05 * Therion humps seekwill repeatedly
00:05 <****> woo!
00:05 <****> Therion: Thanks for waiting until mhillyer left :)
00:05 <****> seekwill: I have a java bot replacement I've been working on; if I ever get around to finishing it, it will have this feature
00:06 <****> Cooool
00:06 * Therion humps mhillyer in absentia
00:06 <****> kinky
00:06 <****> can you binds to a single perpared statement the execute it or does ti have to be done independently?
00:07 <****> I feel like humping something
00:07 * fuse_lt sticks out leg
00:07 <****> hi
00:08 <****> Ni!
00:08 <****> ni ni
00:08 <****> can you make multiple binds to a single perpared statement then execute it or does ti have to be done independently?
00:10 <****> can you have to left joins in a query?
00:10 <****> yes
00:10 <****> 2?
00:11 <****> hehe. what was the limit? 57 or something like that?
00:12 <****> any idea on the prepared stmt question?
00:12 <****> ToeBee: you don't remember?
00:15 <****> not precisely, no :(
00:15 * chadmaynard breaks out the loop
00:17 <****> heh. if a random blog is to be trusted, some russian dude responsible for up to 30% of the... "male enhancement" spam has been shot by the russian mob
00:17 <****> lmao
00:18 <****> That'd be funy
00:18 <****> http://tinyurl.com/2hgk8z
00:19 <****> the guy described reminds me of seekwill
00:20 <****> and archivist! I hope archivist is alive
00:24 <****> is it expensive to inner-join 3 tables, on the primary keys only ?
00:25 <****> I wonder if it would be better (or not) to merge these 3 normalized tables into one bigger table
00:25 <****> whne i union tables.. does it keep the indexes?
00:26 <****> rtconner: the resulting set?
00:26 <****> yeah if I want to say order the resulting set, does that order have access to indices
00:27 <****> rtconner: no.
00:27 <****> thanks chadmaynard, thats what i thought
00:30 <****> ok I rephrase my question. In DB design in general, is it better to have a maximum set of tables, with a perfect normalization, or should we be careful about too much normalization, for performances purposes?
00:32 <****> Cahaan: normalization can hurt performance.
00:32 <****> yes, that's why I store everything as XML blobs
00:33 <****> chadmaynard: ok, even when inner-joining only on primary keys ?
00:33 <****> SpComb: lol, good one
00:35 <****> [19:38] kkruit: chadmaynard, union result always has null possible keys
00:35 <****> [19:40] chadmaynard: kkruit: i'm not sure where you got that but not true.
00:35 <****> wtf?
00:35 <****> kury_71: not to create the result set, in the result set
00:36 <****> yah the union result aka result set the ultimate result of the union
00:36 <****> kury_71: i guess you didn't explain it in a way i understood you
00:37 <****> ok ... sorry i was realy confused made me question everything i ever knew about unions and "EXPLAIN" lol
00:37 * rtconner is lmao.
00:38 <****> kury_71: depends on the day of the week the answer to that question
00:38 <****> :D which i guess isnt a bad thing you learn some when that happens
00:39 <****> You could store the result in a engine=memory temp table and apply indexes if all that work would benefit you
00:40 <****> really? so create memory table, then add indexes, then order it.. then select it?
00:40 <****> rtconner: i would only do that if the set is large and you are going to use it often
00:40 <****> like if the result is some sort of report that you search through or somethin
00:40 <****> g
00:41 <****> i'll keep it under consideration as a possible solution to our problem
00:41 <****> create temporary table like foo;
00:42 <****> and select into is always an option
00:43 <****> how do I change another users password?
00:43 <****> blobaugh: how many clients do you have in this channel?
00:43 <****> !rtfm grant
00:43 <****> (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/grant.html
00:44 <****> thanks
00:44 <****> bye
00:44 <****> wtf
00:44 <****> !man something
00:44 <****> Nothing found.
00:44 <****> is this the same bot?
00:44 <****> no
00:44 <****> this is the old bot
00:44 <****> oh
00:44 <****> the_wench and archivist are MIA
00:45 <****> :X
Total 26 pages. You are browsing page 1/26.
First :: Prev :: [1] [2] [3] [4] [5] [...] :: Next :: Last