RE: Which database?

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

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