How to handle a table with 19k+ Elements

First of all make sure you have indexes on the searchable columns.

To display the data might datatables be an option? Or you can chunk your data?

Thanks @MThomas,

I need it for a delivery system and they have to choose an adress i used the select ui plugin atm to have a searchable interface. But the new database i received... has to many elements for the page to load in a fast way. I already thought of taking it onto another page... but then i have to rewrite the whole page.

is it somehow possible to have my app somehow put out the actual list like an API and when you enter a letter/word it automatically redoes a new search and calls the api?

In this cases I would use Elasticsearch and/or Redis. With a large dataset like yours making an autocomplete input "old-style" (by querying directly the database) might be a bit slow.

@Ionut do you have any tutorial at hand for the integration or so?

Here are a few links:

Ben Corlett - Discovering ElasticSearch at Laracon EU 2014

elasticsearch: the definitive guide

Laravel packages:

Elasticquent <-- better go with this one

Elasticsearch for Laravel 4

Setup an Elasticsearch server and use one of these packages. IT should work out of the box.

thanks man!

@Houbsi I've updated my reply. The links weren't formatted as I expected :D

Anyway, you are welcome. Hope it helps you.

I had to deal with this. The problem was not selecting data with eloquent but displaying the table. A 20k row html table is too much for the browser.

I ended up doing a custom javascript that display only 20 rows of the table that get refreshed when the user scrolls.

Edit : hum ok you were talking about your database table not an html table :D. 20k rows should be absolutely no problem to search. No need for elasticsearch.

Yeah should of put the title as "How to handle searching within a 19k database table" :P