Search-engine schema
Posted by: Jean-Yves Rouffiac
Date: November 07, 2007 08:18AM

For an application that will use MyISAM tables in an almost entirely read-only manner (updates are once a week, offpeak), what would you recommend in the following scenario:

Relatively small number of tables (~20), but quite a complex web of relationships. Should we opt for fully 3rd Form or try to flat-file as much as possible.

There will be a fair number of quite heavy-duty Stored Procedures, making numerous hits on the tables.

Number of records is in the tens of millions.

There are also two conflicting (to my mind) priorities:
1. Speed
2. Maintainablility (of the SPs, Views, triggers etc)

I tend to favour normalised, but am concerned that this may be too much of a hit on what is essentially a lookup system.

I appreciate that this info is very little to go on, but if you have any experience of search engines generally, I would appreciate your thoughts.

Thanks
Jean-Yves



Edited 1 time(s). Last edit at 11/12/2007 02:16AM by Jean-Yves Rouffiac.

Options: ReplyQuote


Subject
Written By
Posted
Search-engine schema
November 07, 2007 08:18AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.