07-27-2023, 12:00 AM
I'm building an autocomplete feature for an input box which is similar to Google's Instant Search.
I need to have an _instant_ response for the autocomplete feature. The table I'm executing the query with the term in it has hundreds of thousands of records and more that a hundred of columns. For example: 500,000 records, 120 columns.
So, I have two issues:
1. Executing a query with the most possible speed.
2. Fast response on showing the result in search box's auto complete drop down.
By the way, I'm using the Joomla framework which might cause some slow down, too.
I need to have an _instant_ response for the autocomplete feature. The table I'm executing the query with the term in it has hundreds of thousands of records and more that a hundred of columns. For example: 500,000 records, 120 columns.
So, I have two issues:
1. Executing a query with the most possible speed.
2. Fast response on showing the result in search box's auto complete drop down.
By the way, I'm using the Joomla framework which might cause some slow down, too.