search

sapioit / phpliteadmin

Automatically exported from code.google.com/p/phpliteadmin
1 stars 0 forks source link

Explain ? as number of rows #226

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
What steps will reproduce the problem?
1.
2.
3.

What is the expected output? What do you see instead?

What version of the product are you using? On what operating system? Which
Database Extension (PDO/SQLiteDatabase/SQLiteDatabase3 - see Database
structure-tab in phpLiteAdmin)?

Please provide any additional information below.

Original issue reported on code.google.com by nanozer...@gmail.com on 30 Aug 2013 at 2:17

GoogleCodeExporter commented 9 years ago 
Sorry, miscard information :(
The problem it's on the attached image, DB information is
Size of database: 2123 KB
Database last modified: 4:00pm on August 30, 2013 (CEST)
SQLite version: 3.3.7
SQLite extension [?]: PDO
PHP version: 5.2.17

Original comment by nanozer...@gmail.com on 30 Aug 2013 at 2:19

Attachments:

GoogleCodeExporter commented 9 years ago 
Sorry for the very late reply.
The reason for this is that the database is "big" (<=2 MB) and the table does 
not have a primary key assigned to it. In this case, counting the number of 
records is quite slow so we skip it in this case to make phpLiteAdmin respond 
faster.

I would always recommend to give a table a primary key.

I think we should add some explanation why there is a ? and how to solve it. 
And maybe a link to force counting even though it might take long.

Original comment by crazy4ch...@gmail.com on 23 Dec 2013 at 10:45

GoogleCodeExporter commented 9 years ago 
Of course I meant >=2MB, not <=

Original comment by crazy4ch...@gmail.com on 23 Dec 2013 at 10:46

GoogleCodeExporter commented 9 years ago

Original comment by crazy4ch...@gmail.com on 23 Dec 2013 at 11:18

GoogleCodeExporter commented 9 years ago 
This has just been fixed with revision 424.

Original comment by crazy4ch...@gmail.com on 23 Dec 2013 at 11:23

GoogleCodeExporter commented 9 years ago

Original comment by crazy4ch...@gmail.com on 2 Jan 2014 at 4:20