# Reddit like app - use single or multiple tables? **URL:** \ **Category:** ScyllaDB\ **Created:** [December 12, 2022, 10:12am UTC](https://forum.scylladb.com/t/reddit-like-app-use-single-or-multiple-tables/168 "2022-12-12T10:12:28Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Dude86](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/dude86/32/105_2.png) [@Dude86](https://forum.scylladb.com/u/Dude86)\ **Post date:** [December 12, 2022, 10:12am UTC](https://forum.scylladb.com/t/reddit-like-app-use-single-or-multiple-tables/168/1 "2022-12-12T10:12:28Z")
Hello there, I am evaluating ScyllaDB for purpose of creating an application that would be in Reddit style. So, I have like Subreddits (Topics), Posts (Questions) and Comments (answers for that specific post). Do I need to separate tables for Topics, Questions and Comments? Do they need to have some between them with relations? Performance-wise, what is the best model? What do you think about this proposal? And should I have relations between them. ![image](https://us1.discourse-cdn.com/flex016/uploads/scylladb/original/1X/0a48c0bae95053165e05eb83678afeb85ea72fd9.png) ---
**Author:** ![avikivity](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/avikivity/32/38_2.png) [@avikivity](https://forum.scylladb.com/u/avikivity)\ **Post date:** [December 13, 2022, 3:40pm UTC](https://forum.scylladb.com/t/reddit-like-app-use-single-or-multiple-tables/168/2 "2022-12-13T15:40:20Z")
The best model depends on what you expect to be the most common query. You should start with listing queries. e.g. all posts for a subreddit, all comments within a post, and weight them by frequency and importance. The table structure will be derived from that. ---
**Author:** ![Guy](https://sea2.discourse-cdn.com/flex016/user_avatar/forum.scylladb.com/guy/32/9_2.png) [@Guy](https://forum.scylladb.com/u/Guy)\ **Post date:** [December 14, 2022, 4:49am UTC](https://forum.scylladb.com/t/reddit-like-app-use-single-or-multiple-tables/168/3 "2022-12-14T04:49:49Z")
The [Data Modeling and Application Development course](https://university.scylladb.com/courses/data-modeling/) on ScyllaDB University, starting with Basic Data Modeling, might also be of interest.