× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



I added the test to the IAAI forum and included the debug information.
There isn't a program; just a bunch of SQL statements (you will need to
provide your own data). I calculated the times from the joblog of each
job.

I did not clear objects from memory between runs.  In my environment it
doesn't really make sense; I don't care about the performance on the
first pass as much as I do the next 100 passes.

Jay Himes
Liberty University

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Joe Pluta
Sent: Friday, August 13, 2004 12:19 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL table joins: Join vs. Where

> From: Vern Hamberg
> 
> Jay, interesting results.
> 
> I am interested in the optimizer messages for each case. Just STRDBG
with
> no program name, then run the SQL.

A good alternative would be to get the test over on the IAAI site and
then anybody who wanted to could download the programs and run them on
their own machine and report the results.


> Also, did you run them in the same order for all tests? And did you 
> SETOBJACC *PURGE & CLRPOOL between runs, so that there was no data
left in
> memory? This is necessary to compare apples to apples when doing unit 
> tests such as this.

"Necessary" depends highly on what you're trying to prove, but feel free
to come on over to the IAAI and help us add some of those features to
the test suite.  Personally, I think that stuff is overkill because in a
real production environment you don't have those issues, and it will
skew the results towards techniques that don't take advantage of the
inherent cache mechanisms of OS/400.


In any event, the test suite is almost ready for public discourse.  I
will try to make the first version available this weekend.  It's not
intended to be commercial grade; it certainly won't worry about all of
your concerns, Vern.  But it will run tests and it will provide a simple
framework for adding more tests.  The only question is how much
documentation I'll have in place.  But those of you who are have strong
opinions about how benchmarks should be run, please come on over and add
your suggestions.


Joe
http://forums.plutabrothers.com/IAAI

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.