This Question is Possibly Answered

1 "correct" answer available (4 pts) 2 "helpful" answers available (2 pts)
1 Replies Last post: Jun 16, 2008 3:47 PM by Dmitry Pikhulya  
Roman Schwienbacher   35 posts since
Jan 16, 2008
Currently Being Moderated

Jun 16, 2008 3:08 PM

q:suggestionField - Problems with large set of items?

 

Hello to everybody,

 

 

I am using the q:suggestionField. I get the dropDownItems by a query out of a database (Strings: f.ex. FirstName out of People) . With 1000 records it works properly, but in reality we have more than 10000!! With 10000 I only get a white page without an error message in the console. I've inserted 10000 records in my local test-database and I've got the same behaviour.

 

 

Is there any possibility to get it working properly with 10000 or is it still not possible??

 

 

 

 

Thank you

 

 

Roman

 

 

Dmitry Pikhulya TeamDev Ltd. 161 posts since
Jan 5, 2007
Currently Being Moderated
1. Jun 16, 2008 3:47 PM in response to: Roman Schwienbacher
Re: q:suggestionField - Problems with large set of items?

Hello Roman,

 

The SuggestionField component provides different suggestion modes -- the client and the server ones. In case of client suggestion modes all of the possible suggestions are preloaded on the client-side when the page is loaded. This may significantly increase page loading time in case of very big lists. Though there's the "custom" suggestion mode where suggestion functionality is made through the server and is fully controlled by the developer. Please see the documentation for details on all suggestion modes.

 

In brief the field that uses the "custom" suggestion mode sends an Ajax request for each text entered by the user, and the code written by the developer composes a list of items those should be shown as a list of suggestions for the entered text. So the "custom" suggestion mode is ideally suitable for working with large amounts of data because you gain the control of the data that actually should be used regardless of the database size.

 

Regards,

Dmitry

More Like This

  • Retrieving data ...