Register

If this is your first visit, please click the Sign Up now button to begin the process of creating your account so you can begin posting on our forums! The Sign Up process will only take up about a minute of two of your time.

Results 1 to 3 of 3
  1. #1
    Senior Member GeZe's Avatar
    Join Date
    Dec 2003
    Posts
    330
    Member #
    4381
    MySQL vs. PostrgeSQL

    Which is better if I have a DB with several million rows and it is used commercially?
    -GeZe

  2.  

  3. #2
    Senior Member glyakk's Avatar
    Join Date
    Nov 2003
    Location
    USA
    Posts
    1,263
    Member #
    3828
    Liked
    6 times
    Either would work fine, but as a general rule if I were going mostly for speed I pick mySQL but If I wanted more flexability I would go with Postgre. But judging from the simple fact you are asking this question, I am assuming you probably have not outgrown mySQL's capabilites, so I would reccomend mySQL. Its easier to use, and is known for its speed. But you might run into problems when you run an exessive amount of queries at once or have many multiple connections at once.


  4. #3
    Senior Member Brak's Avatar
    Join Date
    Apr 2003
    Location
    San Francisco, CA
    Posts
    3,413
    Member #
    1217
    Liked
    2 times
    Depends on your uses for the millions of rows.

    mySQL works far better at very simple inserts and tracking of insane amounts of rows. At least, it did when tracking bullets in a CS tracking system I helped with a while ago.
    Kyle Neath: Rockstar extraordinare
    The blog | The poetry site | The Spore site


Remove Ads

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
All times are GMT -6. The time now is 11:14 PM.
Powered by vBulletin® Version 4.2.3
Copyright © 2019 vBulletin Solutions, Inc. All rights reserved.
vBulletin Skin By: PurevB.com