What's wrong with this code? =/

[eluser]Abel A.[/eluser]
Yeah, what you were doing sounded pretty complex lol

Though, it's always good to know how to use views. I once did it for a class project and it was no fun

Creating table_extras is definitely a good solution, BUT it should only be used if you're not going to join both tables 100% of the time. If you're going to need the extra fields for each query, then you might as well use a view. Vertical partitioning comes in handy when you're not constantly calling the extra table.

You can read a bit about it here: http://en.wikipedia.org/wiki/Partition_(...ng_methods

What you were doing in your original db structure was horizontal partitioning, which should only be used if you have millions and millions of rows.

Good luck with your project! keep us updated!