Results 1 to 6 of 6
  1. #1
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Unanswered: Oracle versus SQL??

    Has anyone noticed that Oracle can be a little bit difficult to work with at times?? Maybe some compatbility issues as well??

  2. #2
    Join Date
    Oct 2004
    Posts
    145
    Not that oracle is more difficult to work with. If you are a beginner MS SQL might be little easier to use due to gui tools and simplistic approach.

    However, database is a database and both have same fundamental issues with I/O, poor data modelling, poor code, etc.

    If you had to choose between two, I would look more at the requirement side. Application/vendor preference, size, cost, etc.

  3. #3
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Yes I agree

    I understand that a database is a database (ANSI) but I am curious about some of the things I have heard in the past. I know that poor datamodeling and scripting is due to the designers error. Just being Inquisitive I suppose

  4. #4
    Join Date
    Mar 2002
    Location
    Reading, UK
    Posts
    1,137
    Oracle does have a steeper learning curve than Sqlserver or Sybase but then I would argue Oracle is a better product IMHO. The fundamental difference is that Oracle has been designed for worst case scenarios and they have provided the tools however complicated for you to diagnose and solve those problems. Sqlserver on the other hand has been designed for the best case scenario and they hope you dont come across lots of people all after the same bits of data. So if you mainly have a few connections, mainly doing reads and not looking/modifying the same bits of data then great, Sqlserver will kill Oracle. Get thousands of connections doing lots of reads and writes against the same bits of data then Oracle will kill Sqlserver, just ask any sqlserver dba about the joys of escalating locks .

    As for the steeper learning curve get a good tool like Quest TOAD. Also dont forget Oracle is pretty damn reliable which is useful for 24x7 systems .

    Alan

  5. #5
    Join Date
    Feb 2004
    Location
    Alpine Califormia
    Posts
    1,789

    Ok

    Ok Alan thank you that helps allot

  6. #6
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Has anyone noticed that Oracle can be a little bit difficult to work with at times?? Maybe some compatbility issues as well??
    Not really.

    Compatibility with what?

    Software can be a little bit difficult to write sometimes. Life's like that.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •