User search slow for new ticket

Impro

Hi again,

My OsTicket DB has about 5500 users (imported via CSV). When an agent creates a new ticket, they are prompted to search for a user to create the ticket for. The search is taking a very long time to return a result - approx 1 minute. This makes opening a new ticket a slow and painful process, and I can't expect agents to use it in the current state.

I have checked the ost__search table and there are records for the users there.

Should OsTicket be OK with this amount of users? Why is the search so slow?

Environment details:

Disclaimer: This is not a production system... yet.

ramrajone

Impro
you are using the RC version of osTicket if this is production system you should be using Stable version 1.10.4

ntozier

First let me say that I do not use 1.11rc1. I am running 1.10.4 and my biggest production site only has about 1000 users currently.

It takes under 3 seconds for me to search for a user and add them. I generally only type the first 4 characters of their name/email in.

Since you are running a Release Candidate (rc1) I would recommend that you pull a copy of the develop-next repo at github and run that. There has been a lot of activity and bug fixes made for rc2 and its possible that this has already been addressed. Or not run a buggy RC and run the stable. Preferably running stable until 1.11 is released.

Impro

ntozier I'm going to import the same people on a vanilla 1.10.4 install. Results forthcoming soon.

Impro

Imported into a vanilla 1.10.4 and it's fast. Upgraded my test environment to the develop-next build from github. Still slow.

I think I must have broken something in the database. I have had to resort to inserting organizations (no CSV import) via a SQL script in to the DB, so that probably has something to do with it. I will at some point import all users to a vanilla 1.11.0 build and test again.