"Steve Vernon" <[EMAIL PROTECTED]> wrote... :

> Hiya,
>     Just wondering what is the rough idea of speed of a server like this is
> holding a database with millions of records. I know its difficult, depends
> on the data stored etc.

Also rather the design and, whether do you really need to store it all in.

>     Its basically storing an index int and about 5 or so char field (50
> long). In total I want to store 500 million records. 

That makes no sense to me:

5 char field will be able to store up to:

107,820,390,375 unique char combinations

but in the real life - considering only 52 characters+10number you'd

916,132,832 unique combinations.

Now, if you would sacrifice case sensitivity and hold only upper-case
characters and numbers you would end up with: 


This is often the case for the usernames etc.

So, it makes very few sense counting on 500 Millions of records storing
only one 5c column. You should rethink the design first.

> Accessed using PHP.

Won't matter what you access it with.

>   a.. 2x Intel Pentium III 1260 CPU or higher

>   b.. 1 GB RAM
not enough for any kind of WHERE LIKE over 500mils

>   c.. 60 GB hard drive
might work... but might not

>   d.. 20 GB traffic/month
oh yes

>   e.. RedHat LInux 7.2

>     Ive read that its better to store the data in different databases on the
> same server?

Wrong. It is better to have one HTTP server and one optimized for the database.
Where did you hear that staff?

>     Can someone please give me a rough idea of the speed and how many
> servers needed, my client wants to know how much it will cost to host the
> site.

For 500 million records I would consider whether:

* 1 Oracle license one one dedicated server (HTTP on the separate
  machine, so servers in total). Full expense will probably be some

* 2 or 3 PostgreSQL machines load balanced and one HTTP server. Similar
  expense to above. (although Open Source, you'd have maintenance
  expenses and 2 more machines up)

* Paying a datacenter with an already optimized database and servers up
  and running on multiple servers. Something like $2.000 a month?

>      Anyone have any experience with holding a lot in MySQL? Any idea of
> speed would be great.

mySQL will never make it. Unless you spend bunch of money on good people
that can make it work. Don't go for mySQL in this case. I always had bad
experiences holding around one million of records with mySQL. PostgreSQL
worked well for me on 5-10 mils and Oracle works smoothly on 3.5
Terrabytes of data.


Maxim Maletsky

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to