i have long sql query taking around 35 seconds execute data. want limit data 10 records each offset , limit mysql below mssql query?
select distinct pasgroupbuydata.grouppa, pasgroupbuydata.dateshipon, pasgroupbuydata.dateshipon2, pasgroupbuydata.packingslipsmade, pasgroupbuydata.productiontime, pasgroupbuydata.reorder, dsd.designname, dsd.designcode, dsd.designid, dsd.dsid, pasgroupbuydata.machineid, ordertype = 1 quotes_manufacturer inner join pasdata on pasdata.pa = quotes_manufacturer.pa inner join pasgroupbuydata on pasgroupbuydata.grouppa = pasdata.grouppa inner join designsystemdesigns dsd on pasgroupbuydata.designid = dsd.designid (pasgroupbuydata.status = 3) , (quotes_manufacturer.accepted = 1) , (pasgroupbuydata.dateshipon <> '".$thissunday."') , (pasgroupbuydata.dateshipon <> '".$lastsunday."') union select distinct pasgroupbuydata.grouppa, pasgroupbuydata.dateshipon, pasgroupbuydata.dateshipon2, pasgroupbuydata.packingslipsmade, pasgroupbuydata.productiontime, pasgroupbuydata.reorder, dsd.designname, dsd.designcode, dsd.designid, dsd.dsid, pasgroupbuydata.machineid, ordertype = 2 quotes_supplierandmanufacturergroupbuy inner join pasgroupbuydata on pasgroupbuydata.grouppa = quotes_supplierandmanufacturergroupbuy.grouppa inner join designsystemdesigns dsd on pasgroupbuydata.designid = dsd.designid inner join pasdata on pasdata.grouppa = pasgroupbuydata.grouppa (pasgroupbuydata.status = 3) , (quotes_supplierandmanufacturergroupbuy.accepted = 1) , (pasgroupbuydata.dateshipon <> '".$thissunday."') , (pasgroupbuydata.dateshipon <> '".$lastsunday."') union select pasdata.pa, pasdata.dateshipon, pasdata.dateshipon2, pasdata.packingslipsmade, pasdata.productiontime, pasdata.reorder, dsd.designname, dsd.designcode, dsd.designid, dsd.dsid, pasdata.machineid, ordertype = 3 quotes_manufacturer inner join pasdata on pasdata.pa = quotes_manufacturer.pa inner join designsystemdesigns dsd on pasdata.designid = dsd.designid (quotes_manufacturer.accepted = 1) , (pasdata.status = 3) , (pasdata.grouppa = 0) , (pasdata.dateshipon <> '".$thissunday."') , (pasdata.dateshipon <> '".$lastsunday."') union select pasdata.pa, pasdata.dateshipon, pasdata.dateshipon2, pasdata.packingslipsmade, pasdata.productiontime, pasdata.reorder, dsd.designname, dsd.designcode, dsd.designid, dsd.dsid, pasdata.machineid, ordertype = 4 quotes_supplierandmanufacturer inner join pasdata on pasdata.pa = quotes_supplierandmanufacturer.pa inner join designsystemdesigns dsd on pasdata.designid = dsd.designid (pasdata.status = 3) , (quotes_supplierandmanufacturer.accepted = 1) , (pasdata.grouppa = 0) , (pasdata.dateshipon <> '".$thissunday."') , (pasdata.dateshipon <> '".$lastsunday."') union select id pa, _date dateshipon, _date dateshipon2, 0 packingslipsmade, productiontime, 0 reorder, title designname, ' ' designcode, 0 designid, 0 dsid, machineid, ordertype = 5 calendar (_date <> '".$thissunday."') , (_date <> '".$lastsunday."') , (_date > getdate()-1) , (_date < (getdate()+30)) order pasgroupbuydata.dateshipon, pasgroupbuydata.machineid, pasgroupbuydata.grouppa
thanks gordon. have found correct syntax use offset , limit mssql queries.
example: offset ".$offset." rows fetch next ".$limit." rows 
Comments
Post a Comment