Re: Time to get serious

On Fri, 25 Feb 2005 17:02:53 -0500
 "Walden H. Leverich" <WaldenL@xxxxxxxxxxxxxxx> wrote:
> Honestly, I wouldn't mind seeing more/better iSeries
> advertising, but be
> careful, you've got to get your facts straight: 
> 
> >Use SQL if you want, but get even better performance
> with native
> programming.
> 
> Native may perform better on iSeries than SQL on iSeries,
> but that
> doesn't mean native on iSeries is better than SQL on
> another platform.
> We've see the results on this list (or maybe ignite, or
> web400, don't
> recall) a small PC with SQLServer blows the doors off a
> small iSeries
> w/SQL. 
> 

I'd be interested in hearing the specifics about this.
 Such as the data load, indexes that existed on each
machine, etc.

I rewrote an app that previously ran MSSQL and it was fast,
until it got to around 1000 records.  Then it would totally
die.  the problem, we were dealing with millions of records
that had to be moved to the PC anyhow.

So I rewrote it as a native app using RPG and dynamic SQL
and it outperformed the PC server 1000 to 1 easy.  I think
it was a little 170 as well.  I know this was a few years
ago.. so it wasn't one of the "optimially tuned" boxes.

Permanent indexes and knowing how to build "proper" SQL
statements makes all the difference.  And the iSeries SQL
debugger will actually make index suggestions for you.