| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Purely for your amusement
Beware of the Beast, aka "Axis", aka "MS Access". Yesterday a user called
to have his Axis query killed because it had been running 10 minutes when it
should only take about a second. After snooping the SQL, Axis was sending
separate SQL statements for each table (in two different sessions), and was
running these for each row in one of his local Axis tables that the query
was joined to. I asked him to move the 20 rows of his Axis table to the
criteria part of the Oracle column it was joined to and it returned
subsecond. And the query looked about as good as could be expected from
Axis.
Evil, evil, evil. Axis of Evil.
Rich
Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
-----Original Message-----
Sent: Friday, February 28, 2003 8:19 AM
To: Multiple recipients of list ORACLE-L
Precisely.
In our environment, great care is taken with
adding/modifying data. But when it comes to
reporting, there's no standardization of products or
concern about what's being reported. The DBA's find
out about a bad query when it hits the "this sql
really sucks" list (or when the whining starts).
You'd think damagement would learn. It's more than just concerns about performance issues. Wouldn't you think damagement would care about the accuracy of data being reported??
I'm really starting to warm up to the configurable
version of the sending rasberries product.
When is that going to be available??
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jesse, Rich
INET: Rich.Jesse_at_qtiworld.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services ---------------------------------------------------------------------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). Received on Fri Feb 28 2003 - 08:48:43 CST
 |
 |