Re: Real-time data warehousing

2002-05-17 Thread Dan Nelson
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

RE: Real-time data warehousing

2002-05-17 Thread Brad Teale
: 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 onl

Re: Real-time data warehousing

2002-05-17 Thread walt
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. How are your apps written? We use OTL

RE: Real-time data warehousing

2002-05-17 Thread Brad Teale
, how 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

Re: Real-time data warehousing

2002-05-17 Thread walt
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 d

Re: Real-time data warehousing

2002-05-17 Thread Gelu Gogancea
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]