[Phpmylibrary-users] DB Design, no indexes, normalization.

[Josh S. <st...@it...>]

   First of all, thank you Polerio for the work that you have put into
this project.  
   I just have some questions/suggestions.

   Database design.  Why did you decide to go with the design that you
are using.  Especially the phpmylibraryentries table, Bib info.  I
don't think that it is a very good design, using a table for each marc
tag.  I think I can understand why, it makes it much easier to edit
marc info, but I don't think that is the way it should be stored in
the database.  The marc format was designed for transfereing info
between machines, not for storing in a database.  Also it doesn't
appear that you use any indexes, this probably isn't an issue when you
only have a small amount of data, but what if you had 500,000 marc
records, doing a sequential scan through that can take a couple
minutes. And one more thing, how do you handle all the marc tags that
are repeatable.  
    Here are some links you might want to look at.  
	Database normalization
http://www.phpbuilder.com/columns/barry20000731.php3
	Indexing
http://www.phpbuilder.com/columns/tim20010110.php3

    Also, I would suggest you take a look at postgresql, it is a much
more industrial db, supports foreign key constraints, transactions.  I
learned sql with mysql, but then I moved on to postgres.

   I would like to help out with the project if I can.

Josh Stompro