# mySQL: Most efficient tables?

**URL:** <https://forum.kirupa.com/t/mysql-most-efficient-tables/200915>\
**Category:** programming\
**Created:** [September 16, 2006, 3:13pm UTC](https://forum.kirupa.com/t/mysql-most-efficient-tables/200915 "2006-09-16T15:13:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![StarXploser](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/starxploser/32/875_2.png) [@StarXploser](https://forum.kirupa.com/u/StarXploser)\
**Post date:** [September 16, 2006, 3:13pm UTC](https://forum.kirupa.com/t/mysql-most-efficient-tables/200915/1 "2006-09-16T15:13:33Z")

</div>

Hello,  
I’m building a small app that lets people find users with the same interests.  
I dont know exactly what I will put in there but I was thinking something like, Favorite Book, Movie, Actor,…,hobby,etc…

I would like to hear from you guys if you think that the way I’m building my mySql tables makes sense, I don’t want to restructure everything after the site is launched. So here is what I have so far:

## USERS

## | ID | Name | D.O.B | Etc… |

## FavBOOKS

## | BookTitlte | UserID |

## FavActor

## | ActorName | UserID |

## ETC…

## | … | … |

Does it make sense? Is there a better way?

Thanx