Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

After partitioning, it runs slower

548150Jul 17 2009 — edited Jul 20 2009
After partitioning, it runs slower. Why?

I have an application job running on the Oracle 11g database with Windows 2003 server environment.
Because of the bad performance, I make a diagnosis and find the Sequential Read Wait event is the main root cause. This event always related with the hot object issue or the I/O problems. In order to spread all the data around multi-segments, I partition all the large tables and its indexes (using the LOCAL option). But unexpected result comes out. The performance get worse.

Counld you tell me why?

Comments

Jorge Rimblas

Hi Tony,

I think you can do a selector like ".pagination a" if you only have pagination links and ".pagination select" if you have a drop down.

Personally I would probably save to the collection on field changes.  I think it would be a tad easier and better performance even though there would be a lot of chatter back and forth.

Thanks

-Jorge

TexasApexDeveloper

Jorge,

  Glad to hear from you... In regards to this, I coded up a simple dynamic action to try and display an alert when the tabular form pagination control is clicked...

Event: Click

Selection Type: jQuery Selector

jQuery Selector: $(".pagination select")

Alert does not fire....

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

Jorge Rimblas
Answer

Tony, couple of things.

Since you used a Dynamic action the jQuery Selector should simply be:

.pagination select

Because the $() will be added by the DA.

Also, for the anchors/links you need a click, but for the select you need a "Change" event I think.

Thanks

-Jorge

PS.  if it still doesn't fire... then make sure your template is adding all the pagination stuff with a class of pagination.  It could be using something different.

Marked as Answer by TexasApexDeveloper · Sep 27 2020
TexasApexDeveloper

Changed the selector, and it does allow me to attach to the click..

I MIGHT have lucked out since the client LOVES Excel, they might want to just display all rows instead of doing pagination, depends on the # of rows...

I am REALLY looking forward to APEX 5.1 now....

Thank you,

Tony Miller
LuvMuffin Software
Ruckersville, VA

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 17 2009
Added on Jul 17 2009
#general-database-discussions, #index
16 comments
6,381 views