Chris,
Yes, an I-Type and an I-descriptor are two words for the same thing.
The point I am making is that you can be exporting what looks on the
surface like a simple data item from UV via ODBC. Then when you look at
the actual dictionary entry, you find it is an I-descriptor with perhaps
two levels of "T<file>..." or a subroutine call to a several thousand
lines of code program which does I/O all over the place. This means that
you are effectively doing a multi-table join record by record to create
your normalised SQL data.
There are several things you could do to improve performance
* One is to tweak the ODBC Client parameters, which you
are trying.
It might just be that the ODBC protocol is so hopelessly slow that minor
improvements are all you will be able to achieve.
Other alternatives would be to try different technologies for the export
* OLEDB is said to be quicker than ODBC and should be
fairly low effort to try
* 'pushing' the data via UniBasic programs and the
UniVerse BCI may be quicker but could be a lot of
programming
* a third-party product (or one you write yourself) that
uses the UniObjects interface and protocol, or even a
home-rolled sockets interface, should be seriously quicker.
Chris, it seems to me that you may need to get some paid help on this.
The U2 list is a good place to start, it includes some very competent
people in various parts of the world who would be glad to provide you
with professional help.
Good luck!
Mike
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Chris Brooks
> Sent: Saturday, 12 August 2006 02:02
> To: [email protected]
> Subject: RE: [U2] Universe ODBC driver performance issues
> {Unclassified}
>
> Mike,
> The NIC is reporting 1-2% busy. Can you explain I-Type
> Dictionary items? Is an I-Type Dictionary Item equivalent to
> a I-descriptor?
> Sorry I am new to UniVerse, Thanks for your patience!!!
> Chris
>
The information contained in this Internet Email message is intended
for the addressee only and may contain privileged information, but not
necessarily the official views or opinions of the New Zealand Defence Force.
If you are not the intended recipient you must not use, disclose, copy or
distribute this message or the information in it.
If you have received this message in error, please Email or telephone
the sender immediately.
-------
u2-users mailing list
[email protected]
To unsubscribe please visit http://listserver.u2ug.org/
