• Upgrade
  • Advertise
    • Enjoy unlimited access to all forum features for FREE! Optional upgrade available for extra perks.

    No Nom Update!

    Discussion in 'Nominet General Information' started by Jeewhizz, Jul 4, 2006.

    Thread Status:
    Not open for further replies.
    1. Jeewhizz

      Jeewhizz Well-Known Member

      Joined:
      May 2006
      Posts:
      1,174
      Likes Received:
      18
      Jeewhizz, Jul 4, 2006
      Jeewhizz, Jul 4, 2006
      #1
    2. bb99 United Kingdom

      bb99 Well-Known Member

      Joined:
      Mar 2005
      Posts:
      1,614
      Likes Received:
      38
      I think there were quite a few problems with the (much) earlier versions of the DAC that were caused by Oracle being buggy.

      One would have thought that Oracle would be a bit more switched on / keen to help...
       
      bb99, Jul 4, 2006
      bb99, Jul 4, 2006
      #2
    3. Jeewhizz

      Jeewhizz Well-Known Member

      Joined:
      May 2006
      Posts:
      1,174
      Likes Received:
      18
      In my experience, oracle has just got lucky. They do have some good software, but it's buggy.

      We abandoned Oracle at work for MySQL, and have had no complaints about it. Companies sometimes have issues with using 'open source' but not us ;)
       
      Jeewhizz, Jul 4, 2006
      Jeewhizz, Jul 4, 2006
      #3
    4. A-Wing

      A-Wing Active Member

      Joined:
      Feb 2006
      Posts:
      201
      Likes Received:
      4
      Most people abandon Oracle for Postgre, but I guess with the advent of MySQL 5.0 and 5.1 it is starting to play catch-up.
      I have this one client with a MySQL 4.1 server for whom I have shoved 8GB of data into tables for (using some special scripts that ran for about 2 weeks :) ). I managed to get their query times down from 30 seconds to under 1 second for searches. MySQL is deffinitely starting to join with the big boys.
       
      A-Wing, Jul 4, 2006
      A-Wing, Jul 4, 2006
      #4
    5. Jeewhizz

      Jeewhizz Well-Known Member

      Joined:
      May 2006
      Posts:
      1,174
      Likes Received:
      18
      The last month i've been working with a DB of about 45 million records across 1000 tables. Cross referenced queries are running at <0.5 seconds now down from over a minute on the previous solution.

      MySQL is definately making insteps into the DB market :)
       
      Jeewhizz, Jul 4, 2006
      Jeewhizz, Jul 4, 2006
      #5
    6. A-Wing

      A-Wing Active Member

      Joined:
      Feb 2006
      Posts:
      201
      Likes Received:
      4
      sweeeet ;)
      Going from version 3.23 -> 4.1 is like changing product, all the features you could want (apart from stored procedures which are in v.5) and amazing speed increases (mainly due to decent key and query caching).
       
      A-Wing, Jul 4, 2006
      A-Wing, Jul 4, 2006
      #6
    7. Jeewhizz

      Jeewhizz Well-Known Member

      Joined:
      May 2006
      Posts:
      1,174
      Likes Received:
      18
      5.1.6 is the killer - cron jobs within mysql ;)
       
      Jeewhizz, Jul 4, 2006
      Jeewhizz, Jul 4, 2006
      #7
    8. A-Wing

      A-Wing Active Member

      Joined:
      Feb 2006
      Posts:
      201
      Likes Received:
      4
      I noticed that on the site (not tried 5.1 yet though), could be very useful for DB/index clean-ups, especially if you delete a lot of records.
       
      A-Wing, Jul 4, 2006
      A-Wing, Jul 4, 2006
      #8
    9. philipp United Kingdom

      philipp Active Member

      Joined:
      Feb 2005
      Posts:
      638
      Likes Received:
      17
      Stored procedures always seem a pretty evil idea to me (I'm not a DBA, maybe they have greater tolerance for this kind of thing).

      But having seen Nominet's struggle with Oracle bugs, I wouldn't really want anything to do with it :)

      P.
       
      philipp, Jul 5, 2006
      philipp, Jul 5, 2006
      #9
    10. Jeewhizz

      Jeewhizz Well-Known Member

      Joined:
      May 2006
      Posts:
      1,174
      Likes Received:
      18
      Stored Procedures are quite handy. If for example, you have one dedicated DB Server, and multiple web servers, if you need to edit a procedure, you can do it in one go on the DB Server, or edit the files across all the webservers!

      I'm planning on using MySQL events for database optimising and running time sensitive queries.
       
      Jeewhizz, Jul 5, 2006
      Jeewhizz, Jul 5, 2006
      #10
    Thread Status:
    Not open for further replies.

    ▲