What is the most optimal database structure?

[thomashillard]

I am building a classified listing website. I am not sure if I should make a table for each category of listings or if all the listings should be inserted into one table.

Will it make a difference when I write the MySQL syntax for searching the listings and returning content from multiple categories?

[Drakla]

thomashillard wrote:

Will it make a difference when I write the MySQL syntax for searching the listings and returning content from multiple categories?

not if it's indexed on the category id.