User Profile

Collapse

Profile Sidebar

Collapse
jonnyyadav
jonnyyadav
Last Activity: Dec 5 '13, 08:15 AM
Joined: Apr 5 '13
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • jonnyyadav
    replied to How to make MYSQL Query faster
    in MySQL
    thanks for the reply. making indexes to my columns really made my o/p very faster in 2-3 seconds. thnaks a lot...
    See more | Go to post

      Leave a comment:

    • jonnyyadav
      replied to How to make MYSQL Query faster
      in MySQL
      this is the result i have got. i did not understand what it means.
      1 SIMPLE histpric ALL 196480 Using where; Using temporary; Using filesort

      1 SIMPLE bsnshistpr ALL 196480 Using where; Using join buffer
      1 SIMPLE stcurr eq_ref PRIMARY PRIMARY 4 mprofitmysql.bs nshistpr.asseti d 1 Using where
      See more | Go to post

        Leave a comment:

      • jonnyyadav
        started a topic How to make MYSQL Query faster
        in MySQL

        How to make MYSQL Query faster

        This query is taking 3 minutes to execute it. pls healp me to make it faster.
        Code:
        select histpric.timetick, stcurr.externalid, stcurr.assetid,stcurr.asset_name,bsnshistpr.bse_price,
bsnshistpr.nse_price, histpric.eod_price 
from bse_current as stcurr join Stock_Hist_Price_2013 as histpric on stcurr.assetid = histpric.assetid  
join BSE_NSE_Hist_Price_2013 as bsnshistpr on stcurr.assetid = bsnshistpr.assetid 
and histpric.timetick
        ...
        See more | Go to post
        Last edited by Rabbit; Apr 5 '13, 04:31 PM. Reason: Please use code tags when posting code.
        No activity results to display
        Show More
        Working...