jaymc Posted March 1, 2007 Share Posted March 1, 2007 I have a profile feature on my website where it will tell a member who has visited there website and how many times Is it a concern that i currently have 500,000 rows Im pretty sure I have it planned out as best as I can A row gets created for each member that visits a members profile, if they visit again a row doesnt get created, instead it ammends a counter in the existing row I have a large memberbase which explains the 500,000 rows, but I dont think I can structure it any better unless I used seperate tables. The table only gets accessed when someone views a profile which obviously isnt frequently OK to allow that table to build up with them rows or will it eventually kill the server when its trying to query through 1,000,000 rows Quote Link to comment Share on other sites More sharing options...
effigy Posted March 1, 2007 Share Posted March 1, 2007 How are these tables structured? What kind of joins are taking place? What indexes are in play? What does EXPLAIN tell you? Quote Link to comment Share on other sites More sharing options...
jaymc Posted March 2, 2007 Author Share Posted March 2, 2007 I have no joins The table is indexed perfectly, its just a massive table Quote Link to comment Share on other sites More sharing options...
fenway Posted March 2, 2007 Share Posted March 2, 2007 I have no joins The table is indexed perfectly, its just a massive table If it's as perfect as you think, you wouldn't be asking this question... I suggest you answer effigy's questions first. Quote Link to comment 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.