HP3000-L Archives

November 2001, 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:
ODBCSE drivers have high latency on HP3000
From:
Ian Fleming <[log in to unmask]>
Reply To:
Ian Fleming <[log in to unmask]>
Date:
Mon, 12 Nov 2001 19:45:59 -0600
Content-Type:
text/plain
Parts/Attachments:
text/plain (23 lines) 
Hello MPE gods,

  I recently adopted an HP 3000 running MPE/ix 6.5.  I have a read only ODBC
connector to an Image database that runs extremely slow (up to five minutes)
when running queries on Access 2000.  The actual data that I request amounts
to less than 100K characters.  If I link more than three tables in a query,
I consistantly get an ODBC timeout.

  How do I manage the ODBC server on MPE?  Is there a way to terminate open
ODBC sessions?  How about monitor the load of the server?  I am really a
*nix guy, a newbie to MPE.

  I am about to construct an ASP script to retrieve data over an IIS server
but I am afraid of excessive wait time and timeouts if I cannot resolve this
problem.

Thanks.

Ian Fleming

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

ATOM RSS1 RSS2