[Koha-devel] RFC: Koha : Merge biblio & biblioitems tables

[Ryan Higgins]

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 <ohiocore at gmail.com> 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 <
> galen.charlton at liblime.com> wrote:
>
>> Hi,
>>
>> On Tue, Nov 25, 2008 at 4:24 AM, Paul POULAIN <paul.poulain at free.fr>
>> 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
>> galen.charlton at liblime.com
>> p: 1-888-564-2457 x709
>> skype: gmcharlt
>> _______________________________________________
>> Koha-devel mailing list
>> Koha-devel at lists.koha.org
>> http://lists.koha.org/mailman/listinfo/koha-devel
>>
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at 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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: </pipermail/koha-devel/attachments/20081125/ee5f2714/attachment-0003.htm>