Example:
Displaying 1 to 50 of 67.614 items (filtered from 671.531.669 total entries)
I want to avoid the calculate of 671.531.669, it is the “select count(*) from table;” without conditions. When I define de getTotalItems only I change de 67.614, it isn`t the solution.
It is No solution, I need avoid de count() from all table ( from 671,531,669 total records) no from filtered rows. The count() is from all table always , I have put a $crud->where([‘transitos.matricula like ?’=>‘8068%’]); and it shows the total from de table.
My postgresql table has 600 millions (at the future 2000 M) rows y the rdbms spends 67 seconds on the count(*). It doesn`t read the datum from db dictionary as mysql. Thank (gracias) for the solution.
BR (Saludos)
I have trucated the field to ‘second’ and change de type to timestramp without tz and its works. Thank
I have a field defined as timestamp in postgresql (fecha timestamp without time zone). If I don’t define the field , it shows it to me as “2024-03-03 13:31:25.052+01” if I put $crud->fieldType(‘fecha’, ‘datetime’); He makes it blank for me. How is a postgres timestamp field defined in grocerycrud?
I have a very large data table. How can I stop it from doing the total count?
pe Showing 1 to 25 of 63,087 records (filtering from 671,531,669 total records). This wastes a lot of time. Thanks.
Has this actually been tested for Postgres? Errors that are visible to the naked eye:
It does not maintain the order of the columns even if you use the function $crud->columns.
The column that is table PK in the tabular view disappears.
The $crud->fieldType(‘vparam’, ‘password’) function does n…
This is my program:
$crud = new GroceryCrud();
$crud->setLanguage('Spanish');
$crud->setTheme('bootstrap-v4');
$crud->setSubject('Mesas');
$crud->setTable('Mesa');
$crud->columns(['NMesa', 'Capacidad', 'Descripcion']);
$crud->setActionButton('Listado', 'el el-file',…