Database Input/output Bottleneck

, , ,
1

Hi ALL

I am new to webMethods, we have performance issues with database the saleroom is as follows.

1. We have flow services which inserts and retrieve the data from database (we use ERP Adapter for that).
2. The flow processes large number of transactions per day and processing becomes slow because during the process there is a need to retrieve data from single table which has large number of rows.
3. The database Input/output becomes a bottleneck during all the normal process also.
4. Could any of you guide me on this to improve the process?

Thanks in advance
Sree

2

Reduce the number of rows in the table mentioned in step 2.

Add appropriate indexes that can speed the queries.

Which “ERP Adapter” are you using?

3

Thanks a lot reamon,

we are using JD-Edwards EnterpriseOne Adapter.

Thanks
Sreekanth