| T.R | Title | User | Personal
Name | Date | Lines |
|---|
| 987.1 | | FORTY2::PULLEN | Julian Pullen | Tue Mar 18 1997 17:48 | 4 |
| Are you using the new schema. On unix you have to delete dsa to
a snapshot file and create the DSA from the snapshot file.
Julian
|
| 987.2 | | GOBUCS::COOLEY | Megan and Michelle's Daddy | Tue Mar 18 1997 17:53 | 5 |
| Julian,
Thanks for the reminder, but that has been done.
Warren
|
| 987.3 | | a-109.tunnel.crl.dec.com::FORTY2::PALKA | Andrew Palka Altavista Directory | Wed Mar 19 1997 09:30 | 5 |
| I can't think of any reason why ia5 syntax should be significantly
different from printable string. The matching rules are almost
identical.
Andrew
|
| 987.4 | | FORTY2::PULLEN | Julian Pullen | Wed Mar 19 1997 14:52 | 5 |
| What type of match are you using a match of
a substring match starting with "*<string>"
can not use the index.
Julian
|
| 987.5 | More information | GOBUCS::COOLEY | Megan and Michelle's Daddy | Wed Mar 19 1997 17:34 | 24 |
| Some more information.
I can use dxim to see the problem:
I do dxim select where rfc822mailbox=asdfasjdlfj
and it takes 5-6 seconds to come back with no matches. (even when repeated)
I do dxim select where surname=asdlkfjad
and it comes back immediately with no matches.
(I positive rfc822mailbox is indexed, because it was taking even longer
and doing a select on another non-index attribute is still taking longer).
There are currently 146,000 entries all of which have a surname.
Only about 20,000 entries have a value for rfc822mailbox.
All the rfc822mailbox entries end in "@lmco.com". Is that Significant?
The other thing I'm seeing is the DSA process doesn't seem to want to
page in all it's data space. The vsize of DSA is 320M but the rssize
doesn't seem to want to get bigger than about 200M (seen using ps).
Is there a way to make sure the DSA process gets paged in and stays there?
I'm now up to 512M of physical memory.
Regards,
Warren
|
| 987.6 | Problem solved - rfc822mailbox wasn't indexed afterall | GOBUCS::COOLEY | Megan and Michelle's Daddy | Thu Mar 20 1997 17:20 | 20 |
| Hi,
I decided to delete my previous note since it was written too late at night :-)
I apoligize if anyone thought it was offensive.
Anyway, the problem has been solved!!!
It turned out to be that rfc822mailbox was in fact not indexed because the
customized *.sc file which contained the Index clause was included FIRST in
dxd_schema.sc. When I moved it to be included LAST, recompiled the schema,
disabled, deleted to snapshot, created from snapshot, enabled - access to
rfc822mailbox is fast. My program, which was accessing records based on
this attribute is now taking 9 minutes instead of 15 hours.
Please QAR the dxd_sc compiler program to include a warning message when
this happens (or fix it to be indexed) instead of ignoring the index request.
If you would like me to mail this request to FORTY2_SUPPORT, let me know.
Regards,
Warren
|