Re: SQL Tools and Performance

[Gerald Kern <jp2558@xxxxxxxxx>]

Vern - putting the B and pressing enter displays the bottom of the result
set *IMMED.

Rob - thanks for those suggestions. I will consider them next time I
encounter such a situation.

It is a quite simple statement that I used in STRSQL and in the PC tools:

select STATUS,ECWUID,CHART,ECWACCT,LASTNAME,FIRSTNAME,
BIRTHDATE,RPPTSX from ecppatxrf
join rpmast on chart = rpptno
where rpstat in ('A', 'I')  and rploc =
'0'
order by ecwacct

I don't think it's a memory issue (64 bit Win 7 with 16 gb ram), but I
suppose the pc tools could have their own constraints. Network isn't the
issue as we do a lot of image distribution/exchanges with hospitals and
have gigabit fiber running internally in our network.

The job eventually did finish after about 20 minutes.

Thanks for the input.