Well Said Sara.

----- Original Message -----
From: "Sara Burns" <[EMAIL PROTECTED]>
Sent: Wednesday, March 31, 2004 1:57 PM
Subject: RE: Modern Universe (TESTING)

> As requested
> My queries were done on our machine reasonably early in the morning before
> there were a lot of users.  I repeated them to ensure that data was in
> cache.
> Both had the same format
> SELECT CustomerNo
>   FROM CustomerFile
>   WHERE PostalAddLine1 like '%EXPLORATION%'
>   ORDER BY CustomerName
> I will admit that I was surprised at the performance when we set up the
> index in UniVerse on that field.  It showed me the value of using indexes.
> Before indexes were available in UniVerse this was done by different
> This type of select would not have been considered.  I think this is a big
> difference between Oracle and UniVerse.  As these features have become
> available in UniVerse etc some leap at the chance to use them and others
> keep doing things the old way.  Sometimes they may have been bitten by odd
> bugs in the past.  UniVerse has most of the latest features if we choose
> use them.  This CustomerFile has 14 indexes.
> I cannot repeat the tests now as the machine is heavily loaded and will be
> until late this evening.  However I did try again just to convince myself
> and got the same relativity.  Maybe we need to tune Oracle better for this
> query
> One possible difference is that this query is directly to the database
> our UniVerse application, not via an intermediate layer.
> AIX 5.2, UniVerse 10.0.11, Oracle 9.0.2
> I think we should leave this discussion now.  Maybe it is time for
> experimentation - I have found you can get great improvements with the
> approach.
> Sara Burns (SEB)
> Development Team Leader
> Public Trust
> Phone: +64 (04) 474-3841 (DDI)
> Mobile: 027 457 5974
> < <mailto:[EMAIL PROTECTED]>
> Information contained in this communication is confidential. If you are
> the intended recipient the information should not be used, disclosed,
> or commercialised. The information is not necessarily the views nor the
> official communication of Public Trust. No guarantee or representation is
> made that the communication is free of errors, virus or interference.
> --
> u2-users mailing list
> http://www.oliver.com/mailman/listinfo/u2-users

u2-users mailing list

Reply via email to