Better Suggestion For Paging ?

• sm_iransoftware

  Ten Centuries

  Points: 1228

  More actions

  February 17, 2015 at 9:10 am

  #304390

  We have This Query :

  SELECT * FROM VW_1 WHERE F1 Like '%|13|%' ORDER BY F2 DESC OFFSET (1 - 1) * 10 ROWS FETCH NEXT 10 ROWS ONLY

  SELECT ceiling(COUNT(*)/10.0) as pagecounter, COUNT(*) as itemcounter FROM VW_1 WHERE F1 Like '%|13|%'

  Do you have better performance Suggestion for this type Of Queries ?

• sm_iransoftware

  Ten Centuries

  Points: 1228

  More actions

  February 17, 2015 at 10:40 pm

  #1778246

  Sorry

  I dont get it.

  This is Wrong method Or standard ?

  I got time for for this Queris :

  about 5 sec for first part and about 3 sec for counting (page numbers)

  is this best method for get page numbers and display records for first page ?