Thought inc.

The Dynamic O/R Mapping Company
     

CocoBase Technical Support Forums
For access to developer site with software download and doc's, please request CocoBase download and password
will be emailed to you. Response to posts will appear when answered by THOUGHT Support team.
NOTE:You must register separately with forum in order to post your questions, please click on register icon below.
Home   Frequently Asked Questions   Search   Edit your profile   Registration is free!  
Email This Page to Someone!
Show a Printable Version
CocoBase Enterprise O/R Forums > CocoBase Questions
performance issue with DATE type
< Previous Thread     Next Thread >
Author
Thread    Post New Thread     Post A Reply
CristianRubio
Member

Registered: Jun 2007
Posts: 9

Hello,

We are using cocoabase 4.5 and we are migrating from oracle 8i to oracle 10g.

We are experiencing performance problems when updating a table where the primary key is a DATE datatype
<CBField location="0" catalogname="null" schemaname="" tablename="DEPOT_POSITION" fieldname="COB_DATE" fieldvalue=":COB_DATE" dbfieldtype="DATE" fielddirection="0" dbtype="93" dbfieldsize="7" searchable="7" signed="7" keyposition="1">
</CBField>


Tracing the oracle we see that oracle is calling an internal function to convert the date cocobase is dispatching to the oracle datatype.
We think our performance problems can be reduced if this internal function is not called.

Is it posible to change the settings in the cocobase descriptor, the datatype for example, to not run this internal function?

Thanks in advance.

07-17-2007 04:03 AM
Click Here to See the Profile for CristianRubio    Find more posts by CristianRubio        Edit/Delete Message    Reply w/Quote    IP: Logged
admin
Administrator

Registered: Apr 2001
Posts: 19

Hi,

Your field mapping refers to dbType="93", which is correct for Oracle's DATE type. But note this is the jdbc type code for java.sql.Timestamp. How are you declaring your primary key fields in your Java class - is it a java.sql.Timestamp?

THOUGHT Support

07-18-2007 05:30 AM
Click Here to See the Profile for admin    Find more posts by admin        Edit/Delete Message    Reply w/Quote    IP: Logged
All times are PST (US)    Post New Thread     Post A Reply
Forum Jump:
< Previous Thread     Next Thread >

Forum Rules:
Who Can Read The Forum? Any registered user or guest.
Who Can Post New Topics? Any registered user.
Who Can Post Replies? Any registered user.
Changes: Messages can be edited by their author. Messages can be deleted by their author.
Posts: HTML code is OFF. Smilies are OFF. vB code is OFF. [IMG] code is OFF.

Admin Options:
Open / Close Thread
Move Thread
Delete Thread
Edit Thread

< Contact Us - THOUGHT Inc. >

Copyright © Jelsoft Enterprises Limited 2000.
Copyright 2001 All Rights Reserved, THOUGHT Inc.