Re: How many companies are buying new AS400's

well... I think this conversation is over for me.
I just installed Postgres on my windows PC (it's a dual core P4 with 2
gb of Ram... similar to a server without a fancy SCSI drive system, a
huge amount of ram or any kind of hardware redundancy...oh, and it's
running windows XP, which isn't as streamlined as Windows Server)

Then, using ODBC I copied about 300 GB of data in the form of 4 tables
(err, files) to my PC. Rebuilt the indexes, and ran a query that
used to take just over 15 minutes in on our model 810. It took right
over 9 minutes in postgres. Granted, our model 810 is a bit slower
than my PC, but this PC cost about $1,400 from dell about a year
ago.... don't know how much that model 810 cost...and I don't know how
fast it is compared to a dual core pentium 4 pc.

It took forever to copy all that data, but I think this has really
provided me with the information I needed to make an informed
decision. The only factor to consider is that there may have been
more users on the as400, that's why I benchmarked the query at over 15
minutes at 7:15 AM, when absolutely no one is using it and it has just
finished it's daily reboot process, so nothing remains cached.

What could possibly make a PERSONAL COMPUTER that much faster? The
total aggregation of the sales query was exactly the same, to the
quarter of a penny. There's a lot of data there, 10's of millions of
records, maybe the iSeries doesn't handle larger tables as well?
They were indexed exactly the same, and the query plan was showing SQE
using the indexes that I thought it should on the iSeries. Not sure
about the query plan on the postgres, don't know it well enough to
find the explain tool.

I'm rerunning the query now, I'll post the results if it varies much.

.

Relevant Pages

  • Re: How many companies are buying new AS400s
    ... I just installed Postgres on my windows PC (it's a dual core P4 with 2 ... that's why I benchmarked the query at over 15 ... using the indexes that I thought it should on the iSeries. ...
    (comp.sys.ibm.as400.misc)
  • Re: Microsoft Access Queries to an Oracle DB run 4 times slower in XP than Win98
    ... If Windows XP needs more RAM to run efficiently, there will be less RAM for ... If you can't do that you may be able to restructure your query and report. ... When we upgraded from running Win98 to Windows XP Professional (ver ... SP2) the queries times degraded significantly. ...
    (microsoft.public.access.queries)
  • Re: Great SWT Program
    ... Windows and Mac and I expect KDE and Gnome search boxes reappear ... populated with the last performed query, while those / prompts give ... query in a few tools. ... history and/or autocomplete of previous searches. ...
    (comp.lang.java.programmer)
  • Re: Event ID: 7023
    ... Select Start, Run, type "cmd" without quotes and hit ENTER, type cd\ ... The exit code on a Windows XP Home Edition computer is 126 meaning the ... Type "sc query application management" and hit ENTER. ... after you install Windows XP Service Pack 2. ...
    (microsoft.public.windowsxp.general)
  • Re: How many companies are buying new AS400s
    ... on a model 810 iSeries. ... I ran the query again this morning... ... I then ran the query on my Postgres PC running Windows XP pro. ... I started that app, stopped my postgres server service, then ...
    (comp.sys.ibm.as400.misc)