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 05:21AM

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.

Re: mysql query efficiency
November 11, 2010 07:38AM
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