I am using weblist in my application . SQL view is used in my application to load the data in my application . SQL view is taking 3 or 4 second when i execute it in sql server (record approx 150000). when I load the grid in my web application it takes approx 14 to 15 seconds . I need to optimize this time 15 second to 2 second . please suggest me how can i do it . i have tried onload and onshow both events but same there is no progress and for sql filter i am using PSSQLFilter .
Please suggest me how can i optimize my webview . i am sending sample here .


Object oList is a cWebList
Set pbServerOnRowClick to True
Set pbShowHeader to True
Set piPageSize to 80
Set pbAutoSearch to True
Set pbFillHeight to True
Set piSortColumn to 0


Object osampleURegRef is a cWebColumnLink
Entry_Item sample.URegRef
Set psCaption to "Reference"
Set piWidth to 100
Set peAlign to alignLeft
Set psCSSClass to "RowCaption"


Procedure OnClick String sRowID String sCellValue
Register_Object oZoomRegistrationDetails
Send NavigateForward of oZoomRegistrationDetails Self
End_Procedure
End_Object


Object osampleJDescrip is a cWebColumn
Entry_Item sample.Jobs
Set psCaption to "Job"
Set piWidth to 150
Set peAlign to alignLeft
End_Object






Procedure OnSetCalculatedValue String ByRef sValue
If (sample.StatCd eq 0) Move "No Entries" to sValue
If (sample.StatCd eq 1) Move "Incomplete" to sValue
If (sample.StatCd eq 2) Move "Complete" to sValue
If (sample.StatCd eq 3) Move "Finalised" to sValue
If (sample.StatCd eq 4) Move "Entered" to sValue
If (sample.StatCd eq 13) Move "Cancelled" to sValue
If (sample.StatCd eq 14) Move "Preregistration" to sValue
Forward Send OnSetCalculatedValue (&sValue)
End_Procedure


Procedure OnDefineCssClass String ByRef sCSSClass
If (sample.StatCd eq 0) Move "Status_NoEntries" to sCSSClass
If (sample.StatCd eq 1) Move "Status_InComplete" to sCSSClass
If (sample.StatCd eq 2) Move "Status_Complete" to sCSSClass
If (sample.StatCd eq 3) Move "Status_Finalised" to sCSSClass
Forward Send OnDefineCssClass (&sCSSClass)
End_Procedure
End_Object