35 reputation
5
bio website
location
age
visits member for 2 years, 3 months
seen Sep 19 at 5:45

Jul
4
awarded  Popular Question
Apr
10
accepted mysql transaction vs lock
Mar
19
accepted foreign key constraints on same table
Sep
21
awarded  Custodian
Sep
9
answered query optimization for update nested query IN(SELECT
Sep
5
reviewed Approve suggested edit on foreign key constraints on same table
Sep
5
asked foreign key constraints on same table
Aug
21
awarded  Scholar
Aug
21
awarded  Supporter
Aug
14
comment mysql transaction vs lock
Hi rolando..i have read your the wiki link in your post..
Aug
11
comment MySQL optimized query
@ypercube no i did not for this specific query..but yes i have measured for my many other queries where i gained more performance because of the joins with temp. table instead of the sub queries like wise "IN()"
Aug
11
asked mysql transaction vs lock
Jul
29
awarded  Student
Jul
15
comment MySQL optimized query
hi guys thanks for the comments..but..i used the temporary table bcos..i think..it is more efficient then using subqueries..am i wrong??
Jul
13
asked MySQL optimized query