APEX-Select2 works very slowly if the number of records are more.

[abha3011]

Hello,

I have a apex report with 2 columns which are linked to Select2 plugin. One column returns aroun 1000 rows and another returns around 10000 rows.

The column which returns 1000 rows works fine with this plugin. But it is very slow, for the column that returns 10000 rows.

can you please suggest what I can do to improve the performance.

I have made an application on apex.oracle.com with a very basic screen with just these 2 columns (LESS with 1000 rows and MORE with 10000 rows).

Regards,
Abha

[rimblas]

Have you tried the Lazy Loading option?

[abha3011]

Have you tried the Lazy Loading option?

Yes, I have tried with that alos, but still it is ver slow .

[rimblas]

Then, you'll have to work on the performance of that SQL statement.
This is not a Select2 issue right? 1000 results of anything are not a problem for the Select2

[abha3011]

for testing purposes I have used a very simple and basic query to return 1 to 10000 numbers.

Select Rownum r , rownum d
From dual
Connect By Rownum <= 10000

so, I am pretty sure there is nothing to do with th\e query performance. One more thing that I have noticed is that, Select2 works fine on chrome or mozilla browser , but it is only on IE , that it give performance issue with this query.

[rimblas]

I didn't catch that this was an IE issue. Sorry, I can't help you with that.