Beefy Boxes and Bandwidth Generously Provided by pair Networks
Perl Monk, Perl Meditation

Re: Re: MySQL vs SQL2000

by true (Pilgrim)
on Oct 22, 2002 at 05:06 UTC ( #206982=note: print w/replies, xml ) Need Help??

in reply to Re: MySQL vs SQL2000
in thread MySQL vs SQL2000

perfect. crash-me has some solid numbers without the sales jargon. thanks tons.
PostgreSQL looks very very impressive.
This Page claims native Windows compatibility will be introduced with PostgreSQL 7.4.
MSSQL Server seemed to support a larger character structure and db size than regular MySQL.
crash-me comparison claimed the following:
  • MSServer supports 1000 simultaneous connections
  • PostgreSQL supported 32 simultaneous connections
  • MySQL supported 101 simultaneous connections
  • Replies are listed 'Best First'.
    Re: Re: Re: MySQL vs SQL2000
    by alfie (Pilgrim) on Oct 22, 2002 at 07:28 UTC
      About the simultaneous connections: You must also keep in mind that these are the default installation values, that doesn't mean that PostgreSQL doesn't support more that 32 simultaneous connections, you just have to tweak the configuration file to make it possible. To me that output is just useless data, it doesn't speak about maximum values and/or scalability at all....
      use signature; signature(" So long\nAlfie");

        To further expand on alfie - PostgreSQL's connection limit can be upped arbitrarily but that's limited by the amount operating system's shared memory. When I install PostgreSQL on OpenBSD I have to make a tweak to the kernel to up the maximum limit. This is all documented so it's nothing to worry about but it would be misleading to simply look at PostgreSQL's arbitrary 32 connection limit and ignore the OS's less but still arbitrary limit.

        __SIG__ printf "You are here %08x\n", unpack "L!", unpack "P4", pack "L!", B::svref_2object(sub{})->OUTSIDE;
    Re: Re: Re: MySQL vs SQL2000
    by true (Pilgrim) on Oct 22, 2002 at 19:50 UTC
      If anyone has upped the limit with PostgreSQL, please indicate how many simultaneous connections they were able to add. I know this will vary from OS architecture, but a rough figure would help. The speed of the query is also very important. That will drastically effect performance and tweek the simultaneous connections summary as well. According to crash-me, MySQL offers blazing SELECT query speed for example.

    Log In?

    What's my password?
    Create A New User
    Domain Nodelet?
    Node Status?
    node history
    Node Type: note [id://206982]
    and the web crawler heard nothing...

    How do I use this? | Other CB clients
    Other Users?
    Others musing on the Monastery: (4)
    As of 2022-05-19 05:59 GMT
    Find Nodes?
      Voting Booth?
      Do you prefer to work remotely?

      Results (71 votes). Check out past polls.