MySQL Forums
Forum List  »  Data Warehouse

Re: Large Database Question
Posted by: John McGiles
Date: February 13, 2010 10:40AM

Ok, let's say I create three tables for each library instead of one, that could be done. There would be the time to join them which would be expensive but probably worth it for the space saved.

The only problem I would have then would be, how do I make it searchable? Currently what I'm doing is taking the first entry for a given book or volume and putting it into a master table which I then index using Sphinx.

Assuming I want to search any library by book title, author, volume title, book size, or volume size this makes it easy because all the information is available in one table. What do you think about this idea and do you have any better ways to make this more quickly searchable with less repetition?

Options: ReplyQuote


Subject
Views
Written By
Posted
8238
February 10, 2010 09:30PM
4744
February 11, 2010 10:27PM
3844
February 12, 2010 08:39AM
3983
February 12, 2010 06:23PM
3826
February 12, 2010 06:33PM
4049
February 13, 2010 01:45AM
Re: Large Database Question
3918
February 13, 2010 10:40AM
3718
February 13, 2010 03:38PM


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.