[rt-users] Large autocomplete custom filed long loading on search

[sandik]

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.