March 2006
Top 15 Reasons We Don't...
01. Top 15 Reasons We Don't...
In response to customer requests for a simple yet informative overview of the "essence" of WOW, we here at PlanetJ have put together the official Top 15 Reasons We Don't... Keep an eye on this site as we post two new reasons every other week.

02. WOW Brings Home the Gold, Again!
WOW takes gold for the second year in a row! Once again, Web Object Wizard is awarded Search400's Product of the Year Gold in Application Development Tools. Says one judge, "WOW wins again in this category on function, portability, and value."

03. Introduction to WOW Course
This 3-day introductory course will provide you and your developers the necessary WOW basics to begin producing iSeries web applications immediately. Contact PlanetJ for dates, registeration, and special group rates.

04. PlanetJ Application Development Services
Don't have time to develop your own web application? Contact a PlanetJ developer today for quick and cost effective delivery of your application. In most cases, we can build your application faster than anybody else...because we use the best tools.

05. 2006 Michigan iSeries Techinal Education Conference
PlanetJ's Paul Holm will be speaking on leveraging iSeries tools to create web applications at the Michigan User Group meeting on June 6, 2006.
06. OCEAN Annual i5 Technical Conference
Southern CA iSeries loyalists—visit us at the Hyatt Regency Hotel in Irvine CA for this popular event. Senior WOW Developer, Paul Holm will be presenting educational sessions on iSeries Web Development and we’ll have the latest WOW features available for demo at the Expo! 07. WOW Case Study
Daffron & Associates, a utility enterprise solution provider, uses PlanetJ's WOW to create a new enterprise solution. This solution was branded Integration X Platform (iXp) and represents Daffron’s next generation thinking. 08. WOW Webinars
> March 14 - 11AM PST
> March 27 - 1PM PST
> April 5 - 11AM PST

[ Register here now! ]
[ Newsletter Archive ]
WOW: Tips and Tricks

.: WOW Operations Performance

Q: "I'm having performance issues selecting, grouping and sorting from logicals over multiple physical files?"
A: Typically, performance is nearly all outside of WOW’s control. What happens is:

1) WOW passes an SQL statement to the AS/400.
2) The AS/400 executes the statement using the best known optimization as determined by the OS/400. This includes such factors as file size, and database indexes.
3) After execution, WOW reads the data returned from OS/400, generates HTML, and sends to the browser. Nearly all performance is dependent on the AS/400.

To Check Relative Performance:

Take the SQL statement from WOW and use AS/400’s STRSQL and run the same statement and compare results or put the SQL into Client Access or operations navigator and run it to compare results. The results from each method can then be compared. Typically, the WOW results for non-cached data will be slightly slower because WOW is reading all the data and then generating HTML for a browser.