Berkeley CSUA MOTD:Entry 26724
Berkeley CSUA MOTD
 
WIKI | FAQ | Tech FAQ
http://csua.com/feed/
2025/04/04 [General] UID:1000 Activity:popular
4/4     

2002/12/5-6 [Computer/SW/Database] UID:26724 Activity:high
12/5    Q for DBAs.  How often do you examine your schema for new indexes
        needed.  Our lead programmer is giving me headaches with his "Well
        it works on MSSQL," while our Postgres and Oracle development continues
        to falter.  I came up with a possible new index last night to solve
        a customer's issue, and he got all up in arms with "DON'T QUESTION MY
        SCHEMA!"  Am I insane thinking that DB tuning should be ongoing?
        Or is he just trying to defend his ignorance? --scotsman
        \_ He is defending his ignorance.  It's not like you should be doing
           quarterly schema reviews though.  Tune as needed, i.e. if you
           notice a serious performance issue, if your dataset changes
           significantly, or if the kinds of queries you make change
           significantly.
           \_ Mostly agree. Quarterly reviews of the database can be useful.
           \_ even if you dont do a review every 3-4 months, every 3-4 months,
              you should ask "should we do a review?"
        \_ Developers should only be responsible for the logical schema
           design anyway.  Physical designs such as indexes should be the
           DBA's responsiblity.  Mostly because most developers don't know
           better how a particular index would affect performance.  Tell
           your ignorant lead programmer that it works on MSSQL because
           its optimizier works completely differently (duh, as if it
           needs to be said).
2025/04/04 [General] UID:1000 Activity:popular
4/4     

You may also be interested in these entries...
2009/9/23-10/5 [Computer/SW/Database] UID:53392 Activity:nil
9/23    I never took CS188, is there a good book that's an intro to formal
        database theory, normalization, etc.?  I've got experience with SQL
        (MySQL & MSSQL), and understand tables, etc.
        \_ You mean CS186?
           \_ Oops, yah.  188 is AI or something?
              \_ That's right.
	...
2008/4/29-5/5 [Computer/SW/Languages/Perl, Computer/SW/Languages/Python] UID:49852 Activity:moderate
4/29    Scaling your web app in the real world:
        http://teddziuba.com/2008/04/im-going-to-scale-my-foot-up-y.html
        \_ This article is crap.  While yes, 99.9% of all websites don't
           need any serious scalability plans, if any of them become worth
           anything they will need to scale.  If you write a web application
           without careing about scalability you are writing a webapp that can
	...
2006/3/25-26 [Computer/SW/OS/FreeBSD] UID:42421 Activity:very high
3/24    Wow!  FreeBSD sure is stable!  After seeing soda's amazing uptime
        record, I sure want to go replace my Linux boxes with FreeBSD!
        Please do not delete this, or burn down Linus' house because I have
        blasphemed the holy FreeBSD.  I'd love to see a genuine discussion with
        examples from both sides comparing the stability of *modern* FreeBSD
        and Linux machines running on x86 hardware. -dans
	...
2006/3/14-16 [Computer/SW/Database] UID:42233 Activity:nil
3/14    Hello Oracle experts. Is there a reason why .getProcedures takes
        so long to execute? I've tried using different jdbc connectors
        from different vendors and have the same results, so I think
        it must be the DB hog backend. Why does it take so long?
        try{
          DatabaseMetaData dbmeta  = con.getMetaData();
	...
2005/7/22-25 [Computer/SW/Database] UID:38784 Activity:nil
7/22    I never took a formal DB theory class, excuse me for asking SQL
        questions. When I create a table, I can choose PRIMARY KEY to be
        based on a single or n-tuple column. When I do that, are indices
        created automatically? Second question is, if the indices are
        created for n-tuple, does that mean all the column have fast
        index, or they are all based on previous columns? For example, if
	...
2005/4/8-10 [Computer/SW/Database] UID:37118 Activity:moderate
4/8     Anyone reccomend a good mysql programming tutorial that goes
        beyond the basic select statements ? I would like to be able
        to do a distinct on specific column and then do a count of all
        the rows that have the corresponding values. thanks  --ramberg
        \_ select t.col, count(*) from tble t group by t.col;
           \_ thanks. --ramberg
	...
2004/11/22-23 [Computer/SW/OS/OsX] UID:35021 Activity:low
11/22   What's a good database program for Mac OSX? I just found out they
        don't make MS Access for macs. I did a quick search and found a
        Filemaker. Can anyone recommend any others? Thanks.
        \_ what's your need?  FileMaker is fine (better than Access) for
           personal/home use.  -tom
        \_ MySQL?  as above, what do you need it for?  I also like
	...
2004/3/25 [Computer/SW/Database] UID:12849 Activity:nil
3/25    Ok please tell me the pros/cons of mysql vs. postgreSQL. For me
        speed is really really important. On the other hand, packaging
        (ease of install, consistent commands, etc) is also very important
        for development. I've just tried mysql for the first time and I'm
        NOT very impressed. The documentation that came with it was outdated
        (some of the tutorials didn't work) and it didn't even pass all of
	...
2003/3/12-13 [Computer/SW/Database] UID:27673 Activity:very high
3/12    mySQL vs. postgreSQL: Thoughts? Likes? Dislikes? Horror stories?
        Success stories?  Thanks.
        \_ I have found mySQL to be surprisingly good. I built a network
           and system management product using mySQL for the db backend.
           This system has been deployed in several dozen sites worldwide
           with between 100-500 nodes managed per site. Most of the sites
	...