mysql query efficiency

skap

New member
Hey,

is there a reason why always the complete table is queried for result view even if only a few columns will be shown?
It seems to me that on each change (next page, change to details view , etc) the table is re-queried from the mysql server anyway.

That is important for me because some tables consists of > 5 foreign key relations on a few million of items, so this has massive impact on performance.

Best
skap
 

eugenio

Administrator
Staff member
There isn't any particular reason; I think that you could hack the code to let DaDaBIK select just the field you need.
 
Top