Hi,
My opinion:
If your DataBase is designed for OLTP then MySQL ver 3.23.4x with MyISAM
can be a good choice and safety.
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Brad Teale" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 17, 2002 6:49 PM
Subject: Real-time data warehousing
> We are warehousing real-time data. The data is received at up to T1
speeds,
> and is broken up and stored into the database in approximately 25
different
> tables. Currently MySQL is doing terrific, we are using MyISAM tables and
> are storing 24 hours worth of data but we don't have any users and we need
> to store 72 hours worth of data.
>
> Our concern is that when we start letting our users (up to 200
simultaneous)
> hit the database, we won't be able to keep up with ingesting and serving
> data with the MyISAM locking scheme.
>
> We have tested Oracle and PostgreSQL which fell behind on the ingest. The
> current production system uses regular ISAM files, but we need to make a
> certification which requires a relational database. Also, the current
> production system doesn't have the feature list the new system has.
>
> Is there a better database solution or do you think MySQL can handle it?
> If MySQL can handle it, would we be better off using InnoDB or MyISAM
> tables?
>
> Thanks,
> Brad
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
