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
]
[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
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