var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
I am having one table say PVTable. Batch process inserting daily 3lakhs records on this table. Locking schema on this table is AllPages Locking.
I am facing performance issue on this table.
Changing locking schema from AllPages to DataPages will help in insert/select performance (or) Partitioning the table will help in insert/select performance.
Could any one help me in this?
Do you have any indexes on this table? If there are no indexes, then partitioning will help. Are you facing locking issues?
1) determine the bottleneck (network ? last pages ? CPU ?)
2) choose the correct resulution (partitioning, index add/remove, more CPU, partitionning, named caches... )
3) using DOL pages, don't forget to apply periodically reorg rebuild
Log in with your username and password
Forgot your password?
Subscribe to dBforums Brief to receive special offers from dBforums partners and sponsors