The "One Laptop Per Child" project has a great device ready to ship, but there's no Java on there. Let's think about working together to put Java on OLPC!
Hi,
I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
data. When I save this resource with one of these data is modified,
procedure becomes very slow. How solve?
Thank you!
Hi Xxlu,
I would need more information then this to comment on why it is slow.
Here are some relevant questions:
- what occupies the cpu: the database or java
- which version of teneo are you using
- did you turn on hibernate/jpox logging and did you see anything special
(http://www.elver.org/hibernate/troubleshooting.html#runtime)
- are all the 1000 objects new or is it an update scenario
- how slow is it, how many seconds does it take
Also the structure of the model matters ofcourse, but a 1000 records should not be really take a
long time...
gr. Martin
xxlu wrote:
> Hi,
> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
> data. When I save this resource with one of these data is modified,
> procedure becomes very slow. How solve?
> Thank you!
>
>
Hi Martin Taal,
Thank you for restoration.
The following is pertinent information:
--Java occupies cpu, about 60%
--I am using teneo1.0.0.v200806111928
--10000 objects are all not new, I have revised a data among them only
--When the data is few(about 100 objects), saving hardly need time.
When the data amount is big( 10000 objects), saving use exceeding 10
seconds.
The following is the log when application start:
Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
createRegisterDataStore
INFO: Creating emf data store and registering it under name: icd
Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
createRegisterDataStore
INFO: Returning created emf data store, initialize this newly created data
store!
Jul 23, 2008 9:16:58 AM
org.eclipse.emf.teneo.classloader.ClassLoaderResolver setClassLoaderStrategy
INFO: Class loader strategy set to:
org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
Jul 23, 2008 9:16:58 AM
org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is declared
as a singleton but this getInstance call passed initialization parameters
so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
log4j:WARN No appenders could be found for logger
(org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
WARNING: No hibernate cache provider set, using
org.hibernate.cache.HashtableCacheProvider
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
WARNING: For production use please set the ehcache (or other) provider
explicitly and configure it
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to update
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.fetch_containment_eagerly: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.password:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.cache.provider_class:
org.hibernate.cache.HashtableCacheProvider
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.version_column: e_version
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.disable_econtainer: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.username: root
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_cache_strategy: NONE
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.sql_name_escape_character: `
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_default_cascade_on_non_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.map_all_lists_as_idbag: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.max_sql_name_length: -1
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_temporal: TIMESTAMP
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.emap_as_true_map: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_varchar_length: -1
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.default_id_column: e_id
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.also_map_as_class: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.add_index_for_fk: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.java_class_entity_names: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.join_table_naming_strategy: unique
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.always_version: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.idbag_id_column_name: ID
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.max_comment_length: 0
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_entity_automatically: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.hibernate_mapping_file: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.set_foreign_key_name: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_policy_on_containment: ALL
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.id_feature_as_primary_key: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.set_generated_value_on_id_feature: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.runtime.update_schema: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.strategy: lowercase
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.always_map_list_as_bag: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.UserDateTimeType:
org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.join_column_naming_strategy: unique
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_proxy: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.UserDateType:
org.eclipse.emf.teneo.hibernate.mapping.XSDDate
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_policy_on_non_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.ignore_eannotations: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.hbm2ddl.auto: update
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.inheritance: JOINED
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.default_id_feature: e_id
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.map_embeddable_as_embedded: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.optimistic_locking: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.join_table_for_non_contained_associations: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_all_on_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
initializeDataStore
WARNING: The teneo update schema option is not used anymore for hibernate,
use the hibernate option: hibernate.hbm2ddl.auto
"Martin Taal"
wrote:g654hh$ehe$1 at build dot eclipse dot org...
> Hi Xxlu,
> I would need more information then this to comment on why it is slow.
> Here are some relevant questions:
> - what occupies the cpu: the database or java
> - which version of teneo are you using
> - did you turn on hibernate/jpox logging and did you see anything special
> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
> - are all the 1000 objects new or is it an update scenario
> - how slow is it, how many seconds does it take
>
> Also the structure of the model matters ofcourse, but a 1000 records
> should not be really take a long time...
>
> gr. Martin
>
> xxlu wrote:
>> Hi,
>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>> data. When I save this resource with one of these data is modified,
>> procedure becomes very slow. How solve?
>> Thank you!
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
I try using the following code to save my object,
SessionWrapper wrapper = ((HibernateResource)
resource).getSessionWrapper();
wrapper.beginTransaction();
wrapper.saveOrUpdate(object);
wrapper.flush();
wrapper.commitTransaction();
The speed saving is as before very slow.
"xxlu"
wrote:g661o1$899$1 at build dot eclipse dot org...
> Hi Martin Taal,
> Thank you for restoration.
> The following is pertinent information:
> --Java occupies cpu, about 60%
> --I am using teneo1.0.0.v200806111928
> --10000 objects are all not new, I have revised a data among them only
> --When the data is few(about 100 objects), saving hardly need time.
> When the data amount is big( 10000 objects), saving use exceeding 10
> seconds.
> The following is the log when application start:
>
> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
> createRegisterDataStore
> INFO: Creating emf data store and registering it under name: icd
> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
> createRegisterDataStore
> INFO: Returning created emf data store, initialize this newly created data
> store!
> Jul 23, 2008 9:16:58 AM
> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
> setClassLoaderStrategy
> INFO: Class loader strategy set to:
> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
> Jul 23, 2008 9:16:58 AM
> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
> declared as a singleton but this getInstance call passed initialization
> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
> log4j:WARN No appenders could be found for logger
> (org.hibernate.cfg.Environment).
> log4j:WARN Please initialize the log4j system properly.
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> WARNING: No hibernate cache provider set, using
> org.hibernate.cache.HashtableCacheProvider
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> WARNING: For production use please set the ehcache (or other) provider
> explicitly and configure it
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
> update
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.fetch_containment_eagerly: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.password:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.cache.provider_class:
> org.hibernate.cache.HashtableCacheProvider
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.version_column: e_version
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.disable_econtainer: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.username: root
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_cache_strategy: NONE
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.sql_name_escape_character: `
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_default_cascade_on_non_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.map_all_lists_as_idbag: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.max_sql_name_length: -1
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_temporal: TIMESTAMP
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.emap_as_true_map: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_varchar_length: -1
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.default_id_column: e_id
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.also_map_as_class: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.add_index_for_fk: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.java_class_entity_names: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.join_table_naming_strategy: unique
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.always_version: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.idbag_id_column_name: ID
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.max_comment_length: 0
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_entity_automatically: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.hibernate_mapping_file: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.set_foreign_key_name: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_policy_on_containment: ALL
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.id_feature_as_primary_key: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.set_generated_value_on_id_feature: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.runtime.update_schema: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.strategy: lowercase
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.always_map_list_as_bag: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.UserDateTimeType:
> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.join_column_naming_strategy: unique
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_proxy: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.UserDateType:
> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_policy_on_non_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.ignore_eannotations: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.hbm2ddl.auto: update
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.inheritance: JOINED
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.default_id_feature: e_id
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.map_embeddable_as_embedded: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.optimistic_locking: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.join_table_for_non_contained_associations: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_all_on_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> initializeDataStore
> WARNING: The teneo update schema option is not used anymore for hibernate,
> use the hibernate option: hibernate.hbm2ddl.auto
>
>
>
> "Martin Taal"
wrote:g654hh$ehe$1 at build dot eclipse dot org...
>> Hi Xxlu,
>> I would need more information then this to comment on why it is slow.
>> Here are some relevant questions:
>> - what occupies the cpu: the database or java
>> - which version of teneo are you using
>> - did you turn on hibernate/jpox logging and did you see anything special
>> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>> - are all the 1000 objects new or is it an update scenario
>> - how slow is it, how many seconds does it take
>>
>> Also the structure of the model matters ofcourse, but a 1000 records
>> should not be really take a long time...
>>
>> gr. Martin
>>
>> xxlu wrote:
>>> Hi,
>>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>>> data. When I save this resource with one of these data is modified,
>>> procedure becomes very slow. How solve?
>>> Thank you!
>>
>>
>> --
>>
>> With Regards, Martin Taal
>>
>> Springsite/Elver.org
>> Office: Hardwareweg 4, 3821 BV Amersfoort
>> Postal: Nassaulaan 7, 3941 EC Doorn
>> The Netherlands
>> Cell: +31 (0)6 288 48 943
>> Tel: +31 (0)84 420 2397
>> Fax: +31 (0)84 225 9307
>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>> Web: www.springsite.com - www.elver.org
>
>
Hi Xxlu,
Can you try the latest *maintenance* build of Teneo? (there have been some performance improvements
since the build in june)
Let me know if this helps (or not).
gr. Martin
xxlu wrote:
> I try using the following code to save my object,
> SessionWrapper wrapper = ((HibernateResource)
> resource).getSessionWrapper();
> wrapper.beginTransaction();
> wrapper.saveOrUpdate(object);
> wrapper.flush();
> wrapper.commitTransaction();
> The speed saving is as before very slow.
>
>
> "xxlu"
wrote:g661o1$899$1 at build dot eclipse dot org...
>> Hi Martin Taal,
>> Thank you for restoration.
>> The following is pertinent information:
>> --Java occupies cpu, about 60%
>> --I am using teneo1.0.0.v200806111928
>> --10000 objects are all not new, I have revised a data among them only
>> --When the data is few(about 100 objects), saving hardly need time.
>> When the data amount is big( 10000 objects), saving use exceeding 10
>> seconds.
>> The following is the log when application start:
>>
>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>> createRegisterDataStore
>> INFO: Creating emf data store and registering it under name: icd
>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>> createRegisterDataStore
>> INFO: Returning created emf data store, initialize this newly created data
>> store!
>> Jul 23, 2008 9:16:58 AM
>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>> setClassLoaderStrategy
>> INFO: Class loader strategy set to:
>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>> Jul 23, 2008 9:16:58 AM
>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>> declared as a singleton but this getInstance call passed initialization
>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>> log4j:WARN No appenders could be found for logger
>> (org.hibernate.cfg.Environment).
>> log4j:WARN Please initialize the log4j system properly.
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> WARNING: No hibernate cache provider set, using
>> org.hibernate.cache.HashtableCacheProvider
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> WARNING: For production use please set the ehcache (or other) provider
>> explicitly and configure it
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>> update
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.fetch_containment_eagerly: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.password:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.cache.provider_class:
>> org.hibernate.cache.HashtableCacheProvider
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.version_column: e_version
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.disable_econtainer: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.username: root
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_cache_strategy: NONE
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.sql_name_escape_character: `
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.max_sql_name_length: -1
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.emap_as_true_map: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_varchar_length: -1
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.default_id_column: e_id
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.also_map_as_class: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.add_index_for_fk: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.java_class_entity_names: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.join_table_naming_strategy: unique
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.always_version: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.idbag_id_column_name: ID
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.max_comment_length: 0
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_entity_automatically: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.hibernate_mapping_file: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.set_foreign_key_name: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.id_feature_as_primary_key: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.runtime.update_schema: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.strategy: lowercase
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.always_map_list_as_bag: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.UserDateTimeType:
>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.join_column_naming_strategy: unique
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_proxy: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.UserDateType:
>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.ignore_eannotations: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.hbm2ddl.auto: update
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.inheritance: JOINED
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.default_id_feature: e_id
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.optimistic_locking: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_all_on_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> initializeDataStore
>> WARNING: The teneo update schema option is not used anymore for hibernate,
>> use the hibernate option: hibernate.hbm2ddl.auto
>>
>>
>>
>> "Martin Taal"
wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>> Hi Xxlu,
>>> I would need more information then this to comment on why it is slow.
>>> Here are some relevant questions:
>>> - what occupies the cpu: the database or java
>>> - which version of teneo are you using
>>> - did you turn on hibernate/jpox logging and did you see anything special
>>> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>> - are all the 1000 objects new or is it an update scenario
>>> - how slow is it, how many seconds does it take
>>>
>>> Also the structure of the model matters ofcourse, but a 1000 records
>>> should not be really take a long time...
>>>
>>> gr. Martin
>>>
>>> xxlu wrote:
>>>> Hi,
>>>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>>>> data. When I save this resource with one of these data is modified,
>>>> procedure becomes very slow. How solve?
>>>> Thank you!
>>>
>>> --
>>>
>>> With Regards, Martin Taal
>>>
>>> Springsite/Elver.org
>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>> The Netherlands
>>> Cell: +31 (0)6 288 48 943
>>> Tel: +31 (0)84 420 2397
>>> Fax: +31 (0)84 225 9307
>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>> Web: www.springsite.com - www.elver.org
>>
>
>
"Martin Taal"
wrote:g66f2a$d2o$1 at build dot eclipse dot org...
> Hi Xxlu,
> Can you try the latest *maintenance* build of Teneo? (there have been some
> performance improvements since the build in june)
>
> Let me know if this helps (or not).
>
> gr. Martin
>
>
> xxlu wrote:
>> I try using the following code to save my object,
>> SessionWrapper wrapper = ((HibernateResource)
>> resource).getSessionWrapper();
>> wrapper.beginTransaction();
>> wrapper.saveOrUpdate(object);
>> wrapper.flush();
>> wrapper.commitTransaction();
>> The speed saving is as before very slow.
>>
>>
>> "xxlu"
wrote:g661o1$899$1 at build dot eclipse dot org...
>>> Hi Martin Taal,
>>> Thank you for restoration.
>>> The following is pertinent information:
>>> --Java occupies cpu, about 60%
>>> --I am using teneo1.0.0.v200806111928
>>> --10000 objects are all not new, I have revised a data among them
>>> only
>>> --When the data is few(about 100 objects), saving hardly need time.
>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>> seconds.
>>> The following is the log when application start:
>>>
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Creating emf data store and registering it under name: icd
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Returning created emf data store, initialize this newly created
>>> data store!
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>> setClassLoaderStrategy
>>> INFO: Class loader strategy set to:
>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>>> declared as a singleton but this getInstance call passed initialization
>>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>>> log4j:WARN No appenders could be found for logger
>>> (org.hibernate.cfg.Environment).
>>> log4j:WARN Please initialize the log4j system properly.
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: No hibernate cache provider set, using
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: For production use please set the ehcache (or other) provider
>>> explicitly and configure it
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>>> update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.fetch_containment_eagerly: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.password:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.cache.provider_class:
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.version_column: e_version
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.disable_econtainer: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.username: root
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_cache_strategy: NONE
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.sql_name_escape_character: `
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.max_sql_name_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.emap_as_true_map: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_varchar_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_column: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.also_map_as_class: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.add_index_for_fk: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.java_class_entity_names: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_table_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.XSDDateClass:
>>> javax.xml.datatype.XMLGregorianCalendar
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_version: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.idbag_id_column_name: ID
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.max_comment_length: 0
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_entity_automatically: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.hibernate_mapping_file: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_foreign_key_name: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.id_feature_as_primary_key: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.runtime.update_schema: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.strategy: lowercase
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_map_list_as_bag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateTimeType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_column_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_proxy: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.ignore_eannotations: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.hbm2ddl.auto: update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.inheritance: JOINED
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_feature: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.optimistic_locking: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_all_on_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> initializeDataStore
>>> WARNING: The teneo update schema option is not used anymore for
>>> hibernate, use the hibernate option: hibernate.hbm2ddl.auto
>>>
>>>
>>>
>>> "Martin Taal"
wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>>> Hi Xxlu,
>>>> I would need more information then this to comment on why it is slow.
>>>> Here are some relevant questions:
>>>> - what occupies the cpu: the database or java
>>>> - which version of teneo are you using
>>>> - did you turn on hibernate/jpox logging and did you see anything
>>>> special (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>>> - are all the 1000 objects new or is it an update scenario
>>>> - how slow is it, how many seconds does it take
>>>>
>>>> Also the structure of the model matters ofcourse, but a 1000 records
>>>> should not be really take a long time...
>>>>
>>>> gr. Martin
>>>>
>>>> xxlu wrote:
>>>>> Hi,
>>>>> I use Hibernate EMF Resource of Teneo. The Resource have about
>>>>> 1,0000 data. When I save this resource with one of these data is
>>>>> modified, procedure becomes very slow. How solve?
>>>>> Thank you!
>>>>
>>>> --
>>>>
>>>> With Regards, Martin Taal
>>>>
>>>> Springsite/Elver.org
>>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>>> The Netherlands
>>>> Cell: +31 (0)6 288 48 943
>>>> Tel: +31 (0)84 420 2397
>>>> Fax: +31 (0)84 225 9307
>>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>>> Web: www.springsite.com - www.elver.org
>>>
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
"Martin Taal"
wrote:g66f2a$d2o$1 at build dot eclipse dot org...
> Hi Xxlu,
> Can you try the latest *maintenance* build of Teneo? (there have been some
> performance improvements since the build in june)
>
> Let me know if this helps (or not).
>
> gr. Martin
>
>
> xxlu wrote:
>> I try using the following code to save my object,
>> SessionWrapper wrapper = ((HibernateResource)
>> resource).getSessionWrapper();
>> wrapper.beginTransaction();
>> wrapper.saveOrUpdate(object);
>> wrapper.flush();
>> wrapper.commitTransaction();
>> The speed saving is as before very slow.
>>
>>
>> "xxlu"
wrote:g661o1$899$1 at build dot eclipse dot org...
>>> Hi Martin Taal,
>>> Thank you for restoration.
>>> The following is pertinent information:
>>> --Java occupies cpu, about 60%
>>> --I am using teneo1.0.0.v200806111928
>>> --10000 objects are all not new, I have revised a data among them
>>> only
>>> --When the data is few(about 100 objects), saving hardly need time.
>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>> seconds.
>>> The following is the log when application start:
>>>
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Creating emf data store and registering it under name: icd
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Returning created emf data store, initialize this newly created
>>> data store!
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>> setClassLoaderStrategy
>>> INFO: Class loader strategy set to:
>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>>> declared as a singleton but this getInstance call passed initialization
>>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>>> log4j:WARN No appenders could be found for logger
>>> (org.hibernate.cfg.Environment).
>>> log4j:WARN Please initialize the log4j system properly.
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: No hibernate cache provider set, using
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: For production use please set the ehcache (or other) provider
>>> explicitly and configure it
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>>> update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.fetch_containment_eagerly: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.password:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.cache.provider_class:
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.version_column: e_version
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.disable_econtainer: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.username: root
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_cache_strategy: NONE
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.sql_name_escape_character: `
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.max_sql_name_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.emap_as_true_map: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_varchar_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_column: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.also_map_as_class: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.add_index_for_fk: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.java_class_entity_names: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_table_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.XSDDateClass:
>>> javax.xml.datatype.XMLGregorianCalendar
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_version: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.idbag_id_column_name: ID
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.max_comment_length: 0
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_entity_automatically: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.hibernate_mapping_file: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_foreign_key_name: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.id_feature_as_primary_key: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.runtime.update_schema: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.strategy: lowercase
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_map_list_as_bag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateTimeType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_column_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_proxy: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.ignore_eannotations: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.hbm2ddl.auto: update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.inheritance: JOINED
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_feature: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.optimistic_locking: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_all_on_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> initializeDataStore
>>> WARNING: The teneo update schema option is not used anymore for
>>> hibernate, use the hibernate option: hibernate.hbm2ddl.auto
>>>
>>>
>>>
>>> "Martin Taal"
wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>>> Hi Xxlu,
>>>> I would need more information then this to comment on why it is slow.
>>>> Here are some relevant questions:
>>>> - what occupies the cpu: the database or java
>>>> - which version of teneo are you using
>>>> - did you turn on hibernate/jpox logging and did you see anything
>>>> special (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>>> - are all the 1000 objects new or is it an update scenario
>>>> - how slow is it, how many seconds does it take
>>>>
>>>> Also the structure of the model matters ofcourse, but a 1000 records
>>>> should not be really take a long time...
>>>>
>>>> gr. Martin
>>>>
>>>> xxlu wrote:
>>>>> Hi,
>>>>> I use Hibernate EMF Resource of Teneo. The Resource have about
>>>>> 1,0000 data. When I save this resource with one of these data is
>>>>> modified, procedure becomes very slow. How solve?
>>>>> Thank you!
>>>>
>>>> --
>>>>
>>>> With Regards, Martin Taal
>>>>
>>>> Springsite/Elver.org
>>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>>> The Netherlands
>>>> Cell: +31 (0)6 288 48 943
>>>> Tel: +31 (0)84 420 2397
>>>> Fax: +31 (0)84 225 9307
>>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>>> Web: www.springsite.com - www.elver.org
>>>
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
Hi Xxlu,
On other thing you can also try is to set this hibernate option:
hibernate.jdbc.batch_size to a value between 10 and 50
gr. Martin
xxlu wrote:
> Thank you, Martin.
>
>
> "Martin Taal"
wrote:g66f2a$d2o$1 at build dot eclipse dot org...
>> Hi Xxlu,
>> Can you try the latest *maintenance* build of Teneo? (there have been some
>> performance improvements since the build in june)
>>
>> Let me know if this helps (or not).
>>
>> gr. Martin
>>
>>
>> xxlu wrote:
>>> I try using the following code to save my object,
>>> SessionWrapper wrapper = ((HibernateResource)
>>> resource).getSessionWrapper();
>>> wrapper.beginTransaction();
>>> wrapper.saveOrUpdate(object);
>>> wrapper.flush();
>>> wrapper.commitTransaction();
>>> The speed saving is as before very slow.
>>>
>>>
>>> "xxlu"
wrote:g661o1$899$1 at build dot eclipse dot org...
>>>> Hi Martin Taal,
>>>> Thank you for restoration.
>>>> The following is pertinent information:
>>>> --Java occupies cpu, about 60%
>>>> --I am using teneo1.0.0.v200806111928
>>>> --10000 objects are all not new, I have revised a data among them
>>>> only
>>>> --When the data is few(about 100 objects), saving hardly need time.
>>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>>> seconds.
>>>> The following is the log when application start:
>>>>
>>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>>> createRegisterDataStore
>>>> INFO: Creating emf data store and registering it under name: icd
>>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>>> createRegisterDataStore
>>>> INFO: Returning created emf data store, initialize this newly created
>>>> data store!
>>>> Jul 23, 2008 9:16:58 AM
>>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>>> setClassLoaderStrategy
>>>> INFO: Class loader strategy set to:
>>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
<
[Teneo]HibernateResource save very slowly!!
At 1:01 PM on Jul 22, 2008, xxlu wrote:
I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
data. When I save this resource with one of these data is modified,
procedure becomes very slow. How solve?
Thank you!
7 replies so far (
Post your own)
Re: [Teneo]HibernateResource save very slowly!!
Hi Xxlu,I would need more information then this to comment on why it is slow.
Here are some relevant questions:
- what occupies the cpu: the database or java
- which version of teneo are you using
- did you turn on hibernate/jpox logging and did you see anything special
(http://www.elver.org/hibernate/troubleshooting.html#runtime)
- are all the 1000 objects new or is it an update scenario
- how slow is it, how many seconds does it take
Also the structure of the model matters ofcourse, but a 1000 records should not be really take a
long time...
gr. Martin
xxlu wrote:
> Hi,
> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
> data. When I save this resource with one of these data is modified,
> procedure becomes very slow. How solve?
> Thank you!
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal at springsite dot com - mtaal at elver dot org
Web: www.springsite.com - www.elver.org
Re: [Teneo]HibernateResource save very slowly!!
Hi Martin Taal,Thank you for restoration.
The following is pertinent information:
--Java occupies cpu, about 60%
--I am using teneo1.0.0.v200806111928
--10000 objects are all not new, I have revised a data among them only
--When the data is few(about 100 objects), saving hardly need time.
When the data amount is big( 10000 objects), saving use exceeding 10
seconds.
The following is the log when application start:
Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
createRegisterDataStore
INFO: Creating emf data store and registering it under name: icd
Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
createRegisterDataStore
INFO: Returning created emf data store, initialize this newly created data
store!
Jul 23, 2008 9:16:58 AM
org.eclipse.emf.teneo.classloader.ClassLoaderResolver setClassLoaderStrategy
INFO: Class loader strategy set to:
org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
Jul 23, 2008 9:16:58 AM
org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is declared
as a singleton but this getInstance call passed initialization parameters
so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
log4j:WARN No appenders could be found for logger
(org.hibernate.cfg.Environment).
log4j:WARN Please initialize the log4j system properly.
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
WARNING: No hibernate cache provider set, using
org.hibernate.cache.HashtableCacheProvider
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
WARNING: For production use please set the ehcache (or other) provider
explicitly and configure it
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
setDefaultProperties
INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to update
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.fetch_containment_eagerly: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.password:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.cache.provider_class:
org.hibernate.cache.HashtableCacheProvider
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.version_column: e_version
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.disable_econtainer: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.username: root
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_cache_strategy: NONE
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.sql_name_escape_character: `
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_default_cascade_on_non_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.map_all_lists_as_idbag: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.max_sql_name_length: -1
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_temporal: TIMESTAMP
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.emap_as_true_map: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.default_varchar_length: -1
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.default_id_column: e_id
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.also_map_as_class: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.add_index_for_fk: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.java_class_entity_names: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.join_table_naming_strategy: unique
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.always_version: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.idbag_id_column_name: ID
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.max_comment_length: 0
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_entity_automatically: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.hibernate_mapping_file: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.set_foreign_key_name: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_policy_on_containment: ALL
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.id_feature_as_primary_key: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.set_generated_value_on_id_feature: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.runtime.update_schema: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.strategy: lowercase
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.always_map_list_as_bag: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.UserDateTimeType:
org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.join_column_naming_strategy: unique
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.set_proxy: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.UserDateType:
org.eclipse.emf.teneo.hibernate.mapping.XSDDate
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_policy_on_non_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.ignore_eannotations: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: hibernate.hbm2ddl.auto: update
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.inheritance: JOINED
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.naming.default_id_feature: e_id
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.map_embeddable_as_embedded: false
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.optimistic_locking: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.join_table_for_non_contained_associations: true
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
logProperties
INFO: teneo.mapping.cascade_all_on_containment:
Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
initializeDataStore
WARNING: The teneo update schema option is not used anymore for hibernate,
use the hibernate option: hibernate.hbm2ddl.auto
"Martin Taal" wrote:g654hh$ehe$1 at build dot eclipse dot org...
> Hi Xxlu,
> I would need more information then this to comment on why it is slow.
> Here are some relevant questions:
> - what occupies the cpu: the database or java
> - which version of teneo are you using
> - did you turn on hibernate/jpox logging and did you see anything special
> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
> - are all the 1000 objects new or is it an update scenario
> - how slow is it, how many seconds does it take
>
> Also the structure of the model matters ofcourse, but a 1000 records
> should not be really take a long time...
>
> gr. Martin
>
> xxlu wrote:
>> Hi,
>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>> data. When I save this resource with one of these data is modified,
>> procedure becomes very slow. How solve?
>> Thank you!
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
Re: [Teneo]HibernateResource save very slowly!!
I try using the following code to save my object,SessionWrapper wrapper = ((HibernateResource)
resource).getSessionWrapper();
wrapper.beginTransaction();
wrapper.saveOrUpdate(object);
wrapper.flush();
wrapper.commitTransaction();
The speed saving is as before very slow.
"xxlu" wrote:g661o1$899$1 at build dot eclipse dot org...
> Hi Martin Taal,
> Thank you for restoration.
> The following is pertinent information:
> --Java occupies cpu, about 60%
> --I am using teneo1.0.0.v200806111928
> --10000 objects are all not new, I have revised a data among them only
> --When the data is few(about 100 objects), saving hardly need time.
> When the data amount is big( 10000 objects), saving use exceeding 10
> seconds.
> The following is the log when application start:
>
> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
> createRegisterDataStore
> INFO: Creating emf data store and registering it under name: icd
> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
> createRegisterDataStore
> INFO: Returning created emf data store, initialize this newly created data
> store!
> Jul 23, 2008 9:16:58 AM
> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
> setClassLoaderStrategy
> INFO: Class loader strategy set to:
> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
> Jul 23, 2008 9:16:58 AM
> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
> declared as a singleton but this getInstance call passed initialization
> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
> log4j:WARN No appenders could be found for logger
> (org.hibernate.cfg.Environment).
> log4j:WARN Please initialize the log4j system properly.
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> WARNING: No hibernate cache provider set, using
> org.hibernate.cache.HashtableCacheProvider
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> WARNING: For production use please set the ehcache (or other) provider
> explicitly and configure it
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> setDefaultProperties
> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
> update
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.fetch_containment_eagerly: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.password:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.cache.provider_class:
> org.hibernate.cache.HashtableCacheProvider
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.version_column: e_version
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.disable_econtainer: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.username: root
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_cache_strategy: NONE
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.sql_name_escape_character: `
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_default_cascade_on_non_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.map_all_lists_as_idbag: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.max_sql_name_length: -1
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_temporal: TIMESTAMP
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.emap_as_true_map: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.default_varchar_length: -1
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.default_id_column: e_id
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.also_map_as_class: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.add_index_for_fk: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.java_class_entity_names: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.join_table_naming_strategy: unique
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.always_version: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.idbag_id_column_name: ID
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.max_comment_length: 0
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_entity_automatically: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.hibernate_mapping_file: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.set_foreign_key_name: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_policy_on_containment: ALL
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.id_feature_as_primary_key: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.set_generated_value_on_id_feature: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.runtime.update_schema: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.strategy: lowercase
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.always_map_list_as_bag: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.UserDateTimeType:
> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.join_column_naming_strategy: unique
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.set_proxy: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.UserDateType:
> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_policy_on_non_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.ignore_eannotations: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: hibernate.hbm2ddl.auto: update
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.inheritance: JOINED
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.naming.default_id_feature: e_id
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.map_embeddable_as_embedded: false
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.optimistic_locking: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.join_table_for_non_contained_associations: true
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> logProperties
> INFO: teneo.mapping.cascade_all_on_containment:
> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
> initializeDataStore
> WARNING: The teneo update schema option is not used anymore for hibernate,
> use the hibernate option: hibernate.hbm2ddl.auto
>
>
>
> "Martin Taal" wrote:g654hh$ehe$1 at build dot eclipse dot org...
>> Hi Xxlu,
>> I would need more information then this to comment on why it is slow.
>> Here are some relevant questions:
>> - what occupies the cpu: the database or java
>> - which version of teneo are you using
>> - did you turn on hibernate/jpox logging and did you see anything special
>> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>> - are all the 1000 objects new or is it an update scenario
>> - how slow is it, how many seconds does it take
>>
>> Also the structure of the model matters ofcourse, but a 1000 records
>> should not be really take a long time...
>>
>> gr. Martin
>>
>> xxlu wrote:
>>> Hi,
>>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>>> data. When I save this resource with one of these data is modified,
>>> procedure becomes very slow. How solve?
>>> Thank you!
>>
>>
>> --
>>
>> With Regards, Martin Taal
>>
>> Springsite/Elver.org
>> Office: Hardwareweg 4, 3821 BV Amersfoort
>> Postal: Nassaulaan 7, 3941 EC Doorn
>> The Netherlands
>> Cell: +31 (0)6 288 48 943
>> Tel: +31 (0)84 420 2397
>> Fax: +31 (0)84 225 9307
>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>> Web: www.springsite.com - www.elver.org
>
>
Re: [Teneo]HibernateResource save very slowly!!
Hi Xxlu,Can you try the latest *maintenance* build of Teneo? (there have been some performance improvements
since the build in june)
Let me know if this helps (or not).
gr. Martin
xxlu wrote:
> I try using the following code to save my object,
> SessionWrapper wrapper = ((HibernateResource)
> resource).getSessionWrapper();
> wrapper.beginTransaction();
> wrapper.saveOrUpdate(object);
> wrapper.flush();
> wrapper.commitTransaction();
> The speed saving is as before very slow.
>
>
> "xxlu" wrote:g661o1$899$1 at build dot eclipse dot org...
>> Hi Martin Taal,
>> Thank you for restoration.
>> The following is pertinent information:
>> --Java occupies cpu, about 60%
>> --I am using teneo1.0.0.v200806111928
>> --10000 objects are all not new, I have revised a data among them only
>> --When the data is few(about 100 objects), saving hardly need time.
>> When the data amount is big( 10000 objects), saving use exceeding 10
>> seconds.
>> The following is the log when application start:
>>
>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>> createRegisterDataStore
>> INFO: Creating emf data store and registering it under name: icd
>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>> createRegisterDataStore
>> INFO: Returning created emf data store, initialize this newly created data
>> store!
>> Jul 23, 2008 9:16:58 AM
>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>> setClassLoaderStrategy
>> INFO: Class loader strategy set to:
>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>> Jul 23, 2008 9:16:58 AM
>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>> declared as a singleton but this getInstance call passed initialization
>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>> log4j:WARN No appenders could be found for logger
>> (org.hibernate.cfg.Environment).
>> log4j:WARN Please initialize the log4j system properly.
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> WARNING: No hibernate cache provider set, using
>> org.hibernate.cache.HashtableCacheProvider
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> WARNING: For production use please set the ehcache (or other) provider
>> explicitly and configure it
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> setDefaultProperties
>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>> update
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.fetch_containment_eagerly: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.password:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.cache.provider_class:
>> org.hibernate.cache.HashtableCacheProvider
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.version_column: e_version
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.disable_econtainer: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.username: root
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_cache_strategy: NONE
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.sql_name_escape_character: `
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.max_sql_name_length: -1
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.emap_as_true_map: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.default_varchar_length: -1
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.default_id_column: e_id
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.also_map_as_class: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.add_index_for_fk: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.java_class_entity_names: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.join_table_naming_strategy: unique
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.XSDDateClass: javax.xml.datatype.XMLGregorianCalendar
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.always_version: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.idbag_id_column_name: ID
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.max_comment_length: 0
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_entity_automatically: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.hibernate_mapping_file: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.set_foreign_key_name: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.id_feature_as_primary_key: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.runtime.update_schema: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.strategy: lowercase
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.always_map_list_as_bag: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.UserDateTimeType:
>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.join_column_naming_strategy: unique
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.set_proxy: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.UserDateType:
>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.ignore_eannotations: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: hibernate.hbm2ddl.auto: update
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.inheritance: JOINED
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.naming.default_id_feature: e_id
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.optimistic_locking: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> logProperties
>> INFO: teneo.mapping.cascade_all_on_containment:
>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>> initializeDataStore
>> WARNING: The teneo update schema option is not used anymore for hibernate,
>> use the hibernate option: hibernate.hbm2ddl.auto
>>
>>
>>
>> "Martin Taal" wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>> Hi Xxlu,
>>> I would need more information then this to comment on why it is slow.
>>> Here are some relevant questions:
>>> - what occupies the cpu: the database or java
>>> - which version of teneo are you using
>>> - did you turn on hibernate/jpox logging and did you see anything special
>>> (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>> - are all the 1000 objects new or is it an update scenario
>>> - how slow is it, how many seconds does it take
>>>
>>> Also the structure of the model matters ofcourse, but a 1000 records
>>> should not be really take a long time...
>>>
>>> gr. Martin
>>>
>>> xxlu wrote:
>>>> Hi,
>>>> I use Hibernate EMF Resource of Teneo. The Resource have about 1,0000
>>>> data. When I save this resource with one of these data is modified,
>>>> procedure becomes very slow. How solve?
>>>> Thank you!
>>>
>>> --
>>>
>>> With Regards, Martin Taal
>>>
>>> Springsite/Elver.org
>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>> The Netherlands
>>> Cell: +31 (0)6 288 48 943
>>> Tel: +31 (0)84 420 2397
>>> Fax: +31 (0)84 225 9307
>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>> Web: www.springsite.com - www.elver.org
>>
>
>
--
With Regards, Martin Taal
Springsite/Elver.org
Office: Hardwareweg 4, 3821 BV Amersfoort
Postal: Nassaulaan 7, 3941 EC Doorn
The Netherlands
Cell: +31 (0)6 288 48 943
Tel: +31 (0)84 420 2397
Fax: +31 (0)84 225 9307
Mail: mtaal at springsite dot com - mtaal at elver dot org
Web: www.springsite.com - www.elver.org
Re: [Teneo]HibernateResource save very slowly!!
Thank you, Martin."Martin Taal" wrote:g66f2a$d2o$1 at build dot eclipse dot org...
> Hi Xxlu,
> Can you try the latest *maintenance* build of Teneo? (there have been some
> performance improvements since the build in june)
>
> Let me know if this helps (or not).
>
> gr. Martin
>
>
> xxlu wrote:
>> I try using the following code to save my object,
>> SessionWrapper wrapper = ((HibernateResource)
>> resource).getSessionWrapper();
>> wrapper.beginTransaction();
>> wrapper.saveOrUpdate(object);
>> wrapper.flush();
>> wrapper.commitTransaction();
>> The speed saving is as before very slow.
>>
>>
>> "xxlu" wrote:g661o1$899$1 at build dot eclipse dot org...
>>> Hi Martin Taal,
>>> Thank you for restoration.
>>> The following is pertinent information:
>>> --Java occupies cpu, about 60%
>>> --I am using teneo1.0.0.v200806111928
>>> --10000 objects are all not new, I have revised a data among them
>>> only
>>> --When the data is few(about 100 objects), saving hardly need time.
>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>> seconds.
>>> The following is the log when application start:
>>>
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Creating emf data store and registering it under name: icd
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Returning created emf data store, initialize this newly created
>>> data store!
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>> setClassLoaderStrategy
>>> INFO: Class loader strategy set to:
>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>>> declared as a singleton but this getInstance call passed initialization
>>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>>> log4j:WARN No appenders could be found for logger
>>> (org.hibernate.cfg.Environment).
>>> log4j:WARN Please initialize the log4j system properly.
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: No hibernate cache provider set, using
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: For production use please set the ehcache (or other) provider
>>> explicitly and configure it
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>>> update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.fetch_containment_eagerly: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.password:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.cache.provider_class:
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.version_column: e_version
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.disable_econtainer: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.username: root
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_cache_strategy: NONE
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.sql_name_escape_character: `
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.max_sql_name_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.emap_as_true_map: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_varchar_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_column: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.also_map_as_class: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.add_index_for_fk: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.java_class_entity_names: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_table_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.XSDDateClass:
>>> javax.xml.datatype.XMLGregorianCalendar
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_version: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.idbag_id_column_name: ID
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.max_comment_length: 0
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_entity_automatically: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.hibernate_mapping_file: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_foreign_key_name: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.id_feature_as_primary_key: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.runtime.update_schema: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.strategy: lowercase
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_map_list_as_bag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateTimeType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_column_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_proxy: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.ignore_eannotations: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.hbm2ddl.auto: update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.inheritance: JOINED
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_feature: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.optimistic_locking: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_all_on_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> initializeDataStore
>>> WARNING: The teneo update schema option is not used anymore for
>>> hibernate, use the hibernate option: hibernate.hbm2ddl.auto
>>>
>>>
>>>
>>> "Martin Taal" wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>>> Hi Xxlu,
>>>> I would need more information then this to comment on why it is slow.
>>>> Here are some relevant questions:
>>>> - what occupies the cpu: the database or java
>>>> - which version of teneo are you using
>>>> - did you turn on hibernate/jpox logging and did you see anything
>>>> special (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>>> - are all the 1000 objects new or is it an update scenario
>>>> - how slow is it, how many seconds does it take
>>>>
>>>> Also the structure of the model matters ofcourse, but a 1000 records
>>>> should not be really take a long time...
>>>>
>>>> gr. Martin
>>>>
>>>> xxlu wrote:
>>>>> Hi,
>>>>> I use Hibernate EMF Resource of Teneo. The Resource have about
>>>>> 1,0000 data. When I save this resource with one of these data is
>>>>> modified, procedure becomes very slow. How solve?
>>>>> Thank you!
>>>>
>>>> --
>>>>
>>>> With Regards, Martin Taal
>>>>
>>>> Springsite/Elver.org
>>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>>> The Netherlands
>>>> Cell: +31 (0)6 288 48 943
>>>> Tel: +31 (0)84 420 2397
>>>> Fax: +31 (0)84 225 9307
>>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>>> Web: www.springsite.com - www.elver.org
>>>
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
Re: [Teneo]HibernateResource save very slowly!!
Thank you, Martin."Martin Taal" wrote:g66f2a$d2o$1 at build dot eclipse dot org...
> Hi Xxlu,
> Can you try the latest *maintenance* build of Teneo? (there have been some
> performance improvements since the build in june)
>
> Let me know if this helps (or not).
>
> gr. Martin
>
>
> xxlu wrote:
>> I try using the following code to save my object,
>> SessionWrapper wrapper = ((HibernateResource)
>> resource).getSessionWrapper();
>> wrapper.beginTransaction();
>> wrapper.saveOrUpdate(object);
>> wrapper.flush();
>> wrapper.commitTransaction();
>> The speed saving is as before very slow.
>>
>>
>> "xxlu" wrote:g661o1$899$1 at build dot eclipse dot org...
>>> Hi Martin Taal,
>>> Thank you for restoration.
>>> The following is pertinent information:
>>> --Java occupies cpu, about 60%
>>> --I am using teneo1.0.0.v200806111928
>>> --10000 objects are all not new, I have revised a data among them
>>> only
>>> --When the data is few(about 100 objects), saving hardly need time.
>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>> seconds.
>>> The following is the log when application start:
>>>
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Creating emf data store and registering it under name: icd
>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>> createRegisterDataStore
>>> INFO: Returning created emf data store, initialize this newly created
>>> data store!
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>> setClassLoaderStrategy
>>> INFO: Class loader strategy set to:
>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
>>> Jul 23, 2008 9:16:58 AM
>>> org.eclipse.emf.teneo.extension.DefaultExtensionManager getExtension
>>> WARNING: The extension: org.eclipse.emf.teneo.PersistenceOptions is
>>> declared as a singleton but this getInstance call passed initialization
>>> parameters so it is not cached, org.eclipse.emf.teneo.PersistenceOptions
>>> log4j:WARN No appenders could be found for logger
>>> (org.hibernate.cfg.Environment).
>>> log4j:WARN Please initialize the log4j system properly.
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: No hibernate cache provider set, using
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> WARNING: For production use please set the ehcache (or other) provider
>>> explicitly and configure it
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> setDefaultProperties
>>> INFO: Hibernate property: hibernate.hbm2ddl.auto not set, setting to
>>> update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.fetch_containment_eagerly: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.password:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.cache.provider_class:
>>> org.hibernate.cache.HashtableCacheProvider
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.version_column: e_version
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.disable_econtainer: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.username: root
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_cache_strategy: NONE
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.sql_name_escape_character: `
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_default_cascade_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_all_lists_as_idbag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.max_sql_name_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_temporal: TIMESTAMP
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.emap_as_true_map: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.default_varchar_length: -1
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_column: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.also_map_as_class: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.add_index_for_fk: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.java_class_entity_names: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_table_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.XSDDateClass:
>>> javax.xml.datatype.XMLGregorianCalendar
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_version: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.idbag_id_column_name: ID
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.max_comment_length: 0
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_entity_automatically: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.hibernate_mapping_file: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_foreign_key_name: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_containment: ALL
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.id_feature_as_primary_key: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.set_generated_value_on_id_feature: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.driver_class: com.mysql.jdbc.Driver
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.runtime.update_schema: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.strategy: lowercase
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.always_map_list_as_bag: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.connection.url: jdbc:mysql://127.0.0.1:3306/icd
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.dialect: org.hibernate.dialect.MySQLInnoDBDialect
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateTimeType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.join_column_naming_strategy: unique
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.set_proxy: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.UserDateType:
>>> org.eclipse.emf.teneo.hibernate.mapping.XSDDate
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_policy_on_non_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.ignore_eannotations: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: hibernate.hbm2ddl.auto: update
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.inheritance: JOINED
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.naming.default_id_feature: e_id
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.map_embeddable_as_embedded: false
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.optimistic_locking: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.join_table_for_non_contained_associations: true
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> logProperties
>>> INFO: teneo.mapping.cascade_all_on_containment:
>>> Jul 23, 2008 9:16:59 AM org.eclipse.emf.teneo.hibernate.HbDataStore
>>> initializeDataStore
>>> WARNING: The teneo update schema option is not used anymore for
>>> hibernate, use the hibernate option: hibernate.hbm2ddl.auto
>>>
>>>
>>>
>>> "Martin Taal" wrote:g654hh$ehe$1 at build dot eclipse dot org...
>>>> Hi Xxlu,
>>>> I would need more information then this to comment on why it is slow.
>>>> Here are some relevant questions:
>>>> - what occupies the cpu: the database or java
>>>> - which version of teneo are you using
>>>> - did you turn on hibernate/jpox logging and did you see anything
>>>> special (http://www.elver.org/hibernate/troubleshooting.html#runtime)
>>>> - are all the 1000 objects new or is it an update scenario
>>>> - how slow is it, how many seconds does it take
>>>>
>>>> Also the structure of the model matters ofcourse, but a 1000 records
>>>> should not be really take a long time...
>>>>
>>>> gr. Martin
>>>>
>>>> xxlu wrote:
>>>>> Hi,
>>>>> I use Hibernate EMF Resource of Teneo. The Resource have about
>>>>> 1,0000 data. When I save this resource with one of these data is
>>>>> modified, procedure becomes very slow. How solve?
>>>>> Thank you!
>>>>
>>>> --
>>>>
>>>> With Regards, Martin Taal
>>>>
>>>> Springsite/Elver.org
>>>> Office: Hardwareweg 4, 3821 BV Amersfoort
>>>> Postal: Nassaulaan 7, 3941 EC Doorn
>>>> The Netherlands
>>>> Cell: +31 (0)6 288 48 943
>>>> Tel: +31 (0)84 420 2397
>>>> Fax: +31 (0)84 225 9307
>>>> Mail: mtaal at springsite dot com - mtaal at elver dot org
>>>> Web: www.springsite.com - www.elver.org
>>>
>>
>>
>
>
> --
>
> With Regards, Martin Taal
>
> Springsite/Elver.org
> Office: Hardwareweg 4, 3821 BV Amersfoort
> Postal: Nassaulaan 7, 3941 EC Doorn
> The Netherlands
> Cell: +31 (0)6 288 48 943
> Tel: +31 (0)84 420 2397
> Fax: +31 (0)84 225 9307
> Mail: mtaal at springsite dot com - mtaal at elver dot org
> Web: www.springsite.com - www.elver.org
Re: [Teneo]HibernateResource save very slowly!!
Hi Xxlu,On other thing you can also try is to set this hibernate option:
hibernate.jdbc.batch_size to a value between 10 and 50
gr. Martin
xxlu wrote:
> Thank you, Martin.
>
>
> "Martin Taal" wrote:g66f2a$d2o$1 at build dot eclipse dot org...
>> Hi Xxlu,
>> Can you try the latest *maintenance* build of Teneo? (there have been some
>> performance improvements since the build in june)
>>
>> Let me know if this helps (or not).
>>
>> gr. Martin
>>
>>
>> xxlu wrote:
>>> I try using the following code to save my object,
>>> SessionWrapper wrapper = ((HibernateResource)
>>> resource).getSessionWrapper();
>>> wrapper.beginTransaction();
>>> wrapper.saveOrUpdate(object);
>>> wrapper.flush();
>>> wrapper.commitTransaction();
>>> The speed saving is as before very slow.
>>>
>>>
>>> "xxlu" wrote:g661o1$899$1 at build dot eclipse dot org...
>>>> Hi Martin Taal,
>>>> Thank you for restoration.
>>>> The following is pertinent information:
>>>> --Java occupies cpu, about 60%
>>>> --I am using teneo1.0.0.v200806111928
>>>> --10000 objects are all not new, I have revised a data among them
>>>> only
>>>> --When the data is few(about 100 objects), saving hardly need time.
>>>> When the data amount is big( 10000 objects), saving use exceeding 10
>>>> seconds.
>>>> The following is the log when application start:
>>>>
>>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>>> createRegisterDataStore
>>>> INFO: Creating emf data store and registering it under name: icd
>>>> Jul 23, 2008 9:16:58 AM org.eclipse.emf.teneo.hibernate.HbHelper
>>>> createRegisterDataStore
>>>> INFO: Returning created emf data store, initialize this newly created
>>>> data store!
>>>> Jul 23, 2008 9:16:58 AM
>>>> org.eclipse.emf.teneo.classloader.ClassLoaderResolver
>>>> setClassLoaderStrategy
>>>> INFO: Class loader strategy set to:
>>>> org.eclipse.emf.teneo.classloader.ContextClassLoaderStrategy
<