Hi,
For the last few hours, I've been working on appending a newly created table's details to the list of tables we see on db_structure.php. I have been able to generate most of the HTML necessary for this in tbl_create.php, but I have not understood how the table size and overhead are calculated. Even though it's a new table and has zero rows, it would occupy some space, and it should not have any overhead.
I tried understanding the code in db_structure.php that generates the HTML, but I'm slightly lost. Pointers anyone?
I've pushed my changes in commit 10a9e69, so everyone can see the stage I am at. At the moment, I'm filling in a dummy value for the size column, and leaving overhead as '-'.
Ninad Pundalik a écrit :
Hi,
For the last few hours, I've been working on appending a newly created table's details to the list of tables we see on db_structure.php. I have been able to generate most of the HTML necessary for this in tbl_create.php, but I have not understood how the table size and overhead are calculated. Even though it's a new table and has zero rows, it would occupy some space, and it should not have any overhead.
I tried understanding the code in db_structure.php that generates the HTML, but I'm slightly lost. Pointers anyone?
It calls libraries/db_info.inc.php which retrieves information about the tables to be displayed on this page.
I've pushed my changes in commit 10a9e69, so everyone can see the stage I am at. At the moment, I'm filling in a dummy value for the size column, and leaving overhead as '-'.
On 14/07/2010, Marc Delisle marc@infomarc.info wrote:
It calls libraries/db_info.inc.php which retrieves information about the tables to be displayed on this page.
Thanx! Found it. I'll add the query for that table in the code and collect statistics from the result. :)
P.S.: I'm sorry for the double post yesterday. The net connection had dropped off and I couldn't see the mail in my sent folder, so resent it.
-
Marc Delisle -
Ninad Pundalik