On Fri, May 3, 2013 at 7:53 AM, Mathieu Saby <[email protected]> wrote: > Galen Charlton a écrit : > Maybe the problem is the way some subs are written, getting all the columns > of biblio and biblioitems ? > If they do not contain SELECT * but SELECT a,b,c,d..., is it necessary to > put marcxml in an other table ? > > I know quite nothing in SQL, so excuse me if it is a bad question...
No, that's a good question. Specifying only the columns needed for a given query does indeed reduce the amount of data that gets moved around. On the other hand, there are a few core queries that need everything from biblio and biblioitems *except* the marcxml, so for those cases writing "SELECT *" is easier than having to update the query every time a column is added. Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: [email protected] direct: +1 770-709-5581 cell: +1 404-984-4366 skype: gmcharlt web: http://www.esilibrary.com/ Supporting Koha and Evergreen: http://koha-community.org & http://evergreen-ils.org _______________________________________________ Koha-devel mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
