1. SHAMEEM KAKKAD
  2. PowerBuilder
  3. Monday, 11 September 2023 05:52 AM UTC

Hi,

I am using PB 2022 R2 2819. It's Auto filtering facility is very useful and tremendous. First of all Thanks for this. This facility have any data limitation ?.

Bcz, It is perfectly worked for about 20000 item in the dropdown and feeling too slow for about 100000 items in the dropdown.

for the large item listing any other additional settings ?.

Accepted Answer
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Monday, 11 September 2023 15:43 PM UTC
  2. PowerBuilder
  3. # Permalink

Hi Shameem;

  Don't forget in that extreme filtering process that you can do this yourself in the edit changed event and do your own binary searching & buffer filtering under PowerScript. I'm sure that you could optimize this processing much better than the built-in filter feature.

Regards ... Chris 

Comment
There are no comments made yet.
Miguel Leeuwe Accepted Answer Pending Moderation
  1. Monday, 11 September 2023 16:18 PM UTC
  2. PowerBuilder
  3. # 1

Let me guess,

your application runs as 32 bits?

most likely your running out of ram memory while trying to display 100000 row in a dddw.

you should consider redesigning your interface.

regards

Comment
  1. Kevin Ridley
  2. Monday, 11 September 2023 21:27 PM UTC
I agree with Miguel. If you have 20,000 items in your dropdown, you might want to consider a different design/approach.
  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.
We use cookies which are necessary for the proper functioning of our websites. We also use cookies to analyze our traffic, improve your experience and provide social media features. If you continue to use this site, you consent to our use of cookies.