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 Link to comment https://forums.phpfreaks.com/topic/40784-500000-rows/ 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? Link to comment https://forums.phpfreaks.com/topic/40784-500000-rows/#findComment-197460 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 Link to comment https://forums.phpfreaks.com/topic/40784-500000-rows/#findComment-197491 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. Link to comment https://forums.phpfreaks.com/topic/40784-500000-rows/#findComment-198061 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.