Announcement

Collapse
No announcement yet.

Which database... help me... :)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Which database... help me... :)

    Hi, ok Im in the process of re-developing my main web site.

    Currently its very MySQL hungary and in less than a years time MySQL will simply not cut it...

    So,I have to change the RDBMS being used and I have 2 choices.. the free version of sybase or PostgreSQL

    Simply for support and the fact that redhat are now promoting PostgreSQL, im thinking of going for that.

    However, my main concern is that does PostgreSQL perform under high load (as mysql doesnt )

    Is it wise for me to port over the PostgreSQL or should I go to a better RDBMS from the start (Sybase).. please help, i know almost nothing about postgre!!

    Thanks all!
    http://www.e-tones.co.uk - The best site on the net for mobile phones.

  • #2
    I'll mainly comment on Postgresql as I know that better than Sybase.

    Postgresql does handle loads as well as commercial RDBM'S, unless you are Yahoo or someone like that I wouldn't worry - I doubt with properly set up server/servers you will ever run into trouble with Postgresql.

    You should read the Postgresql faq.
    http://postgresql.planetmirror.com/d...q-english.html
    "Features
    PostgreSQL has most features present in large commercial DBMS's, like transactions, subselects, triggers, views, foreign key referential integrity, and sophisticated locking. We have some features they don't have, like user-defined types, inheritance, rules, and multi-version concurrency control to reduce lock contention."

    For missing features of Postgresql see the TODO list
    http://postgresql.planetmirror.com/docs/todo.html

    Sybase is not better - just different.
    Some annoying things about Sybase -
    No LIMIT - clause - you can simulate LIMIT sometimes using stored procedures but sometimes you can't do it exactly.
    No DELETE or Updating foreign keys - real pain that is.
    As far as I know Sybase doesn't use "multi-version concurrency control" but I could be wrong.

    Switching a MYsql application to Postgresql won't be a big deal - but with Sybase it's a bit harder.

    Comment


    • #3
      cheers 4php... looks like im moving to postgreSQL

      cheers again
      http://www.e-tones.co.uk - The best site on the net for mobile phones.

      Comment


      • #4
        bah, use flat files

        j/k

        Comment


        • #5
          this from a guy who runs a hosting company

          bah.. the worlds comin to an END!!
          http://www.e-tones.co.uk - The best site on the net for mobile phones.

          Comment


          • #6
            Originally posted by etones
            this from a guy who runs a hosting company

            bah.. the worlds comin to an END!!
            heh heh
            Nah, wouldnt wish FlatFiles on my worst enemy

            Comment


            • #7
              Originally posted by 4php
              Sybase is not better - just different.
              Some annoying things about Sybase -
              No LIMIT - clause - you can simulate LIMIT sometimes using stored procedures but sometimes you can't do it exactly.
              No DELETE or Updating foreign keys - real pain that is.
              As far as I know Sybase doesn't use "multi-version concurrency control" but I could be wrong.
              True -- although I can count the number of times I've needed LIMIT on one hand (2 to be exact) and SP's have worked each time. But it *would* be nice to have that integrated into the SQL language.

              What do you mean DELETE or UPDATE foreign keys?

              Nope, no 'multi-version concurrency control'. I don't think this is a "plus" or a "minus". Just a different way of doing things. I can think of reasons why MVCC would be HORRIBLE for an application and I can think of times in which it is nice to have. Different strokes for different folks.

              But if you are wondering MVCC means that if I'm updating a row and you request it, the server will give you the previous content of the row. For something of low-priority as a message board this is no problem. If you were using something of more importance it could be a very big deal that the UPDATE you just issued may not take effect to all readers.

              Originally posted by 4php
              Switching a MYsql application to Postgresql won't be a big deal - but with Sybase it's a bit harder.
              Yes.
              Matt
              Sybase DBA / PHP fanatic
              Sybase v. MySQL v. Oracle | Why I don't like MySQL | Download Sybase TODAY! | Visit DBForums.com!

              Comment


              • #8
                cheers Matt, me thinks i'll be moving to PostgreSQL, i cant find enought support for Sybase and you're never online

                Cheers m8ey, ceeya later.
                http://www.e-tones.co.uk - The best site on the net for mobile phones.

                Comment


                • #9
                  Originally posted by etones
                  cheers Matt, me thinks i'll be moving to PostgreSQL, i cant find enought support for Sybase and you're never online

                  Cheers m8ey, ceeya later.
                  Good luck!

                  (p.s. I'm on DBForums all the time silly! )
                  Matt
                  Sybase DBA / PHP fanatic
                  Sybase v. MySQL v. Oracle | Why I don't like MySQL | Download Sybase TODAY! | Visit DBForums.com!

                  Comment


                  • #10
                    Originally posted by etones
                    cheers Matt, me thinks i'll be moving to PostgreSQL, i cant find enought support for Sybase and you're never online

                    Cheers m8ey, ceeya later.
                    If Nusphere keep their promises regarding MySQL features, you may find MySQL *will* be powerful enough. You can be confident that MySQL will always have speed as a high priority and let's face it, fro web apps (discounting shopping carts etc), that's what we all want PostgreSQL is feature rich, but there is a performance penalty. You don't get owt for nowt
                    http://britishexpats.com/ - British expatriate community

                    Comment


                    • #11
                      Originally posted by MattR


                      Good luck!

                      (p.s. I'm on DBForums all the time silly! )
                      hehe i am over there too now.. lurking and learning hehe
                      :: Always Back Up Forum Database + Attachments BEFORE upgrading !
                      :: Nginx SPDY SSL - World Flags Demo [video results]
                      :: vBulletin hacked forums: Clean Up Guide for VPS/Dedicated hosting users [ vbulletin.com blog summary ]

                      Comment


                      • #12
                        Check out NuSphere's Gemini table type, which is now a GPL product available for free download from www.mysql.org

                        The direct link for download is http://www.mysql.org/listfile3.php?cat_id=MySQL-3.23

                        This should really help the scablity and performance of MySQL, especially for larger sites which have problems with table locking.

                        Comment


                        • #13
                          Originally posted by Chris Schreiber
                          Check out NuSphere's Gemini table type, which is now a GPL product available for free download from www.mysql.org

                          The direct link for download is http://www.mysql.org/listfile3.php?cat_id=MySQL-3.23

                          This should really help the scablity and performance of MySQL, especially for larger sites which have problems with table locking.
                          uh oh! No nice RPM to download Who's gonna volunteer to be first to try it?
                          http://britishexpats.com/ - British expatriate community

                          Comment


                          • #14
                            I'm compiling it now I'll let you know how it goes!

                            Comment


                            • #15
                              Originally posted by fastforward

                              If Nusphere keep their promises regarding MySQL features, you may find MySQL *will* be powerful enough. You can be confident that MySQL will always have speed as a high priority and let's face it, fro web apps (discounting shopping carts etc), that's what we all want PostgreSQL is feature rich, but there is a performance penalty. You don't get owt for nowt
                              I think this Postgresql performance penalty is way overrated - sure maybe on a page with 20 simple select queries MYsql may get you .05 of a second but start putting any load on MYsql and its performance drops fast.

                              Spped under load is what you want and thats what MYsql isn't good at.

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...
                              X