Author |
Message
|
thomeck |
Posted: Thu Apr 27, 2006 2:37 am Post subject: tuning JDBC-Connector |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hi,
my JDBC-Connector needs 2 seconds for a insert statement.
Here my config:
ApplicationPassword XX
ArchiveProcessed False
ArchiveTableName xworlds_archive_events
AutoCommit False
CheckForEventTableInInit False
ChildUpdatePhyDelete False
CloseDBConnection False
ConnectorID null
DatabaseURL jdbc:ibm-crossworlds:sqlserver: XXX
DateFormat yyyyMMddHHmmss
DriverConnectionProperties
MaximumDatabaseConnections 5
PingQuery SELECT 1 FROM table
PollQuantity 0
PreserveUIDSeq True
QueryTimeOut False
RDBMS.initsession
RDBMSVendor MSSQLServer
RetryCountAndInterval 3,20
ReturnDummyBOForSP False
SchemaName
UniqueIDTableName xworlds_uid
UseDefaults True
UseDefaultsForCreatingChildBOs False
UseDefaultsWhenPolling True
UseDefaultsForRetrieve False
DriverSupportForLong True
EventKeyDel ;
EventOrderBy none
EventQueryType Fixed
EventTableName null
JDBCDriverClass com.ibm.crossworlds.jdbc.sqlserver.SQLServerDriver
ApplicationUserName XXXX
SelectiveCommitForPoll False
TimingStats 0
The ASBO is also very small it has only 20 Attributes.
The database is also able to process more data.
How can I tune this Connector?? |
|
Back to top |
|
 |
Kram |
Posted: Thu Apr 27, 2006 5:41 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006 Posts: 87
|
Can you tell me whats the value for ConcurrentEventTriggeredFlows - In Standard Properties. _________________ Regards,
Ram |
|
Back to top |
|
 |
thomeck |
Posted: Fri Apr 28, 2006 12:16 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hi
And the max number of current events is 1 because we need fifo. |
|
Back to top |
|
 |
Kram |
Posted: Fri Apr 28, 2006 6:25 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006 Posts: 87
|
If you have event sequencing true and increase the ConcurrentEventTriggeredFlows to 5 .. i dont think it should be a problem and also try increasing the number of concurrent events in the collaboration.... _________________ Regards,
Ram |
|
Back to top |
|
 |
thomeck |
Posted: Fri Apr 28, 2006 7:17 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hi,
where can I set the value for event sequencing?
I don't thik that it is a collabortion-problem.
To insert a record in a database could not take 2 seconds.  |
|
Back to top |
|
 |
Kram |
Posted: Fri Apr 28, 2006 7:55 am Post subject: |
|
|
Voyager
Joined: 02 Mar 2006 Posts: 87
|
There is a ControllerEventSequencing in the standard propertoes...
i dont know why it takes 2 seconds but by increasing the number of DB connections and ConcurrentEventTriggered flows and the Number of concurrent events in the collab you can multiply the number of recors you are trying to insert... _________________ Regards,
Ram |
|
Back to top |
|
 |
thomeck |
Posted: Fri Apr 28, 2006 8:07 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hey thanks,
so I will test it on tuesday!!! Have a nice weekend |
|
Back to top |
|
 |
thomeck |
Posted: Wed May 03, 2006 5:59 am Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hi,
so the test was not successul.
The problem is, that the JDBC-Connector has to proccess the events in a fifo sequence. And for each event he do a select and an update each takes 2 seconds and as result 4 seconds per event.
Can anyone tell me why the connector needs 2 seconds?  |
|
Back to top |
|
 |
Mirage |
Posted: Wed May 03, 2006 8:08 am Post subject: |
|
|
 Apprentice
Joined: 30 Nov 2004 Posts: 44 Location: IL
|
Can you quickly try to insert the same data using a Java program and see how long is it taking ?. Just to check whether the problem is in the Adapter or on the DB.
Database indexing helps a lot in reducing the time. Check the select statement and see if you can index the key fileds. |
|
Back to top |
|
 |
thomeck |
Posted: Wed May 03, 2006 10:41 pm Post subject: |
|
|
Apprentice
Joined: 07 Apr 2006 Posts: 30 Location: Germany
|
Hi Mirage,
thanks for this tip!
My simple insert-statement takes also nearly 2 seconds!
So we have to tune the database! |
|
Back to top |
|
 |
|