[Performance] Ticket search takes ~5 seconds in large projects
Problem
In projects with more than 10,000 tickets, every search on the ticket list takes around 5 seconds. The query scans all tickets on each keystroke, and users wait or give up.
Solution
Add a full-text index on ticket title and description, debounce search input by 300 ms and paginate results to 50 per page.
Impact
Search results under 300 ms for large projects, far less database load during peak hours, and the most-used screen no longer feels broken.