Warning: This message has had one or more attachments removed
Warning: (not named).
Warning: Please read the "AngelicHost-Attachment-Warning.txt" attachment(s)
for more information.
That is strange. I only have a couple of other ideas:
1. try !GUIDE GLPOST -O to see what it thinks of the file. Perhaps a different
block size would help.
2. I'm betting that index is huge. Perhaps it's the overhead of Windows
looking at such a large file. What if you removed the large index and simply
tried an index on clientno? You could also try adding the clientno index
before removing your other large index. Just to see.
3. Check the release notes - perhaps there is an issue with indices in your
version????
4. Contact IBM support - that's why you're paying them the big bucks :-)
hth
Colin Alfke
Calgary Canada
________________________________
From: Bill Haskett
Colin:
There's something wrong here. Here's what I get when I do some selects:
A non-indexed select.
4 Demo (0)-> .X3-1
TIME
13:29:28 Aug 16 2007
SELECT GLPOST WITH CLIENTNO = "605"
33137 records selected to list 0.
TIME
13:29:33 Aug 16 2007
4 Demo (0)>> CLEARSELECT
Supposedly an indexed select.
4 Demo (0)-> .X2,4,2
TIME
13:30:40 Aug 16 2007
SELECT GLPOST WITH INDEX_2 = "0605]"
33137 records selected to list 0.
TIME
13:30:57 Aug 16 2007
4 Demo (0)>> CLEARSELECT
So, I deleted the index and recreated (and rebuilt) them. Then I tried again
running
all the commands one right after another:
4 Demo (0)-> .X9,11,9,8,9,10,9,8
TIME
13:38:16 Aug 16 2007
SELECT GLPOST WITH CLIENTNO = "605"
33137 records selected to list 0.
TIME
13:38:21 Aug 16 2007
CLEARSELECT
TIME
13:38:21 Aug 16 2007
SELECT GLPOST WITH INDEX_2 = "0605]"
33137 records selected to list 0.
TIME
13:38:38 Aug 16 2007
CLEARSELECT
4 Demo (0)->
As you can see, the supposed index select is significantly slower than the
regular
select. Checking the file I get:
4 Demo (0)-> FILE.STAT GLPOST
13:40:07 Aug 16 2007
FILE MOD OV HTY ITEMS BYTES MNI/G MXI/G MNB/I MXB/I
GLPOST 20543 1494 0 1227419 113228292 1 64 55
137
------- ------- -------
22037 1227419 113228292
...so I don't think it is a file issue.
This appears to be a pretty significant problem. I didn't really notice this
during
the six months of testing because the machine was so fast, as is UD. But now,
in
production, we're getting some slowness the users are noticing.
Bill
This is a message from the MailScanner E-Mail Virus Protection Service
----------------------------------------------------------------------
The original e-mail attachment "winmail.dat"
was believed to be infected by a virus and has been replaced by this warning
message.
If you wish to receive a copy of the *infected* attachment, please
e-mail helpdesk and include the whole of this message
in your request. Alternatively, you can call them, with
the contents of this message to hand when you call.
At Thu Aug 16 22:23:29 2007 the virus scanner said:
Could not parse Outlook Rich Text attachment
Note to Help Desk: Look on the AngelicHost MailScanner in
/home/virtual/site2/fst/var/spool/mail.quarantine/20070816 (message
l7H5NO0J010250).
--
Postmaster
MailScanner thanks transtec Computers for their support
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
