Database structure, optimizing table with lots of rows
- by aepheus
I have a table with a lot of rows. The structure is something like this:
UserID | ItemID | Item Data...
Would I see any gains in query time if I separated this into a table per user, or per smaller group of users?
Queries are always single user getting/modifying a selection of items.