HP3000-L Archives

November 2003, Week 2

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Travis Howerton <[log in to unmask]>
Reply To:
Travis Howerton <[log in to unmask]>
Date:
Wed, 12 Nov 2003 14:46:05 -0500
Content-Type:
text/plain
Parts/Attachments:
text/plain (30 lines)
Hello.

I have an interesting problem:

We have an Image Detail dataset with an X12 Search Item.

If we do a FIND in Query on the Automatic Master for that X12 with certain
Keys (that do NOT exist in the dataset), it takes several minutes to
complete. It should take milliseconds. Ok... That's wierd.

Now, that Automatic master has BTREE Indexing on it. If I turn off
BTREEMODE1 or remove the Index on that Automatic, the FINDs work just fine.

Also, Finds on the Detail using the same key work just fine with or without
BTREE indexing.

This seems to have been fixed in MPE 7.0 but in 6.0 and 6.5 it seems to be a
problem.

I looked through the Communicators for 7.0 and searched online docs
extensively but could not find anything mentioning the fix. Does anyone here
know where I could find information on precisely what the problem is?

Thanks,

Travis.

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2