CODEWITHSUNDEEP
mysqldatabaseperformance
user2754528
user2754528

Reputation: 527

increase performance of mysql rows vs users

I have a server with 128MB ram.I have enabled user registration.The users that register generate data and store them.The data they generate is huge eg clicks ,profile info,referrer urls,unique id,states etc, Is it wise for me to create a table for each user and store them individually will that increase query performance? or should I group all users in one giant table with several rows? The difference would be while selecting username123.fileid where id = 2 vs veryongtable.username123 where fileid = ""

Upvotes: 0

Views: 38

Answers (1)

sekky
sekky

Reputation: 834

I think its better to keep the users in one table and if your query runs slowly, add an index for the relevant columns.

You have to be careful though, to not run out of memory with only 128mb ...

Upvotes: 2

Related Questions