30 reputation
14
bio website
location
age
visits member for 1 years, 1 months
seen Mar 13 at 9:17

I am web developer at numbertank.


Mar
12
comment MySQL query with order by decreased performance
@Mihai, there is already one composed index (userid, userstatus, fullname ), but it doesn't used in plan. it is using primary key, may be because I have write <> on that field
Mar
12
comment MySQL query with order by decreased performance
@ypercube, I have just changed it. it is working, but no performance gain
Mar
12
comment MySQL query with order by decreased performance
UNION ALL may result duplicate data, and subquery has already using index
Mar
12
comment MySQL query with order by decreased performance
@ypercube, Order by 1,2 can be removable. I just want to check, and If I remove extra warpping, query takes 2 seconds, means performance is bed. I have explained in detaild
Mar
12
asked MySQL query with order by decreased performance
Mar
1
awarded  Scholar
Mar
1
accepted Performance with IN clause
Feb
27
awarded  Supporter
Feb
27
comment Performance with IN clause
thanks @gbn, But how engine goes to each pointer. means I have doubt, If I have pass values as 4,3,19,25,2 then engine first go to record no 4 then jump reverse on record 3 and then jump over 19 and 25 and again reverse on record no 2? so, I think this is not good.
Feb
27
asked Performance with IN clause
Feb
2
awarded  Notable Question
Sep
2
awarded  Popular Question
May
10
comment Should store procedures be cached?
sorry for this. It is done by mistek
May
10
asked Should store procedures be cached?
May
6
asked Select query very slow
May
6
comment Same Parameter in MySQL Stored Procedure
thanks @a1ex07, What details you want. If you suggest, I can provide you that detail.
May
4
asked MySQL localhost vs Amazon RDS instance
May
4
comment Same Parameter in MySQL Stored Procedure
I have tested whatever you suggest. but I am surprised, because very first time I am getting my query result in 0.079s. but after that it goes to very high. (about 0.250s). why so?
May
3
asked Same Parameter in MySQL Stored Procedure
Apr
16
asked Amazon RDS MySQL performance issues