Re: Job Priority, QZDASOINIT

What type of performance do you get if you run this on the AS400 with
STRSQL?

Have you tried a STRDBMON to see where the 2 minutes is spent?


Jim

"Kmckenzie" <kenneth.mckenzie@xxxxxxxxxxx> wrote in message
news:1138121835.797960.84050@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> I'm certin that the connection is OK and the AS400 is at less than 20%
> total CPU usage. This is one of the SQL statements I'm trying to run.
> It looks at a table with about 3 million records.
>
> SELECT VPPACK.PKCMNO, VPPACK.PKWHSE, VPPACK.PKSHIP, VPPACK.PKLIN#,
> VPPACK.PKINDX, VPPACK.PKPCKC, VPPACK.PKORDR, VPPACK.PKSTAT,
> VPPACK.PKCNID, VPPACK.PKPKIT, VPPACK.PKITDS, VPPACK.PKPKQT,
> VPPACK.PKUNTP, VPPACK.PKEXTP, VPPACK.PKIWGT, VPPACK.PKSHCN,
> VPPACK.PKUSER, VPPACK.PKCHGT, VPPACK.PKCHGD, VPPACK.PKDSTN
> FROM S10DBB1F.SHP4VAR25F.VPPACK VPPACK
> WHERE PKSHIP = '19JYX'
> ORDER BY VPPACK.PKSHIP, VPPACK.PKLIN#
>
> It takes about 2 minutes to return one record. Is that normal
> performance? Is there a better way? Should I learn RPG? All of the
> data queried will be used to build some reports. We perviously used a
> SQL Server with Access as our reporting tool.
>
> Thanks again
>
> Ken
>


.

Relevant Pages

  • Re: Microsoft JET Database Engine error 80040e10
    ... suppost to remove the "Set rspoll=" part or not. ... Response.Write strSQL ... but BEFORE the Execute statement (it's the Execute statement that is ... the use of concatenation to form sql statements (aka ...
    (microsoft.public.data.ado)
  • Re: 2 sql command
    ... You will have to write the SQL statements. ... Dim strSql As String ... ClientID - primary key ... how do i code it that all data of tblAnswer is linked to tblclient through ...
    (microsoft.public.access.queries)
  • Re: How to create an append query that appends to more than one ta
    ... You could write some VBA code that executes a series of SQL statements. ... Dim strSql As String ... Is there anyway to combine multiple append querries in one ...
    (microsoft.public.access.queries)
  • Re: Job Priority, QZDASOINIT
    ... I'm certin that the connection is OK and the AS400 is at less than 20% ... total CPU usage. ... This is one of the SQL statements I'm trying to run. ... SQL Server with Access as our reporting tool. ...
    (comp.sys.ibm.as400.misc)
  • Re: Cannot figure out error in asp code
    ... The easiest way to depug your SQL statements in asp is ... response.write strSQL ... - it plugs in all your variables in and you can check ...
    (microsoft.public.inetserver.asp.general)