Re: Which database?

[Eric Stevance <stevance at afribone.net.ml>]

Hello,

Thank you for all thoses messages...

Currently, I am using Mysql for different database, and one has more than 
500 000 records, it works fine.

But 6 millions might be different, it seems that the question is more about 
the simulataneous request, what would be the figures? The limits? Any ideas?

Calvin, would suggest any other database?

Eric



> >
> > Hi,
> >
> > I am no expert on the subject but have had a little experience......
> >
> > We were recently visiting the Brazilian Internet Steering committee where
> > they operate the .br tld (note that this includes almost 1m records and is
> > at least 7x the size of .co.za) . I was pleased to see that this is all 
> done
> > on a BSD machine. Clearly the database is of crucial importance to them.
>
>Ummm - .br have ~400 000 names, we have ~100 000 names,
>with our database consisting of 12 tables, with 2366348 records
>across those tables.(1)
>
>Postgres 7.0.3, on a Linux 2.2.17 smp kernel, 1 gig of ram,
>and 4x2meg 700mhz xeons....
>
>we need transactions, which we can not do with mySQL......
>
>--Calvin
>
>(1) as of my composing this email.
>
>------------------------* My opinions are mine *------------------------------
>  Calvin Browne calvin at UniForum.org.za c at lvin.co.za
>                Office phone: 080 314 0077        +27 11 314-0077
>                http://orange-tree.alt.za Mobile: +27 83 303-0663
>                Call me for Linux/Internet consulting
>------------------------------------------------------------------------------
>
>-----
>This is the afnog mailing list, managed by Majordomo 1.94.4
>
>To send a message to this list, e-mail afnog at afnog.org
>To send a request to majordomo, e-mail majordomo at afnog.org and put
>your request in the body of the message (i.e use "help" for help)
>
>This list is maintained by owner-afnog at afnog.org


-----
This is the afnog mailing list, managed by Majordomo 1.94.4

To send a message to this list, e-mail afnog at afnog.org
To send a request to majordomo, e-mail majordomo at afnog.org and put
your request in the body of the message (i.e use "help" for help)

This list is maintained by owner-afnog at afnog.org