<dtm> chillywilly: whatcha listening to
<chillywilly> 4him
<dtm> chillywilly: what DT were you on?
<chillywilly> DT?
<dtm> dream theater
<chillywilly> I dunno that was a while ago ;)
<chillywilly> bah
SachaS (~Sacha@dialup-196-21.wasp.net.au) left #gnuenterprise ("Client exiting").
<thierry> morning all
<dtm> thierry: hi
<thierry> hello dtml
<thierry> hello dtm
<dtm> ahoy
<wendall911> any db gurus on tonight?
<wendall911> my question:
<wendall911> if I constructed a sql query that selects from say 500 tables at once, will most dbms going to handle that well? Or is that in bad form? working with a large normalized database
reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) joined #gnuenterprise.
<dtm> wendall911: you might restate that for reinhard :)
<wendall911> dtm: ok
<dtm> he's the supafly daddy mac, etc
<wendall911> dtm: did you follow what i'm saying?
<wendall911> dtm: i'm building a test case right now, but just fishing for advice
<dtm> i'm not a DBA so i dunno
<dtm> i parsed it merely as English, which was in fine form :)
<wendall911> heh, then it has to work with the db
<wendall911> ;)
SachaS (~Sacha@dialup-196-21.wasp.net.au) joined #gnuenterprise.
<wendall911> reinhard: ping
<reinhard> pong
<wendall911> if I constructed a sql query that selects from say 500 tables at once, will most dbms going to handle that well? Or is that in bad form? i'm working with a large normalized database
<reinhard> not sure about what db's do
<reinhard> but i don't think it is good
<wendall911> reinhard: so if i'm trying to retrieve all data associated with an item, would using several separate queries, then reconstruct with code be more appropriate?
<reinhard> what i wanted to say is
<reinhard> i'm not sure if it is a good database design if you have to query 500 tables at all
<wendall911> reinhard: yeah, that's my thought as well, jbailey pointed out normalized data to me. I use forms of normalized data, but 100% normalized data creates this situation when there are alot of values associated with a set of data.
<wendall911> reinhard: i'm just going to try a bunch of different things and build test cases to see what will work best
Action: wendall911 goes back to the drawing board
<reinhard> i've always seen nomralization as a "general direction", not as a strict law
<wendall911> reinhard: i'm taking it that way as well, otherwise, the db ends up bloated
btami (~btami@ip102-205.ktv.tiszanet.hu) joined #gnuenterprise.
<wendall911> reinhard: i built a test case against my question. It is VERY bad to do that. I could handwrite the data faster.
dyfet (~dyfet@pool-141-153-201-180.mad.east.verizon.net) joined #gnuenterprise.
<dtm> :-o
<dtm> it is the mighty dyfet!!!!
<dtm> dyfet: how in tarnation are ya?
wendall911 (~wendallc@torus.nidaho.net) left irc: "Download Gaim: http://gaim.sourceforge.net/"
ToyMan (~stuq@user-0cevdks.cable.mindspring.com) joined #gnuenterprise.
ToyMan (~stuq@user-0cevdks.cable.mindspring.com) left irc: "Client Exiting"
ToyMan (~stuq@smtp.dstoys.com) joined #gnuenterprise.
dneighbo (~dneighbo@ip68-109-180-32.ph.ph.cox.net) joined #gnuenterprise.
jbailey (~jbailey@199.212.225.1) joined #gnuenterprise.
jamest (~jamest@gw.math.ksu.edu) joined #gnuenterprise.
dsmith (~user@mail.actron.com) joined #gnuenterprise.
derek (~dneighbo@ip68-109-180-32.ph.ph.cox.net) left irc: Read error: 110 (Connection timed out)
btami (~btami@ip102-205.ktv.tiszanet.hu) left irc: 
jcater (~jason@w202.z065105010.mem-tn.dsl.cnc.net) joined #gnuenterprise.
wendall911 (~wendallc@torus.nidaho.net) joined #gnuenterprise.
<dsmith> Hey, someone use my nick.  I want to see how it highlights.
<wendall911> dsmith: you can boot them if you are registered, I can't remember the command though
<jbailey> dsmith: Is it true that you're Derek's goat?
<wendall911> dneighbo: congrats on the new release of dcl
<dsmith> !!
<jbailey> dsmith: It was the only thing that came to mind. =)
<dsmith> wendall911: Was that supposed to mean anything? Or just random text with my nick thrown in?
<wendall911> dsmith: lol, i totally misunderstood
<wendall911> dsmith: it was random text
Action: wendall911 needs a cup of coffee
Action: wendall911 scurries away
ribu (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) joined #gnuenterprise.
damokles (~damokle@pD9E45DB4.dip.t-dialin.net) joined #gnuenterprise.
<damokles> HI
ToyMan (~stuq@smtp.dstoys.com) left irc: "Client Exiting"
<jamest> hi
damokles (~damokle@pD9E45DB4.dip.t-dialin.net) left irc: "bye all"
btami (~tamas@wrr.napnet.hu) joined #gnuenterprise.
jbailey (~jbailey@199.212.225.1) left irc: "Client exiting"
siesel (jan@xdsl-195-14-223-38.netcologne.de) joined #gnuenterprise.
mouns (mouns@kali.mouns.org) joined #gnuenterprise.
btami_ (~tamas@wrr.napnet.hu) joined #gnuenterprise.
ToyMan (~stuq@user-0cevdks.cable.mindspring.com) joined #gnuenterprise.
btami (~tamas@wrr.napnet.hu) left irc: Read error: 110 (Connection timed out)
dsmith (~user@mail.actron.com) left irc: "Good Night all"
btami_ (~tamas@wrr.napnet.hu) left irc: "Leaving"
reinhard (~reinhard@M1264P004.adsl.highway.telekom.at) left irc: "When all else fails, read the instructions."
jamest (~jamest@gw.math.ksu.edu) left irc: "Client exiting"
thierry_ (~thierry@musashi.xtensive.com) joined #gnuenterprise.
thierry (~thierry@musashi.xtensive.com) left irc: Read error: 110 (Connection timed out)
siesel (jan@xdsl-195-14-223-38.netcologne.de) left irc: "Client exiting"
ribu (~sjc@cpc2-seve3-4-0-cust112.popl.cable.ntl.com) left #gnuenterprise ("Client exiting").
mouns (mouns@kali.mouns.org) left irc: Remote closed the connection
jamest (~jamest@adsl-65-64-191-177.dsl.tpkaks.swbell.net) joined #gnuenterprise.
ToyMan (~stuq@user-0cevdks.cable.mindspring.com) left irc: "Client Exiting"
wendall911 (~wendallc@torus.nidaho.net) left irc: "Download Gaim: http://gaim.sourceforge.net/"
ajmitch_ (~ajmitch@ex-vodca.otago.ac.nz) left irc: "Leaving"
--- Fri Dec 19 2003