Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: anandsatchin
- Order by date
-
query optimization
Hi... Thank a lot for your respone. I will have go with my test server. The table has around 5000 rows only. The main concern was that.. I thought it is not professionaly to write 6 update statement and was sure that there must be a way to put into a single query using case statement(which...- anandsatchin
- Post #3
- Forum: MySQL
-
query optimization
Hi... I need to exectue all the 6 queries in a sequential order which are stored in stored procedure. I am just wondering is there any way to make general into one query with CASE statements or any other better statement I can use. Cheers DB: MySql 5.0 Table Name: sorting_temp Column...- anandsatchin
- Thread
- Replies: 3
- Forum: MySQL
-
Mysql Query performance
hi, The tables are indexed properly. The main diffence between 2 queries are that, if I use the left join it takes longer time( and almost hangs) and if u use right join it takes fraction of seconly only. I dont know why it is happening.. Cheers Anway- anandsatchin
- Post #3
- Forum: MySQL
-
Mysql Query performance
Hello, wondering whether anyone could shed light on my problem.. Basically, I need to exectute a query, when I execute the first query (with left join), it takes nearlly 4 mins 29.88 sec and the same query (with right join), it takes nearlly 0.22 sec. I know I might be wrong somewhere..can...- anandsatchin
- Thread
- Replies: 2
- Forum: MySQL
