Re: Equivalent products to SQR?

["Manning, Shinta" <ShintaManning@FINANCIAL.WELLSFARGO.COM>]

I think it all depends what kinds of things you do with it and the amount of
data coming across it.  I ran a report that took over-night to run
(approximately 14 hours).  I'm sure both PERL and SQR has advantages over
each other...

> -----Original Message-----
> From: Steve Gill [SMTP:Steve@CAWS.DEMON.CO.UK]
> Sent: Tuesday, October 10, 2000 11:04 AM
> To:   SQR-USERS@list.iex.net
> Subject:      Re: Equivalent products to SQR?
>
> I'm presuming you meant you could DECREASE the time a report took;-)
>
> From the tests I've done SQR is exceptionally good with all kinds of
> database manipulation. In tests run at a client site it even beat IBM
> utilities at inserting or updating rows in DB2.
>
> ---
> Steve Gill
> Steve@caws.demon.co.uk
> http://www.caws.demon.co.uk/
>
> > -----Original Message-----
> > From: Discussion of SQR, Brio Technology's database reporting language
> > [mailto:SQR-USERS@list.iex.net]On Behalf Of John Milardovic
> > Sent: 10 October 2000 15:13
> > To: SQR-USERS@list.iex.net
> > Subject: Re: Equivalent products to SQR?
> >
> >
> > I would second that suggestion.  I recently created 5
> > operational reports in
> > perl and it was a snap.  I also benchmarked a perl report against an
> > identical SQR report (see attachment).   I found also that I could
> > DRASTICALLY increase the time that perl reports took if I
> > scrapped joins and
> > instead joined the rows programmatically (one report went from
> > 2-3 minutes
> > to about 30 seconds - although perhaps better indexing of the tables and
> > better use of existing indexes would have worked also).
> >
> >
> >  <<Perl vs SQR Benchmarking.doc>>
> >
> > HTH
> > John Milardovic
> >
> > > -----Original Message-----
> > > From: cshelton [SMTP:cshelton@INDIANA.EDU]
> > > Sent: Monday, October 09, 2000 10:34 AM
> > > To:   SQR-USERS@list.iex.net
> > > Subject:      Re: Equivalent products to SQR?
> > >
> > > I'd suggest looking at perl.  I've been working with both sqr
> > and perl for
> > > about 4 years now. Even though perl might have a slightly
> > steeper learning
> > > curve than sqr, it can do everything that I know that sqr can do and a
> > > whole lot more.
> > >
> > > Try starting at www.perl.com and www.perl.org for researching
> > perl.  In my
> > > experience, support for perl is significantly better than with sqr,
> > > especially if you are able to search on the net for answers.
> > >
> > > The two biggest issues that I see in favor of perl over sqr
> > are total cost
> > > of ownership and control of software.  For the cost of one
> > SQR license,
> > > you can buy quite a library of perl books, as well as attend training
> > > sessions or even bring in an on-site firm to train people in
> > perl.  Since
> > > perl is open source software, you don't have to pay any
> > organization for
> > > the right to use it.
> > >
> > > Eric Scott Raymond described the control issue well, in his
> > recent talks
> > > about this issue:
> > >
> > > "An executive who allows his company to becomes dependent on
> > software he
> > > is not allowed to see inside, let alone change, has lost
> > control of his
> > > business, and is on the wrong side of a monopoly relationship with a
> > > vendor who can thereby control his business. With open source, the
> > > executive is in control, and nobody can take that away. "
> > >         - Eric Scott Raymond, "Meme Hacking for Fun and Profit"
> > >
> > > Chris Shelton
> > >
> > > On Mon, 9 Oct 2000, Chris Gin wrote:
> > >
> > > > Hi,
> > > >
> > > > We have been forced into looking at replacing SQR due to
> > the change in
> > > the
> > > > licencing structure by Brio. Currently we run SQR on Unix and we're
> > > looking
> > > > at migrating to an NT environment.
> > > >
> > > > Are there any products out there that even come close to
> > SQR in terms of
> > > > functionality?
> > > >
> > > > The reason we're looking at using something else is because
> > we're told
> > > that
> > > > the cost of a user licence is now based on the power of the
> > machine it's
> > > > running on. For us, this means an increase of 1000% which
> > is ridiculous.
> > > >
> > > > Thanks,
> > > > Chris
> > > >
> > > >
> >