Re: Which database?

["Alan Levin" <alan at futureperfect.co.za>]

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.

They currently use Solid (by Solidtech) which is one that I have always been
interested in because of its very small footprint and consequent speed (and
reasonable cost coming from Finland). It performs well for them but they now
have needs for multi-threading. Their current tests indicate that mySQL
should perform as good as PostGreSQL or Oracle.

My personal recommendation is to stick with mySQL, it has served me very
well over a number of years and saved tens of thousands of dollars in
licensing fees.

hope this helps,

Alan


_______________________________
       Alan Levin
       Future Perfect Corporation
       http://www.futureperfect.co.za/
       tel: +27 21 4097025


----- Original Message -----
From: "Eric Stevance" <stevance at afribone.net.ml>
To: <William at zanet.co.za>
Cc: <afnog at afnog.org>
Sent: Wednesday, October 03, 2001 10:35 AM
Subject: RE: Which database?


> Hi William,
>
> Thank you for your message!
>
> I want to be able to run the database on either Linux or FreeBSD.
>
> As I told the database will have around 6 millions lines, the simultaneous
> request, difficult for me to know, for sure there will. What do you mean
by
> MANY, any figures?
>
> Choosing Informix, Oracle or Sybase, the cost might be very important
> mainly for the tool for developpment right?
>
> I will check more MS SQL also.
>
> Thank you for any further information.
>
> Thank you,
>
> Eric
>
>
> >You could use any "Enterprise Class" database, i.e. not MS Access,
FoxPro,
> >Delphi, etc.
> >
> >mySQL or MS SQL would work fine, depending on which operating system you
> >intend to run it on. You could use Informix, Oracle or Sybase, but they
> >shouldn't be necessary unless you're looking for MANY simultaneous
> >accesses - even then MS SQL will keep up in almost all cases, at a far
lower
> >price than Informix, for example. I don't have enough figures on the
> >performance of mySQL to answer the question, but my impression is that
it's
> >at the "lower end" of the Enterprise class DBs. I could be wrong, and no
> >doubt someone will flame me ;-)
> >
> >The answer doesn't just depend on which DB you use. It depends on the
> >platform, application, activity volume and price you're willing to pay.
> >
> >
> >Regards,
> >
> >William Stucke
> >ZAnet Internet Services (Pty) Ltd
> >mailto:William at zanet.co.za
> >+27 11 465-0700
> >ISOC-ZA Chairman
> >mailto:Chair at isoc.org.za
> >
> >
> >-----Original Message-----
> >From: owner-afnog at uol.co.ug [mailto:owner-afnog at uol.co.ug]On Behalf Of
> >Eric Stevance
> >Sent: 2001/10/02 18:23
> >To: afnog at afnog.org
> >Subject: Which database?
> >
> >
> >Hello everybody,
> >
> >I need to find a suitable database for a web server, that could manage up
> >to 6 millions lines.
> >
> >Which database would recommand?
> >
> >Currently I use Mysql, could it manage such number of records?
> >
> >
> >Thank you for any kind of information you could have.
> >
> >Eric
> >
> >
> >-----
> >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
> >
> >
> >---
> >
> >Checked by AVG anti-virus system (http://www.grisoft.com).
> >Version: 6.0.282 / Virus Database: 150 - Release Date: 25/09/2001
>
>
> -----
> 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