In order to have more realistic performance tests I created a lot of employees (200000) using the following database procedure:
create or replace
PROCEDURE CREATE_EMPLOYEES AS
FOR i IN 1..200000 LOOP
Insert into employees (employee_id,
select employees_seq.nextval as employee_id,
'auto' i as last_name,
'aut' i '@gmail.com' as email,
sysdate as hire_date,
'IT_PROG' as job_id
So I tested Range Paging and I actually saw the difference in query page, while scrolling down the results of query criteria.
Then I go to Edit page and I press Last button. Then I get this error:
oracle.jbo.InvalidOperException: JBO-25084: Cannot call last() on row set EmployeesView1 because the access mode uses range-paging
I guess since its a jbo exception it is not a bug?
Or is better to use diferent view object for query and for edit?