[mapguide-users] New King.Oracle 0.8 - improved performance
Haris Kurtagic
haris at sl-king.com
Fri Nov 21 07:00:59 EST 2008
I tried King.Oracle 0.8.5 with MGOS 2.0.2 with Oracle Instant clients
10.2.0.1 (.3 and .4) and 11.1.0.6.
I tried to put together bigger map with lot of data.
It all works very nicely (very fast), I cant see or reproduce any
problem.
Is it posiblle you try to use just one layer which will result in error
and give me data for it ?
Perhaps it is some particullar data or data type.
Thanks,
Haris
-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick Adams
Sent: Friday, November 21, 2008 12:21 PM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved performance
Hi Harris,
I've tried:
- Oracle 10.2 instant client
- Oracle 11g client
Both give the same:
Attempted to read or write protected memory... error.
I can also concur with FISHeR1: 0.8.4 gives an Unclassified Exception
when
rendering a layer in MGOS 2.02, using the instant client.
I'm not 100% certain, but from recollection 0.8.2 was the last version I
saw
working in MGOS.
Nick
haris kurtagic wrote:
>
> Which Oracle client and which version are you using ?
>
> Haris
>
>
> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org
> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick
Adams
> Sent: Thursday, November 20, 2008 5:04 PM
> To: mapguide-users at lists.osgeo.org
> Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved
performance
>
>
>
> 0.8.4 is giving the same error:
> Attempted to read or write protected memory. This is often an
indication
> that other memory is corrupt.
>
>
> Nick
>
>
> Nick Adams wrote:
>>
>>
>> Ok. I've tried 0.8.3 and I'm now getting:
>> Attempted to read or write protected memory. This is often an
> indication
>> that other memory is corrupt.
>>
>>
>> Nick
>>
>>
>> haris kurtagic wrote:
>>>
>>> I posted 0.8.3 which should fix first problem.
>>>
>>> Regarding SDO_FILTER If I remember correcly that is problem with 9.1
> (
>>> provider works in 9.2 ? ).
>>>
>>> I don't have 9 versions available to test but if I look at docs and
> you
>>> try it perhaps we can fix it without me trying it.
>>>
>>> Haris
>>>
>>> -----Original Message-----
>>> From: mapguide-users-bounces at lists.osgeo.org
>>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick
> Adams
>>> Sent: Thursday, November 20, 2008 3:55 PM
>>> To: mapguide-users at lists.osgeo.org
>>> Subject: RE: [mapguide-users] New King.Oracle 0.8 - improved
> performance
>>>
>>>
>>>
>>> - I have been using OracleSchema and it was set to the same as the
>>> username
>>> - Previously I was using 0.7.4.
>>> Unfortunately this didn't work. Then I was getting the error:
>>> ORA-29900: operator binding does not exist ORA-06553: PLS-306:
> wrong
>>> number or types of arguments in call to 'SDO_FILTER'
>>>
>>> This I understand to be down to the fact that SDO_FILTER requires 3
>>> arguments in 9i where-as the third one is optional in 10g. I was
> hoping
>>> 0.8.x might solve this.
>>>
>>>
>>> Nick
>>>
>>>
>>> haris kurtagic wrote:
>>>>
>>>> I am looking at code and I have two questions :
>>>>
>>>> - are you using connection property OracleSchema, and value is same
> as
>>>> UserName ?
>>>> - this has worked for you before release 0.8.2 ?
>>>>
>>>> Haris
>>>>
>>>> -----Original Message-----
>>>> From: mapguide-users-bounces at lists.osgeo.org
>>>> [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Nick
>>> Adams
>>>> Sent: Thursday, November 20, 2008 2:57 PM
>>>> To: mapguide-users at lists.osgeo.org
>>>> Subject: Re: [mapguide-users] New King.Oracle 0.8 - improved
>>> performance
>>>>
>>>>
>>>>
>>>> Hi Haris,
>>>>
>>>> I've just downloaded version 0.82 a tried it.
>>>> The problem I'm working on is using the King Oracle provider with
> .Net
>>>> to
>>>> connect to a 9i oracle database.
>>>>
>>>> The query I'm making is:
>>>> SHAPE ENVELOPEINTERSECTS GeomFromText('POLYGON ((325400 701400,
> 325600
>>>> 701400, 325600 701600, 325400 701600, 325400 701400))')
>>>>
>>>> The current error it's giving me when I try this is:
>>>>
>>>> ORA-00904: "C"."SDO_INDEX_OWNER": invalid identifier
>>>>
>>>> Any suggestions would be appreciated.
>>>>
>>>>
>>>> Nick
>>>>
>>>>
>>>> haris kurtagic wrote:
>>>>>
>>>>> Hi,
>>>>>
>>>>>
>>>>>
>>>>> I have released new version of King.Oracle provider 0.8.
>>>>>
>>>>> It is much faster than previous releases. Lot of code is changed.
>>>>> King.Oracle passed my UniTests but it has to be tested more so
your
>>>>> feedback is appreciated.
>>>>>
>>>>>
>>>>>
>>>>> List of changes:
>>>>>
>>>>> Improved performance - very significant improvement
>>>>>
>>>>> Support for SelectAggregate
>>>>>
>>>>> FDO schema creation is now faster , especially when
>>>> OracleScema=UserName
>>>>>
>>>>> Reintroduced schema caching
>>>>>
>>>>> Full Unicode support
>>>>>
>>>>> Using OCI interface
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> You can get it here: www.sl-king.com/fdooracle
>>>>>
>>>>>
>>>>>
>>>>> Haris
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> _______________________________________________
>>>>> mapguide-users mailing list
>>>>> mapguide-users at lists.osgeo.org
>>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>>
>>>>>
>>>>
>>>> --
>>>> View this message in context:
>>>>
>>>
>
http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
>>>> 002p20601567.html
>>>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>>>
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>> _______________________________________________
>>>> mapguide-users mailing list
>>>> mapguide-users at lists.osgeo.org
>>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>>
>>>>
>>>
>>> --
>>> View this message in context:
>>>
>
http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
>>> 002p20602909.html
>>> Sent from the MapGuide Users mailing list archive at Nabble.com.
>>>
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>> _______________________________________________
>>> mapguide-users mailing list
>>> mapguide-users at lists.osgeo.org
>>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>>
>>>
>>
>>
>
> --
> View this message in context:
>
http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
> 002p20604513.html
> Sent from the MapGuide Users mailing list archive at Nabble.com.
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>
--
View this message in context:
http://www.nabble.com/New-King.Oracle-0.8---improved-performance-tp20580
002p20619229.html
Sent from the MapGuide Users mailing list archive at Nabble.com.
_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users
More information about the mapguide-users
mailing list