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]
Brad Teale wrote:
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
much of a performance hit would we take with
MySQL if we connected through MyODBC?
Thanks again,
Brad
-Original Message-
From: walt [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 11:47 AM
To: Brad Teale
Cc: '[EMAIL PROTECTED]'
Subject: Re: Real-time data warehousing
Brad,
We're
On Friday 17 May 2002 12:58 pm, Brad Teale wrote:
I forgot to mention, we have Oracle in-house, and the machine the MySQL
database will reside on is a 2 proc Sun box with 1.5G of RAM. The Oracle
databases reside on a 16 proc Sun box with 10G of RAM.
snip
How are your apps written? We use
: Friday, May 17, 2002 12:27 PM
To: Brad Teale
Cc: '[EMAIL PROTECTED]'
Subject: Re: Real-time data warehousing
How are your apps written? We use OTL libaries from
http://members.fortunecity.com/skuchin/home.htm
which are compiled into our C/C++ code. Moving our apps from oracle to mysql
only requires
In the last episode (May 17), Brad Teale said:
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