c# - Reduce Execution Time in MYSQL from ASP.NET -

i have table relevant gps application in mysql. whenever executing asp.net application showing fetal error. have decided run in mysql, take more 1 min(exactly 70 sec) executing sp. possible sort out issues.

further information:

table 1 : server_gpsdata(it contains gps data. locks every 10 secs gps device).

select * server_gpsdata sd  inner join mstcab mc on mc.cabid= sd.cabid  inner join server_tblstatus ts on ts.statusid= mc.cabstatusid  inner join carmaster cm on cm.carid= mc.carid  inner join cabtype ct on ct.cabtypeid= cm.sizeid  date(sd.cur_datetime) =current_date ,        mc.cabid not in (select d.cabid trncabdriver d                         date(d.logintime)=current_date) ,        sd.gpsdataid in (select max(sgd.gpsdataid) server_gpsdata sgd                         date(sgd.cur_datetime)=current_date                         group sgd.cabid); 

the following should show significant improvement in performance:

select sd.*, mc.*, ts.*, cm.*, ct.*  (select max(sgd.gpsdataid) maxgpsdataid server_gpsdata sgd   date(sgd.cur_datetime)=current_date   group sgd.cabid) sdm inner join server_gpsdata sd on sdm.maxgpsdataid = sd.gpsdataid inner join mstcab mc on mc.cabid= sd.cabid  inner join server_tblstatus ts on ts.statusid= mc.cabstatusid  inner join carmaster cm on cm.carid= mc.carid  inner join cabtype ct on ct.cabtypeid= cm.sizeid  left join trncabdriver d on mc.cabid= d.cabid , date(d.logintime)=current_date d.cabid null 

note both existing , proposed queries returning columns server_gpsdata, mstcab, server_tblstatus, carmaster , cabtype tables - query perform better if columns required selected in query.