| Index
» Projects
» phpMyEdit
» Bug list
» Bug #522 |
 |
|
Viewing Bug Advanced Details |
[ Jump to Bugnotes ]
[ Bug History ]
[ Print ]
|
|
ID |
Category |
Severity |
Reproducibility |
Date Submitted |
Last Update |
|
0000522 |
core / general |
major |
always |
2008-04-09 02:32 |
2008-04-09 02:32 |
|
|
|
Reporter |
Icehawg |
View Status |
public |
|
|
Assigned To |
|
|
Priority |
normal |
Resolution |
open |
Platform |
Apache |
|
Status |
new |
Duplicate ID |
|
OS |
Windows and RHEL |
|
Projection |
none |
|
Version |
XP and 7 |
|
ETA |
none |
|
Product Version |
5.7.1 (stable) |
|
|
Product Build |
|
|
|
Votes |
1 |
|
|
|
Summary |
130+ queries for empty table |
|
Description |
Seems like extremely excessive querying going on. With an fresh, empty, table there is 131 queries to the database on the list view. 131! For an empty table. Adding one row(9 columns) to the database adds another 18 DB queries. Adding another adds another 18 queries. It seems to add !!2!! queries per field. Per FIELD! That seems like a substantial amount of resource-waste. Not a bug, exactly, but optimization is a necessity. |
|
Steps To Reproduce |
Create a table and log queries. |
|
Additional Information / Solution |
A query to retrieve the necessary data and another to grab the field types should be sufficient. Double querying for every single cell is not efficient. |
|
Attached Files |
|
|
|
|
There are no notes attached to this bug. |
|
Bug History |
|
Date Modified |
Username |
Field |
Change |
|
2008-04-09 02:32 |
Icehawg |
New Bug |
|
|
|
Login
Registration
Slovak
