| Author |
Topic |
|
Keysle
Starting Member
15 Posts |
 Posted - 2010-10-07 : 22:47:40
|
| How should I log user activity?Should I have a table for each user or store it all in one?http://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-07 : 23:04:56
|
| Let's say I have 5 million users (1/10 of facebook)How isn't that table going to get large fast?Does that size threaten the site's delivery time?Also, should I store the descriptions in the user general table? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-07 : 23:51:54
|
| A description could be very long or very short.I want the same flexibility as a facebook description.I honestly don't know what my hardware looks like, 1and1 currently is hosting my site. (the site is not up yet)http://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-08 : 01:34:37
|
| So the user activity could literally have 1 quadrillion entries and it won't slow down the system? Does the automatic partitioning help accomplish this?http://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-08 : 01:52:51
|
| Do you think that's how facebook does it?http://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-08 : 02:05:37
|
| Myspace is kind of slow. Do you think it's because of their architecture?Youtube uses SQL and they keep activity logs (though I'm not sure how long those logs run for)I will worry about activity logs later. I'm not sure people are all that hyped to have them quite yethttp://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Keysle
Starting Member
15 Posts |
Posted - 2010-10-08 : 02:14:57
|
| @"I don't think there's a single system that has a quadrillion rows in it"Facebook keeps logs they have 500 million users. I'm sure they've got a couple thousand logs on some people.I'll worry about how they do it later.http://Keysle.com/* I am going to be on here a lot until I get my project done */ |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
How should I log user activity