Joe, are you suggesting that merging the tables will not be worth the effort? I guess it really isn't going much of a performance hit to add an extra table join to queries since it's 1-1 and indexed. Perhaps the time spent on this would be better spent on ORM ? The only benefit that this has if it's behind an ORM is potentially making direct sql reporting easier and peace of mind that the table structure is more sane than it used to be.
So is the performance difference negligible in keeping two tables ? If so, perhaps just removing the extra columns and fixing duplicated column names like 'notes' would be sufficient, and we can put off the merge until after the ORM is in place. My reasoning for doing the merge first was to clean up before I had to touch some of these queries for some work I'm looking at that won't wait until after the ORM changes are in place. But I'd rather put time in where it's most valuable short-term. Comments ? Ryan On Tue, Nov 25, 2008 at 12:43 PM, Joe Atzberger <[EMAIL PROTECTED]> wrote: > Or we have the option of not caring at all once an ORM is in place! > --joe > > > On Tue, Nov 25, 2008 at 7:23 AM, Galen Charlton < > [EMAIL PROTECTED]> wrote: > >> Hi, >> >> On Tue, Nov 25, 2008 at 4:24 AM, Paul POULAIN <[EMAIL PROTECTED]> >> wrote: >> > In fact I don't care. But atm we have some tables plural, and some >> > singular. and for sure, that's a pity ! >> > I'm for a unique rule ! >> > and there are more plural than singular, so that would be easier to >> > switch to plural I think. >> >> Roughly speaking, 70% of the table names have plural names and 30% >> singular. Although it would be nice to pick a convention and change >> all table names to match, I'm not in favor of renaming biblio to >> biblios at this point due to the number of queries on that table that >> would have to be changed and the risk of adding bugs. We'll be better >> able to make such name changes once an ORM is in place. >> >> Regards, >> >> Galen >> -- >> Galen Charlton >> VP, Research & Development, LibLime >> [EMAIL PROTECTED] >> p: 1-888-564-2457 x709 >> skype: gmcharlt >> _______________________________________________ >> Koha-devel mailing list >> Koha-devel@lists.koha.org >> http://lists.koha.org/mailman/listinfo/koha-devel >> > > > _______________________________________________ > Koha-devel mailing list > Koha-devel@lists.koha.org > http://lists.koha.org/mailman/listinfo/koha-devel > > -- Ryan Higgins LibLime * Open-Source Solutions for Libraries Featuring KohaZOOM ILS 888-564-2457 x704
_______________________________________________ Koha-devel mailing list Koha-devel@lists.koha.org http://lists.koha.org/mailman/listinfo/koha-devel
