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

2001/6/26 [Computer/SW/Database] UID:21635 Activity:insanely high
6/26    OK here is the deal- my new data structure was just bombing when
        I ran it in access- performing analysis in 1,000,000 records
        linked to countless other tables is just plain slow using access.
        They guy before me just had everything sitting in one table and
        only 250,000 records- blinding fast- but he had no thought of
        having any integrity to the data and flexibility of reference
        tables- See I don't think in terms of normalizing structure I
        think just of reference. Which basically can almost be defined as
        the same thing- But I still never design in real 3rd form- thats
        another subject....  So I changed the structure of the database
        and everything was running piss ass slow in Access These guys
        won't give me Oracle so I decided to setup MySQL.  Well last
        night I finally finished porting over some data to populate the
        new MySQL tables I ran a simple query joining 2 tables and MySQL
        took 2 seconds Access took 30 seconds.
          My boss was not impressed.... he went on a tirade about how fast
        access was with all the data sitting in one table-- and that
        mySQl was going to bomb in a multiple user env.  I had to sit
        calmly right next to him when he basically threw my work out the
        window- He then goes on to say- I think the multiuser env is
        going to really start to hurt us and we should probably upsize to
        Oracle........  People like this need to get out of the
        management business.  Right now corporations are blowing billions
        on Oracle databases to do functions which can easily be handled
        by FREE solutions...  He then goes on and says - oh we can't
        install that on the server. I was like its 2 damn files which
        don't screw with any windows setting
          Just amazing. good thing I am just content to work in my hole
        with no regard what happens around me.. Not really this does piss
        me off but what can I do-
          And this database isn't even modified- all the users do is run
        queries and view records.....  I do all the modifications and
        update of the data like once a quarter
        \_ work for oracle?
        \_ How are users going to access the mysql database to run queries?
           If your users going to do it with Access, it's going to be hell
           to administer.  Mysql doesn't handle locking too well with
           Access clients.
         \_ wow.  Tell your boss he is a moron and he shouldn't be making
            these decisions.  Do what is right (PostgreSQL) and then if
            you get fired be GLAD that you now will get a tiny bit of money
            on unemployment while you dick around before getting another job
            which you obviously need to do anyway.
2025/04/04 [General] UID:1000 Activity:popular
4/4     

You may also be interested in these entries...
2013/10/28-2014/2/5 [Computer/SW/Database] UID:54751 Activity:nil
10/28   Oracle software to blame for Obamacare website debacles:
        http://www.forbes.com/sites/theapothecary/2013/10/14/obamacares-website-is-crashing-because-it-doesnt-want-you-to-know-health-plans-true-costs
        \_ Larry Ellison is a secret Tea Party supporter.
           Most of this article is bunk, btw. Boy are the Republicans
           getting desperate.
            \_ Umm, no.  Larry Ellison is a not so secret fascist.
	...
2011/12/20-2012/2/6 [Politics/Foreign/Asia/China, Computer/Rants] UID:54268 Activity:nil
12/20   A higher percentage of people in China than in Pakintan have an
        unfavorable view of China:
        http://www.pewglobal.org/database/?indicator=24&response=Unfavorable
        Go figure.
        \_ damn these self critical liberals!
	...
2011/12/29-2012/2/6 [Computer/SW/Database] UID:54274 Activity:nil
12/29   Is it worthwhile to use ext4 on VMs? Is Journaling necessary on VMs?
         \_ what about DBs?  I read somewhere ext3 was better for DB voumes (mysql)
	...
2011/11/27-2012/1/10 [Computer/HW/Drives] UID:54244 Activity:nil
11/27   CalMail has been down for a few days (hardware failure and database
        corruption -- sounds like fun!) and is starting to come back online.
        Looks like they're planning to outsource all campus mail to either
        Google Apps or Microsoft 365 as part of Operational Excellence.
        <DEAD>kb.berkeley.edu/jivekb/entry!default.jspa?externalID=2915<DEAD>
        \_ http://ist.berkeley.edu/ciocalmailupdates/november-30-2011
	...
2011/2/14-4/20 [Computer/SW/Unix] UID:54039 Activity:nil
2/14    You sure soda isn't running windows in disguise?  It would explain the
        uptimes.
        \_ hardly, My winbox stays up longer.
        \_ Nobody cares about uptime anymore brother, that's what web2.0 has
           taught us.  Everything is "stateless".
           \_ You;d think gamers would care more about uptime.
	...
2010/11/21-2011/1/13 [Computer/SW/Languages/Web] UID:53988 Activity:moderate
11/21   Lifehacker's recommending Dreamhost as a personal web hosting service.
        Apart from csua, who do you guys use? --erikred
        \_ What do you want to use it for? Do you need CGI or PHP?  My
           brother worked for Dreamhost and said they are unethical. In
           fact, he sued them. This refers to their treatment of customers
           and employees both. I don't know who  or what "Lifehacker" is,
	...
2010/8/10-9/7 [Computer/Companies/Google] UID:53919 Activity:nil
8/10    http://www.businessinsider.com/google-puts-wave-out-of-its-misery-2010-8
        Google Wave No More. The people who worked on it were pretty smart.
        They wrote up a super awesome OKR with extremely low bar as a measure
        of success, exceeded everyone's expectations by going above those
        bars, and got big fat bonuses and promotions as a result of their
        planning. Brilliant.
	...
2010/8/12-9/7 [Computer/SW/Languages/Perl] UID:53922 Activity:nil
8/12    Ruby coders, do you mostly DIY your stuff or use the ruby libs out
        there?   How is their quality compared to other libs you have used
        for other langs?  Thx.
        \_ I use Ruby for hobby stuff, etc.  I use libraries for system stuff
           (web access, process, etc.) but that's about it.  Perl libraries are
           much better/more complete.  I assume because of the maturity and
	...
2010/7/11-23 [Computer/SW/Database, Recreation/Sports] UID:53880 Activity:nil
7/11    "Paul the Oracle Octopus goes eight for eight, is amazing"
        http://www.csua.org/u/r4b
        How did one octopus guess something that has 1/256 probability???
        \_ I once rolled eight "1"s in a row at Risk.
           \_ But you would be in the spotlight only after you rolled eight
              "1"s, just like lottery winners.  OTOH that octopus was already
	...