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!

Register Log in
  • Congratulations Chriss Miller 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: *

  1. anandsatchin

    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...
  2. anandsatchin

    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...
  3. anandsatchin

    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
  4. anandsatchin

    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...

Part and Inventory Search

Back
Top