Re: MySQL versus Oracle

Jeremy,

The issue is not with Crystal reports per se, ( though it is at the shallow end of the gene pool as far as reporting tools go ), but with allowing users to run ad hoc reports from a production database.

It's just not a good idea. All it takes is one query by one user missing a join, and the performance hit will be measurable.

Get a 2 or 3 of them doing it, and you won't need to measure it, other users will start complaining.

Better to turn them loose on a database created just for reporting.

I've done that with a couple of systems here. It is *not* a DW, just replicated tables. If an errant report starts causing problems in the reporting database, it is a much less critical ( and less noticable to management ) problem than bringin an ERP system to it's knees.

Jared

On Friday 31 May 2002 17:38, Jeremy Bainbridge-Smith wrote:
> -----Original Message-----
> Sent: Saturday, 1 June 2002 11:00 AM
> To: Multiple recipients of list ORACLE-L
>
> snip
>
> This is to satisfy some reporting requirements for users of
> these systems ( I do *NOT* turn these folks loose on my
> production SAP with Crystal reports! )
>
> snip
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
> Just to change the direction of this thead a little.
>
> Jared I curious about your remark above. What issues do you have with
> Crystal? Load on the server? Security? I'm just wondering if I am ignorant
> of matters that need consideration when using Crystal.
>
> Cheers
> Jeremy
>
> ~~~~~~~~~~~~~~~~~~~~~~~~
> Jeremy Bainbridge-Smith
> Database Administrator
> Hamilton City Council
>
> Ph +64 7 838 6428
> Mob +64 021 894481
> ~~~~~~~~~~~~~~~~~~~~~~~~

Content-Type: text/html; charset="iso-8859-1"; name="Attachment: 1"
Content-Transfer-Encoding: quoted-printable
Content-Description: 
----------------------------------------

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).