|
phpMyEdit - Viewing Bug Advanced Details |
[ Go Back ]
|
|
|
ID:
|
Category:
|
Severity:
|
Reproducibility:
|
Date Submitted:
|
Last Update:
|
|
524 |
core / general |
major |
always |
2008-04-09 02:33 |
2008-04-09 02:33 |
|
|
Reporter:
|
Icehawg |
Platform:
|
Apache |
|
|
Assigned To:
|
|
OS:
|
Windows and RHEL |
|
|
Priority:
|
normal |
Version:
|
XP and 7 |
|
|
Status:
|
new |
Product Version:
|
5.7.1 (stable) |
|
|
Product Build:
|
|
Resolution:
|
open |
|
|
Projection:
|
none |
Duplicate ID:
|
|
|
|
ETA:
|
none |
|
|
|
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. |
|
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:
|
|