R
raddanki
Guest
Let me answer the first part. Table partition becomes advantageous with huge amount of data. EX: If you 10 millions of rows in a table which is partitioned and looking for a set records, then data retrieval happens in less time comparatively as the search for that record happens in particular partition(expecting that query is based on partition key column). So, OLTP operations are expected to gain performance. From: Stefan Bolte [ mailto:bounce-stefan@community.progress.com ] Sent: 20 May 2014 PM 05:58 To: IF.OE.DB@community.progress.com Subject: OE 11.4 Horizontal Table Partitioning: Which performance improvements to expect? OE 11.4 Horizontal Table Partitioning: Which performance improvements to expect? Thread created by Stefan Bolte We try to find Pilot customers for OE 11.4 Horizontal Table Partitioning. I wonder which improvments / benefits to expect application user's experience doing every day OLTP work? running a report? administrator's experience daily administrative tasks like backups, nightly import/export of data on-demand tasks like index rebuild, reclaim disk space, etc. My current understanding is: Common application users will not see big improvements, administrators will see benefits when doing e. g. index rebuilds which complete faster than before. Would you add other expectations? - Stefan Stop receiving emails on this subject. Flag this post as spam/abuse.
Continue reading...
Continue reading...