search

nbuytaert1 / apex-select2

Select lists in Oracle APEX as they should be
https://apex.oracle.com/pls/apex/f?p=64237:20
GNU General Public License v2.0
56 stars 18 forks source link

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

Open abha3011 opened 4 years ago

abha3011 commented 4 years ago

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).

Media1

Regards, Abha

rimblas commented 4 years ago

Have you tried the Lazy Loading option?

abha3011 commented 4 years ago

Have you tried the Lazy Loading option?

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

rimblas commented 4 years ago

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 commented 4 years ago

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 commented 4 years ago

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