Hello,

I am looking for an advice on which database platform I should be looking into that will suit my needs:

  • up to 1 billion records of informations (first name, last name, address, city, state, zip, country, phone, etc). is this possible or do i have to break down into few tables?
  • fast interactions and queries between tables of significantly large size
  • online connectivity with php

I think mySQL might not be the choice for me (correct me if I am wrong), that's why I need help.

Thanks,
Renny

    well do you want to pay for a license database or a want to use free ones.

    You best bet would be to pay for a database that meets commerical production standards.

    PHP can connect to most of all the commerical large databases out there.

      You didn't mention parallel users.

      If you're handling 10 parallel users, ANY modern open source database would be a good choice. Interbase / Firebird is a nice small fast database that's easy to maintain.

      If you're going to handle 1000 users, you'd likely do better with Postgresql than MySQL.

      But you didn't mention parallel load so I don't know which to recommend. Oh, and Postgresql is 100% free, period, no matter how you use it.

        by the way, postgresql can compete on even footing against Oracle for all but the biggest of jobs, and even that is starting to change. And if you want to pay money for it, you're welcome to, but there's no licensing that would require it.

          I would agree with Sxooter, postgresql is a assume open source database to handle mid/large projects.

            Write a Reply...