| rindolf | MitchM: but why do you have to "go out"? |
| simcop2387 | gee the chinese must have censored the second law of thermodynamics, http://hardware.slashdot.org/article.pl?sid=07/03/02/049254 |
| shorten | simcop2387's url is at http://xrl.us/u57m |
| integral | Comrades, we must rise up together against the bourgeois constraints of Capitalist physics! |
| merlyn | _child events come in when kids are added/deleted |
| revdiablo | Of course I am one to talk. The main db I work with is a mysql monster with 150+ tables |
| merlyn | do you have a _default or something? |
| Jmax- | yes, i do |
| merlyn | so it'll show up the _child events no biggy |
| Jmax- | ah, i see. |
| Khisanth | revdiablo: not that many :) |
| Jmax- | how can i make it ignore _child events? |
| merlyn | if you don't have _child, they just happen with no error don't have _default! |
| Jmax- | just make an empty _child ? |
| revdiablo | Khisanth: I'm sure there are much more complicated examples =) |
| Jmax- | well i want something for debugging purposes |
| merlyn | or yeah, add a dummy _child handler |
| Woosta | When did the new DST rules hit the US? |
| revdiablo | Khisanth: We don't have a lot of data, either. Biggest table only has a couple million rows |
| Khisanth | heh |
| revdiablo | Khisanth: But... joining together 20 tables or so in one query always makes me wonder |
| Khisanth | revdiablo: we have that many table but more or less out of necessity :) |
| garywsmith | revdiablo: Then again, my 50M row database is only 800mb for the main table and 2.5g for a couple of the sub tables that aren't really used that much |
| revdiablo | Ours is the way it is from a combination of legacy design and complicated data we're trying to record |
| Jmax- | merlyn: thanks :) (satisfied customer)++ # me! |
| merlyn | cool |
| garywsmith | revdiablo: sorry, plus indexes |
| merlyn | perlbot, karma satisfied customer |
| perlbot | Karma for satisfied customer: 138 |
| revdiablo | garywsmith: Ours is about 87M compressed dump, so not that big at all It's wide, not deep =) Khisanth: What kinda data are you storing, out of curiosity? |
| Khisanth | real estate - property value, building characteristics, sales, various legal documents relating property, ... :) |
| revdiablo | Ah We're tracking location, excavation, and analysis of things like fish bones, tin cans, and sometimes even human remains... |
| merlyn | wow. tim o'reilly noticed my slashdot posting, and wrote me to thank me s/thank/congratulate/ |