RE: Why is the iSeries so slow

> > From: Ken.Slaugh@xxxxxxxxxx
> > 
> > Joe...
> >       Have you tried ADO lately? Ever compare the data retrieval 
> > throughput to an SQL Server?
> 
> Just for security reasons I don't like direct ODBC access to 
> my machine. I prefer JSP and servlets calling RPG programs.  
> And with that architecture, the system flies.
> 
> As to SQL Server, have you tried running a hundred users on a 
> hundred million record database on it?  If your needs are 
> small enough to use a PC-based database, and the security and 
> backup capabilities are sufficient, then by all means do so.  
> No sense using a sledgehammer to crack eggs.
> 
> Joe

Well, actually most users don't have those constraints. 

While I haven't tried that performance load, there are commercial 
web servers that are doing that and more.
SQL Server has really grown up in the last few years. Of 
course, you can put in on a multiprocessor PC server with 20 
GB of RAM, a couple of hundred GB of disk. And get some rather 
nice performance from it. It think you can share the database
load thru multiple servers, also, but don't quote me on that.

Web applications can be written on Windows to run on server farms.
Add another blade server and increase your capacity. Relative cheap, 
and very small footprint.

For the user the consultant was speaking of, the issue is the speed 
of the database, while available to that user to manipulate. 

It's the latter half of the equation that is important to most people
now days.

I thought there were some third party connectors to 
offer faster AS/400 ADO? Is that not true? 

Brad Jensen
Www.elstore.com - LaserVault ERM/EDD/etc.