| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12
Comments:
<0> i dont get how my db design is bad design
<1> ..I mean, he was a phone phreaker to begin with
<2> go figure
<0> like we had critical failure in the past and like this way it doesnt effect any other clients
<3> catzai, at this point you are too emotionally invested in the solution to see it objectively
<0> naw man
<2> critical failure, was it your fault?
<0> naw
<0> but one of the databases got ****ed
<1> handling schema changes on how many databases?
<0> like someone did a delete
<2> and?
<0> dood i have a project that handles schema changes
<0> it keeps all the database in parallel
<1> it must be one helluva project
<3> :)
<2> so how much time do you spend managing your custom crap to support a bad design?
<0> u click a few buttons and it updates the databases
<0> like are u sayin i should dump all my databases into one database?
<0> wont that make it slow?
<2> if i had someone delete data from one of my dbs, if its 1tb, or 1 row its an easy recovery
<0> how are u gonna recover that?
<0> look isnt my design more stable?
<0> in case someone does delete crap
<2> well i would either duplicate the object or tablespace to a point in time, or i could flash back to before the delete and copy the data to a temporary table
<0> wot if u dont have a backup
<2> or i could just undrop the object if they dropped it
<1> it doesn't sound like theres very much data in each database
<2> I always have backups. every change is logged (to 2 copies), everything is backuped up full to 2 copies
<0> its alot of work
<2> no it isnt. i dont do any of it. its all built in
<3> Oracle DBA's don't know what in hell they're doing with backups.
<0> some databases are big some are small
<1> true, most don't... and in 8i it was no trouble just shutting down the idle db and copying the datafiles
<1> hence, unix admins could handle it
<0> like should i make all my dbs into one db?
<2> insert into tabledeletedFrom (select * from tabledeletedFrom as of timestamp to_timestamp(sysdate-1/12) ) minux select * from tabledeletedFrom
<1> can't say... I probably would have though
<0> i dont see how lots of dbs is bad
<0> its more stable
<2> that would recover all data if someone dropped it 90 minutes ago. back to what was there 2 hours ago
<0> timestamp keeps a backup of data?
<2> do you now even know what a timestamp is?
<2> s/not
<0> a hex value?
<0> when u insert stuff
<0> or delete it
<2> no
<4> hehe
<2> you are a "developer" and dont know what timestamp is?
<4> tell us ;)
<0> its some hex value that gets added to each row
<0> i guess there is time info on there
<0> and maybe data about that row
<0> i didnt kno timestamp lets u do recovery tho
<2> you dont know what it is :P
<2> but thats just an example that with a real database, properly configured, data recovery is very easy
<0> wait so if u had a timestamp on all ur tables
<0> u can recover after a delete?
<5> dont be silly... timestamp is the thing you get when you go to a club
<5> and they stamp it on your hand
<3> yeah, it glows at some clubs
<5> any real developer will know that
<2> 28-MAR-03 06.34.14.000000 PM <-- that is a timestamp
<2> nothing more
<3> besides, catzai, Jarett was tricking you; SQL Server's TIMESTAMP datatype is not ANSI
<2> "as of" is the important part.
<2> as of lets you recover. those 2 simple words...
<3> :)
<0> yah
<0> jarett is so full of it
<0> like first of all there isnt a backup database
<0> how are u suppose to recover from a delete without a backup database?
<0> even with a timestamp
<3> he just likes to test you and see if you're "bob from accounting" that became an MS programmer via VBA, or if your l33t skIlZ are up to his 'standards'
<0> dood i made 10k databases didnt i?
<3> anyone can do that
<0> thats 1337 haxorin
<2> ohhhh man the people out of the technology group at work who think they are developers since they use excel.... those people bug me like you wouldnt beleive
<3> just run the same script 10,000 times
<3> Jarett_, I have the most trouble with the "Bob from Accounting" types
<2> if you arent in technology, you dont get to touch the databases :P
<2> we don have an accounting group
<3> "See, I have this Excel database..."
<0> man but seriously wont my design scale out to a cluster just awesum?
<2> we have 3 people in finance.
<2> but the rest are "client services"
<2> catzai, no.
<0> why not
<2> try it and find out
<0> i can put 5 k on one box
<0> and 5k on another
<3> meeting time; bbiaw
<2> thats not a cluster
<2> thats 2 db servers
<0> yah
<0> 2 comp cluster
<0> like i have one huge mega db
<0> with everything dumped on it
<0> say all the customers around the world try to access it all at once
<0> wont it go real slow
<0> compared to 10k dbs seperated out
<2> is your name jacob?
<0> yah
<0> wot about it
<0> cuz like each sql statement has to execute sequentially in the mega db
<0> and they can all run in parallel in the divided out db
<0> doesnt that make sense?
<2> you get the same timeslices from your cpu with 1 big one as 10000 small ones
<2> and less since you need more overhead to manage each instance
<2> and the weakest link is the disk access. and since you have less sequential disk reads, you kill yourself on disk performance
<0> no but there is a rule in db architecture that one sql statement cant execute until the previous completes in a db
<2> no there isnt
<0> ya there is
<2> no there isnt
<0> are u sure?
<2> most databases, even crappy ones like sql server know about row level locking
<2> and reads (selects) are rarely blocked.
<0> how bout inserts?
<2> unless its a select for update, and then there are still limited locking in place
<2> usually row level, and only during the commit phase
<6> Even Access has row level locking
<0> dang so my 10k dbs wont run faster?
<2> how many hours have you spent making custom apps to handle your "133t design"?
<4> lol
<0> 20
<0> i dunno
<4> wuts his design
<4> not to use a database? lawl
<0> i got like 10k clients i gave them all thier own db
<4> and then replicate?
<0> yah
<4> why?
<4> lawl
<0> replicate?
<0> wots that
<4> top secret....just checking
<1> heh crap, why not just store everything in a flat file and do regex searches using PERL!
<1> yeee-haw
<7> hmm it should be possible to INSERT A where B = C VALUES D right?
<0> dood
<1> dood
<2> peoplez, shouldnt you reorder that a little?
<0> so the only problem is i have a custom app
<1> no where clauses in inserts
<7> hmm what am i doing wrong
<0> and i have more overhead
<6> inventing syntax
<4> lol
<7> been fiddelin with it for a while now
<7> lol
Return to
#sql
or
Go to some related
logs:
#sex
#heroin
iomegaz
G15 Launchcast
#nhl
WMMVY.PK
#computers
#red
#politics
rofl chopter
|
|