Oracle Visual Basic Connectivity
From: Anbazhagan <t_anbazhagan_at_rediffmail.com>
Date: 30 Oct 2003 06:54:32 -0800
Message-ID: <a34cceea.0310300654.711601df_at_posting.google.com>
Date: 30 Oct 2003 06:54:32 -0800
Message-ID: <a34cceea.0310300654.711601df_at_posting.google.com>
Hi,
I'm using Oracle 9i with Spatial to store geographical data. It has only hundreds of features with very minimal veritices. I use OO4O (Oracle InProc) as component to access the oracle server from Visual Basic.
It seems that it takes more time to retrieve the information stored. Some time back I, used same kind of data in Oracle 8 (without spatial). It worked fine with OLE DB provider.
Since I need to access some of the VARRAY fields, I choose OO4O as middleware.
How can I speed up the process (retrieving the information). Is there any other method to read the VARRAY fields in OLE DB (ADO).
Thanks in advance. Received on Thu Oct 30 2003 - 15:54:32 CET