[thelist] Which RDBMS?

[Oren Levin]

Wes,
Have you looked at pulling your transactional scheme database into a star
scheme reporting database? If you have an extensive reporting requirement it
may be worth the effort/resources to build a data warehouse and transform
your data.

Oren
-----
Oren Levin, Senior Developer
olevin at audible.com, 973.837.2811
www.audible.com - "Best Consumer Web Service" - CNet, April 2003


-----Original Message-----
From: thelist-bounces at lists.evolt.org
[mailto:thelist-bounces at lists.evolt.org] On Behalf Of Wes Reed
Sent: Friday, August 13, 2004 1:31 PM

At 08:02 AM 8/13/2004, you wrote:
>My own favorite is MySQL, and from my experience I know that very well 
>suffices for small systems like simple CMS etc. But what if I do bigger 
>things, where the volume is gigabytes? Or systems requiring transaction 
>safe tables and receiving hundreds of queries per second?

One area where we have found that MYSQL falls flat is in the area of 
complex queries needed for reporting.  The restrictions on subqueries have 
a big limitation for projects where extensive reporting is a requirement.