Level 122
different database?
Feb 2, 2022
16
Level 3
Number of records in database and count() is different [ SOLVED ]
In my database there is this: (68427 total, The query took 0.0006 seconds.)
That is, there are 68,427 records
But when I call pagination or even Table::all()->count()
The result is 76,523
by the inclusion id I can't trust as many have been erased over time. Last ID is 70,917
by pagination the result checks, but my finger bank shows a value below what it really should have
Why does this difference occur?
Level 3
no, it's all in the same database in the "Books" table. The only
Level 39
Compare the 2 raw queries.
1 like
Level 3
I don't know if I'm doing it right, but it didn't bring me any useful information
Level 3
select * from `livros` where `id` > 0
Executing this command in the database and the result was the same as for pagination and count(), that is: 0 - 24 (76523 total, A consulta demorou 0.0106 segundos.)
Level 39
So where come your first number 68,427 ? This should be wrong ...
1 like
Level 3
when I open the database, this value already appears, and the paging number of the database, if I add it up, it matches the number that it is displaying. However, I have just noticed that the paging of the database is not continuous. Look: https://imgur.com/TuQOwsj
when I open the database, this value already appears, and the paging number of the database, if I add it up, it matches the number that it is displaying. However, I have just noticed that the paging of the database is not continuous. Look:
But when I consult the pagination, it doesn't seem to have any errors, they show all
Level 39
"when I open the database," .... which tool are you using?
can you run queries directly in the db?
select count(*) from livros;
1 like
Level 3
Level 39
So Laravel and your db are the same 76523
1 like
Level 3
yes, but it's weird that the database shows less than the actual value. Why is this happening?
Level 39
It's not the database, it's the tool you are using and I don't know it. (Personally I nexer use such tool, Laravel and direct cde in the db)
Level 122
@mvnobrega because its an approximation
See the note in the explanation under information schema
1 like
Level 3
I just found this topic:
It seems to me to make sense from what I'm noticing here
Level 39
can be an explanation and confirm why it's better to use right query in the db.
1 like
Please or to participate in this conversation.