PDA

View Full Version : loading more than 2100 records in combo box



faisal abbas
8 Mar 2009, 9:09 PM
hello every one!
i want to know is there any record limit in combo box or in store because i am populating my combo from a PHP file. it is loading successfully but when records exceeds 2085 it doesn't load combo box. if i add limit in my query to return me maximum 2085 record then it loads the combo success fully.

faisal abbas
8 Mar 2009, 11:38 PM
there is not any solution for this?

dlbjr
9 Mar 2009, 4:38 AM
I have some with over 2,400 working fine. I have a combobox with over 2400 employee names listed in it and it works fine. I pre load the store when the app is first loaded. Then when any form is opened requiring the data for a combobox, it is already cached to the client and loads instantly. This also reduces the calls to the server because the data is loaded once and used many times. I also have a scheduled job on the server that hits the database once an hour and precreates the json string on the server to be called by the client.




var cb_Owner = new Ext.form.ComboBox({
store: ds_Assoc,
mode: 'local',
displayField: 'assoc',
valueField: 'ao',
triggerAction: 'all',
fieldLabel: 'Assigned To',
name: 'assignedto',
width: 325,
typeAhead: true,
selectOnFocus: true,
forceSelection: true,
disabled: false
});

Animal
9 Mar 2009, 4:47 AM
First of all, what is the use of a 2000 element list?

Why not use server-side paging?