john.locke

652 reputation

315

bio	website
	location
	age
visits	member for	1 year, 5 months
	seen	Nov 24 '12 at 5:23
stats	profile views	76

	652 reputation	bio	website		visits	member for	1 year, 5 months
315 badges		location			seen	Nov 24 '12 at 5:23

summary answers questions tags badges favorites bounties reputation activity

159 Actions

suggestions reviews revisions comments badges posts accepts all

May 2	awarded	Popular Question
Mar 22	awarded	Self-Learner
Feb 19	awarded	Popular Question
Feb 15	awarded	Popular Question
Jan 22	awarded	Notable Question
Dec 19	awarded	Notable Question
Dec 14	awarded	Popular Question
Dec 2	awarded	Yearling
Oct 31	awarded	Popular Question
Sep 13	awarded	Popular Question
Aug 1	accepted	Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table?
Aug 1	comment	Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table? @JonSeigel, will these updates make the user table fragmented?
Aug 1	comment	Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table? Will updates cause fragmentation on the table?
Aug 1	comment	Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table? Each user will have a shop for him/herself. I want to know how many products each user have.
Aug 1	asked	Should I put followers_no & following_no & product_no & last_login and etc in the user table? Won't updates cause fragmentation on the table?
Aug 1	comment	How to manage millions of users? `Be fast to launch and find the problems as they come` this part is excellent. That's true. If we find problems as they come there won't be any serious problem at later times. +1
Jul 21	comment	Why am I getting `Impossible WHERE noticed after reading const tables` in explain query? I have rows that matches `fromid=60 AND toid=78`
Jul 21	comment	Why am I getting `Impossible WHERE noticed after reading const tables` in explain query? @ypercube, The above query will result in 'impossible...' bacause of `is_approved IN()`
Jul 21	comment	Why am I getting `Impossible WHERE noticed after reading const tables` in explain query? So how should I say for example: if its `fromid=12 AND toid=78` then check if `is_approved='f'` or `is_approved='t'` or `is_approved='s'`
Jul 20	comment	Why am I getting `Impossible WHERE noticed after reading const tables` in explain query? @RolandoMySQLDBA, there will be `using index` in extra instead of `impossible...`