Re: how good is PHP-PostgreSQL???

Arnold Gamboa wrote: > > Hi, > > For users of large PostgreSQL and PostgreSQL builders, this is for you. > > I'm having a terrible time deciding now. :( > > We're about to build a "huge" website now. I got tied up in signing the > contract without really getting enough information about PgSQL since this > what we plan to implement with PHP (normally we use mySQL but i guess it > does not fit for huge databases like that). > > Here's my problem.. We're about to build a site like hitbox.com where there > is a large amount of database required.. If say there is 100,000 users with > 1000 page hits per day for each, and everything will be logged, you could > imagine how huge this will be. I'm just so "nervous" (really, that's the > term) if we implement this and later on experience a slow down or worse than > that, crash in the server. > > My questions are: > 1. What is the limit for number of records in a table WITHOUT SUFFERING SLOW > DOWN. > 2. ....limit in number of tables per database > 3. ... limit in number of database. > > Thanks for you comments. I would really appreciate every comment that I'll > receive regarding this. > > Arnold > Arnold, I wouldn't recommend postgres for this. Mysql is a much better databse for reading but experiences problems when thatre are a lot of write transaction to be done to be done. Having said that mysql doesn't come with the rollback. It is where if part of a transaction fails, all of the transaction is reveresed to the point where you stared the transaction. I havn't used a commercial databse such as Oracle or IBM DB2 or some others... -- george@laopdr.com Network Administrator Planet Online Vientiane, Lao PDR