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.