Hi, we encountered problem with custom field with lot of data. Lot of data in this case is 200000 rows. This is supposed to be list of all customers.Data was inserted directly into database.
Problem is when trying to do a serch (Search-->Tickets-->New search). After selecting Queue in Query builder and clicking button "Add these terms" it takes around 45 second to add queue to search list and show custom fields for this queue. Time required to load page is linear with quantity of rows in database. >From logs we can see that rt is executing SQL: SELECT main.* FROM CustomFieldValues main WHERE (main.CustomField = 3) ORDER BY main.SortOrder ASC, main.Name ASC, main.id ASC; >From terminal SQL execution is under 2s but loading data into terminal takes more or less same time as loading page. I'd assume that it's not really necessary to this load since on ticket create/edit page it works perfectly (page loads, autocomplete works perfectly) and it doesn't do any preload of values (doesn't execute problematic SQL as on search) Also editing this CF is not possible since it never loads all data into browser (firefox goes over 4Gb of ram and crashes). Does anyone have some solution to this problem or some workaround? Thanks, Sandi -- View this message in context: http://requesttracker.8502.n7.nabble.com/Large-autocomplete-custom-filed-long-loading-on-search-tp61732.html Sent from the Request Tracker - User mailing list archive at Nabble.com. --------- RT 4.4 and RTIR Training Sessions https://bestpractical.com/training * Washington DC - May 23 & 24, 2016