ca.portal.admin

Release 16.0 in PRODUCTION

Discussion created by ca.portal.admin on Feb 8, 2005
I would like to find out how many installations are running Release 16.0 in
Production or plan to migrate to Production sometime in the near future.
Also, I would like to know if any installations are using any of the new
TCP/IP API features with the IDMS SQL Option and/or using ODBC/JDBC with
Release 16.0.

Thank you for any information you can provide,

John Collins
SAIC
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: System Owned Indexes
"You've got a variety of feedback on this one - and being freshly back from a
week off I'd like to put in my $.02 worth in. I think it all depends on how
densely or sparsely populated the area containing the member record type is.
If the member of the index has (let's say) 10 occurrences per page then each
read gets you 10 members. Given that the logical sequence in the index and
physical sequence in the area are not the same (most common situation) -
then by index will cost you more than by member - because instead of getting
10 records per I/O you will probably get an I/O per record - only
exceptionally large buffers will save you a few re-reads of the same page.

If you have a 100,000 page area with 1,000 members then it's costing you 100
reads per record - because you have to read pages that don't contain that
record type - in this case by index will save you heaps. I think the
considerations are very similar to planning your access strategy for a
user-written program.

Anyway - after a week off that's how I see it - maybe my brain is still out
there in the surf.

HTH - cheers - Gary

Gary Cherlet
Justice Technology Services
Telephone (+61-8) 8226 5199
Facsimile (+61-8) 8226 5311
Mobile 041 333 1613
MailTo:cherlet.gary@saugov.sa.gov.au

This e-mail message and any attachments are qualified as follows:
Addressing: If you have received this e-mail in error, please advise by
reply e-mail to the sender. Please also destroy the original transmission
and its contents.
Confidentiality: This e-mail may contain confidential information which
also may be legally privileged. Only the intended recipient(s) may access,
use, distribute or copy this e-mail.
Individual Views: Unless otherwise indicated, the views expressed are those
of the sender, not Justice Technology Services.
Computer Viruses: It is the recipient's responsibility to check the e-mail
and any attached files for viruses.

Outcomes