Re: [sqr-users] SQR vs. Stored Procedures in MS SQL 7 & 2K

[<geek.unlimited@mindspring.com>]

> I am wondering if there is anyone on the list
> who has experience with both 'conventional' 
> MSSQL stored procedures and SQR who would 
> comment on whether there are any inherent 
> performance drawbacks to using SQR. For
> example:

The drawbacks are what you've found.  A well 
written SQL will carry you to success.  With 
a poorly written one, SQR won't save you.

> If a complex stored proc were directly ported
> to SQR with no changes, would both run equally 
> fast?

Yes.  When writing new SQR you can reliable build
and test the SQL for performance first and then
drop it into the SQR.

> Does SQR somehow make it easier for developers
> to write poorly performing SQL? 

I see why you'd ask that, but it is too sweeping
a question to answer with a definitive yes.  As 
long as you pay attention to what the SQR does to
your SQL, you'll be OK.

> Since SQR seems oriented more toward Oracle and
> other DBs, is it handled in an inefficient way 
> by MS SQL? 

I don't know enough about Oracle to address your
question, but SQR was written by Sybase, back 
when it and SQL Server were still the same 
product.

Andrew :)

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users