acidglitter Posted January 15, 2008 Share Posted January 15, 2008 I've put this off for a while, because I'm worried that anyway I go about this it will kill my bandwidth and make my site load really slow, but I really want to find a way to fix this.. This is one of my sites: http://zombieadds.com And if you're not familiar with myspace friend adding sites, they way they work is you add someone to get a point, then the points reset once a day to be fair to people new to the site. I have a mysql table that has a new row inserted with your friend id and the person you're adding so you won't add the same person twice. BUT the table empties when the points reset. I want to keep that, but I also want a table with will keep track of your friend id and every person you've EVER added, that way you never have to add the same person twice.. BUT that could easily end up having hundreds of thousands of rows in a week. And it seems like one table having like a million rows would slow the entire site down.. So does anyone have any ideas for how I could keep track, but without slowing down the loading time for my site? Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/ Share on other sites More sharing options...
fenway Posted January 15, 2008 Share Posted January 15, 2008 Well, you'll have to store it somewhere... Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/#findComment-440174 Share on other sites More sharing options...
acidglitter Posted January 17, 2008 Author Share Posted January 17, 2008 But *how* should I store it? Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/#findComment-441978 Share on other sites More sharing options...
fenway Posted January 17, 2008 Share Posted January 17, 2008 Why empty the table when it resets? Why do the points have anything to do with the friends being added to a table? Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/#findComment-442066 Share on other sites More sharing options...
acidglitter Posted January 24, 2008 Author Share Posted January 24, 2008 I guess they don't and I'll just stop emptying that table everyday, but will that slow down my site too much to have such a huge table? Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/#findComment-447893 Share on other sites More sharing options...
fenway Posted January 24, 2008 Share Posted January 24, 2008 I guess they don't and I'll just stop emptying that table everyday, but will that slow down my site too much to have such a huge table? Unlikely... besides, it's one per friend, not one per point. Quote Link to comment https://forums.phpfreaks.com/topic/86184-how-should-i-do-this-mysql-help/#findComment-448003 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.