Wild Card/Generic retrieval

Thu, 11 Sep 2003 09:12:03 -0400

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.

------_=_NextPart_001_01C37866.4ADD72D0
Content-Type: text/plain

Thanks Darren. This has been quite educational IMHO.

Bob

-----Original Message-----
From: Darren Reely [mailto:darren.reely@latticesemi.com]
Sent: Wednesday, September 10, 2003 4:57 PM
To: Deskin, Bob
Cc: 'Edis, Robert'; Powerh-L (E-mail)
Subject: Re: Wild Card/Generic retrieval

That cursor example is what I did not include, but mentioned. The time 
was 2 minutes 47 seconds. I just reran the test and got 2 minutes 36 
seconds. I did find this a surprising result. After all, you'd expect 
the query to filter out rows that the other tests have to go through.

Understanding that Quiz is doing a little more work I tried to sway 
Oracle to do the same via my subselect example. Somehow Oracle 'saw' 
through that, or worked much more efficiently at its low levels. Quiz on 
the other hand still fetches real data from Oracle before applying the 
SELECT, taking up crucial time. Oh, and Quiz is placing that fetched 
data somewhere else also.

Here is a new faster version of the cursor sample. It takes 10 seconds.

   set report nolimit
   sql in mfg declare lss cursor for select lot_id from lot_step_summ 
where lot_id like '%A'
   access lss
   define mycount  num = 1
   final footing mycount subtotal

This suggests that when fetching data, you should only fetch what you 
need, not everything, as the SELECT * does. Temporary Quiz storage 
concerns are not being taxed as much in this new example.

My testing was a simple curiosity experiment. Real reporting could alter 
the results somewhat. Still, I know to avoid MATCHPATTERN, and SELECT * 
when not required.

Darren

Deskin, Bob wrote:

> Well, QUIZ is retrieving each individual row from the database and 
> then applying the selection. The SQL is letting the database do all of 
> the selection before returning anything.
>  
> How about trying this:
>  
> declare x cursor for select select * from lot_step_summ where lot_id 
> like '%A'
> access x
> define mycount  num = 1
> final footing mycount subtotal
> go
>  
> or something similar.
>  
> Bob
>
>     -----Original Message-----
>     From: Edis, Robert [mailto:REdis@Blistex.com]
>     Sent: Wednesday, September 10, 2003 3:37 PM
>     To: Powerh-L (E-mail)
>     Subject: RE: Wild Card/Generic retrieval
>
>     What IS an issue is 4 sec. for SQL vs. 53 sec for Quiz.  Why is
>     Quiz so slow?
>
>         -----Original Message-----
>         From: Deskin, Bob [mailto:Bob.Deskin@cognos.com]
>         Sent: Wednesday, September 10, 2003 2:25 PM
>         To: 'Darren Reely'
>         Cc: powerh-l@lists.swau.edu
>         Subject: RE: Wild Card/Generic retrieval
>
>         Thanks Darren for confirming that pattern matching is still
>         quite resource intensive relative to the other PowerHouse
>         functions. While we can't say exactly how much more intensive
>         without testing various volumes, I'm not surprised at these
>         results. What is interesting is how close the other function
>         tests are.
>
>         Bob
>
>         -----Original Message-----
>         From: Darren Reely [mailto:darren.reely@latticesemi.com]
>         Sent: Wednesday, September 10, 2003 2:57 PM
>         Cc: powerh-l@lists.swau.edu
>         Subject: Re: Wild Card/Generic retrieval
>
>
>         I found this interesting enough to 'play' a little with it. I
>         choose the
>         main table in our Oracle test system containing 1,482,455
>         rows.  I
>         altered the queries for my known data and limited them to
>         counting.
>
>         In this scenario it is obvious to avoid MATCHPATTERN. I've
>         never been
>         impressed with its performance. Most of the options proposed
>         came in at
>         around 53 seconds, MATHCPATTERN added 2 minutes to those times!
>
>         Not listed here is a combination of the Oracle SQL select as a
>         cursor
>         for a new version of the quiz file. It took 2 minutes 47 seconds.
>
>         At the end of each select statement are the timings.
>
>         Oracle SQL - approximately 4 seconds
>
>         select count(*)
>         from lot_step_summ
>         where lot_id like '%A';
>
>         OR
>
>         select count(*)
>         from (select * from lot_step_summ where lot_id like '%A');
>
>
>           COUNT(*)
>         ----------
>             145878
>
>
>         Powerhouse times
>
>         set report nolimit
>         access lot_step_summ in mfg
>         ;select lot_step_summ if MATCHPATTERN(TRUNCATE(lot_id),"@A") 
>         ;; 2
>         minutes 53 seconds
>         ;select lot_step_summ If 0 = index(lot_id,"A") -
>         size(truncate(lot_id))
>           ;; 53 seconds fetches too many records, no surprise
>         ;select lot_step_summ if 'A' = REVERSE(TRUNCATE( lot_id
>         ))[1:1]  ;; 53
>         seconds
>         select if "A" = lot_id[ SIZE(TRUNCATE(lot_id)) :
>         1]                           ;; 56 seconds
>         define mycount  num = 1
>         final footing mycount subtotal
>         go
>
>         09/10/2003                           
>         mfg                             
>         PAGE   1
>
>            MYCOUNT
>           (SUBTOTAL)
>
>             145878
>
>
>         Darren
>
>
>         = = = = = = = = = = = = = = = = = = = = = = = = = = = =
>         Mailing list: powerh-l@lists.swau.edu
>         Subscribe: "subscribe" in message body to
>         powerh-l-request@lists.swau.edu
>         Unsubscribe: "unsubscribe <password>" in message body to
>         powerh-l-request@lists.swau.edu
>         http://lists.swau.edu/mailman/listinfo/powerh-l
>         This list is closed, thus to post to the list you must be a
>         subscriber.
>
>         Join us at Cognos' biggest event of the year Enterprise 2003,
>         The Cognos Business Forum.  Taking place in over 25 cities
>         around the world, it's an opportunity for Business and IT
>         leaders to learn about strategies for driving performance.
>         Visit http://www.cognos.com/enterprise03 for more details.
>
>         This message may contain privileged and/or confidential
>         information.  If you have received this e-mail in error or are
>         not the intended recipient, you may not use, copy, disseminate
>         or distribute it; do not open any attachments, delete it
>         immediately from your system and notify the sender promptly by
>         e-mail that you have done so.  Thank you.
>
>
> Join us at Cognos' biggest event of the year Enterprise 2003, The 
> Cognos Business Forum. Taking place in over 25 cities around the 
> world, it's an opportunity for Business and IT leaders to learn about 
> strategies for driving performance. Visit 
> http://www.cognos.com/enterprise03 for more details.
>
>
> This message may contain privileged and/or confidential information. 
> If you have received this e-mail in error or are not the intended 
> recipient, you may not use, copy, disseminate or distribute it; do not 
> open any attachments, delete it immediately from your system and 
> notify the sender promptly by e-mail that you have done so. Thank you.
>

Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum.  Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details. 

This message may contain privileged and/or confidential information.  If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so.  Thank you.

------_=_NextPart_001_01C37866.4ADD72D0
Content-Type: text/html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2654.89">
<TITLE>RE: Wild Card/Generic retrieval</TITLE>
</HEAD>
<BODY>

Thanks Darren. This has been quite educational IMHO.

<P><FONT SIZE=2>Bob</FONT>
</P>

<P><FONT SIZE=2>-----Original Message-----</FONT>
<BR><FONT SIZE=2>From: Darren Reely [<A HREF="mailto:darren.reely@latticesemi.com">mailto:darren.reely@latticesemi.com</A>]</FONT>
<BR><FONT SIZE=2>Sent: Wednesday, September 10, 2003 4:57 PM</FONT>
<BR><FONT SIZE=2>To: Deskin, Bob</FONT>
<BR><FONT SIZE=2>Cc: 'Edis, Robert'; Powerh-L (E-mail)</FONT>
<BR><FONT SIZE=2>Subject: Re: Wild Card/Generic retrieval</FONT>
</P>
<BR>

That cursor example is what I did not include, but mentioned. The time 
 was 2 minutes 47 seconds. I just reran the test and got 2 minutes 36 
 seconds. I did find this a surprising result. After all, you'd expect 
 the query to filter out rows that the other tests have to go through.

Understanding that Quiz is doing a little more work I tried to sway 
 Oracle to do the same via my subselect example. Somehow Oracle 'saw' 
 through that, or worked much more efficiently at its low levels. Quiz on 
 the other hand still fetches real data from Oracle before applying the 
 SELECT, taking up crucial time. Oh, and Quiz is placing that fetched 
 data somewhere else also.

Here is a new faster version of the cursor sample. It takes 10 seconds.

<P><FONT SIZE=2>&nbsp;&nbsp; set report nolimit</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; sql in mfg declare lss cursor for select lot_id from lot_step_summ </FONT>
<BR><FONT SIZE=2>where lot_id like '%A'</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; access lss</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; define mycount&nbsp; num = 1</FONT>
<BR><FONT SIZE=2>&nbsp;&nbsp; final footing mycount subtotal</FONT>
</P>

This suggests that when fetching data, you should only fetch what you 
 need, not everything, as the SELECT * does. Temporary Quiz storage 
 concerns are not being taxed as much in this new example.

My testing was a simple curiosity experiment. Real reporting could alter 
 the results somewhat. Still, I know to avoid MATCHPATTERN, and SELECT * 
 when not required.

<P><FONT SIZE=2>Darren</FONT>
</P>
<BR>

<P><FONT SIZE=2>Deskin, Bob wrote:</FONT>
</P>

&gt; Well, QUIZ is retrieving each individual row from the database and 
 &gt; then applying the selection. The SQL is letting the database do all of 
 &gt; the selection before returning anything.
 &gt;&nbsp; 
 &gt; How about trying this:
 &gt;&nbsp; 
 &gt; declare x cursor for select select * from lot_step_summ where lot_id 
 &gt; like '%A'
 &gt; access x
 &gt; define mycount&nbsp; num = 1
 &gt; final footing mycount subtotal
 &gt; go
 &gt;&nbsp; 
 &gt; or something similar.
 &gt;&nbsp; 
 &gt; Bob
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; -----Original Message-----
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; From: Edis, Robert [<A HREF="mailto:REdis@Blistex.com">mailto:REdis@Blistex.com</A>]
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; Sent: Wednesday, September 10, 2003 3:37 PM
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; To: Powerh-L (E-mail)
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; Subject: RE: Wild Card/Generic retrieval
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; What IS an issue is 4 sec. for SQL vs. 53 sec for Quiz.&nbsp; Why is
 &gt;&nbsp;&nbsp;&nbsp;&nbsp; Quiz so slow?
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----Original Message-----
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From: Deskin, Bob [<A HREF="mailto:Bob.Deskin@cognos.com">mailto:Bob.Deskin@cognos.com</A>]
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sent: Wednesday, September 10, 2003 2:25 PM
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; To: 'Darren Reely'
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cc: powerh-l@lists.swau.edu
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Subject: RE: Wild Card/Generic retrieval
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Thanks Darren for confirming that pattern matching is still
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; quite resource intensive relative to the other PowerHouse
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; functions. While we can't say exactly how much more intensive
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; without testing various volumes, I'm not surprised at these
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; results. What is interesting is how close the other function
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; tests are.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Bob
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; -----Original Message-----
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; From: Darren Reely [<A HREF="mailto:darren.reely@latticesemi.com">mailto:darren.reely@latticesemi.com</A>]
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Sent: Wednesday, September 10, 2003 2:57 PM
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Cc: powerh-l@lists.swau.edu
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Subject: Re: Wild Card/Generic retrieval
 &gt;
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I found this interesting enough to 'play' a little with it. I
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; choose the
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; main table in our Oracle test system containing 1,482,455
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; rows.&nbsp; I
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; altered the queries for my known data and limited them to
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; counting.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; In this scenario it is obvious to avoid MATCHPATTERN. I've
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; never been
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; impressed with its performance. Most of the options proposed
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; came in at
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; around 53 seconds, MATHCPATTERN added 2 minutes to those times!
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Not listed here is a combination of the Oracle SQL select as a
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; cursor
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; for a new version of the quiz file. It took 2 minutes 47 seconds.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; At the end of each select statement are the timings.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Oracle SQL - approximately 4 seconds
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select count(*)
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from lot_step_summ
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; where lot_id like '%A';
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; OR
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select count(*)
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; from (select * from lot_step_summ where lot_id like '%A');
 &gt;
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; COUNT(*)
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ----------
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 145878
 &gt;
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Powerhouse times
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; set report nolimit
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; access lot_step_summ in mfg
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;select lot_step_summ if MATCHPATTERN(TRUNCATE(lot_id),&quot;@A&quot;) 
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;; 2
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; minutes 53 seconds
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;select lot_step_summ If 0 = index(lot_id,&quot;A&quot;) -
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; size(truncate(lot_id))
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;; 53 seconds fetches too many records, no surprise
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;select lot_step_summ if 'A' = REVERSE(TRUNCATE( lot_id
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ))[1:1]&nbsp; ;; 53
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; seconds
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; select if &quot;A&quot; = lot_id[ SIZE(TRUNCATE(lot_id)) :
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1]&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ;; 56 seconds
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; define mycount&nbsp; num = 1
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; final footing mycount subtotal
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; go
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 09/10/2003&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mfg&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PAGE&nbsp;&nbsp; 1
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; MYCOUNT
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; (SUBTOTAL)
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 145878
 &gt;
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Darren
 &gt;
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; = = = = = = = = = = = = = = = = = = = = = = = = = = = =
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Mailing list: powerh-l@lists.swau.edu
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Subscribe: &quot;subscribe&quot; in message body to
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; powerh-l-request@lists.swau.edu
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; powerh-l-request@lists.swau.edu
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <A HREF="http://lists.swau.edu/mailman/listinfo/powerh-l" TARGET="_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A>
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This list is closed, thus to post to the list you must be a
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; subscriber.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Join us at Cognos' biggest event of the year Enterprise 2003,
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; The Cognos Business Forum.&nbsp; Taking place in over 25 cities
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; around the world, it's an opportunity for Business and IT
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; leaders to learn about strategies for driving performance.
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Visit <A HREF="http://www.cognos.com/enterprise03" TARGET="_blank">http://www.cognos.com/enterprise03</A> for more details.
 &gt;
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; This message may contain privileged and/or confidential
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; information.&nbsp; If you have received this e-mail in error or are
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; not the intended recipient, you may not use, copy, disseminate
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; or distribute it; do not open any attachments, delete it
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; immediately from your system and notify the sender promptly by
 &gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e-mail that you have done so.&nbsp; Thank you.
 &gt;
 &gt;
 &gt; Join us at Cognos' biggest event of the year Enterprise 2003, The 
 &gt; Cognos Business Forum. Taking place in over 25 cities around the 
 &gt; world, it's an opportunity for Business and IT leaders to learn about 
 &gt; strategies for driving performance. Visit 
 &gt; <A HREF="http://www.cognos.com/enterprise03" TARGET="_blank">http://www.cognos.com/enterprise03</A> for more details.
 &gt;
 &gt;
 &gt; This message may contain privileged and/or confidential information. 
 &gt; If you have received this e-mail in error or are not the intended 
 &gt; recipient, you may not use, copy, disseminate or distribute it; do not 
 &gt; open any attachments, delete it immediately from your system and 
 &gt; notify the sender promptly by e-mail that you have done so. Thank you.
 &gt;

Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos Business Forum.&nbsp; Taking place in over 25 cities around the world, it's an opportunity for Business and IT leaders to learn about strategies for driving performance. Visit <A HREF="http://www.cognos.com/enterprise03" TARGET="_blank">http://www.cognos.com/enterprise03</A> for more details.

<P><FONT SIZE=2>This message may contain privileged and/or confidential information.&nbsp; If you have received this e-mail in error or are not the intended recipient, you may not use, copy, disseminate or distribute it; do not open any attachments, delete it immediately from your system and notify the sender promptly by e-mail that you have done so.&nbsp; Thank you.</FONT></P>

</BODY>
</HTML>
------_=_NextPart_001_01C37866.4ADD72D0--