[UPHPU] Database Dilemma... Please help.

[Robert Oldham]

On Thu, 2006-04-06 at 12:07 -0600, Jason Jones wrote:

> Can anyone here point me to something, somewhere that gives numbers on any
> OSS datbase handling that amount of data and maintaining good numbers on
> speed, with possible hints as to its configuration?


I have managed MS SQL, MySQL , and PostgreSQL for years.  I have managed
them with hundreds of millions of rows.  You can make any one of them
work with hundreds of millions of rows just fine.  Configuration isn't
difficult and there are many online resources.  I would suggest that if
you plan to stick with MySQL, that you run it on Linux, not Windows, for
best performance.

In my experience, the single largest factor for speed in large databases
is memory.  Different databases have different memory requirements.  Be
sure you know what those are.

Robert