DaDaBIK
This forum is devoted to the discussion about the software DaDaBIK database front-end
the PHP Database application generator for MySQL, PostgreSQL and SQLite; also available for Wordpress.

mysql query efficiency
November 11, 2010 02:21PM
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
Re: mysql query efficiency
November 11, 2010 04:38PM
There isn't any particular reason; I think that you could hack the code to let DaDaBIK select just the field you need.

________________________________________________________
Eugenio |\.-./| DaDaBIK developer and project admin
Sorry, only registered users may post in this forum.

Click here to login