platformaerp.com

General Notes

System is based on Microsoft Sql Server Database

Testing Speed

Note: Remember before esting speed cleanup buffers

SQL
DBCC DROPCLEANBUFFERS; --only on test server, this clear everything
set statistics time on
;EXEC [log].[wall_list] @username='m.kotynia', @pageindex='1', @remoteid='3ebae957-1281-4a5e-8f16-006d228d16ac', @remotesource='firm', @groupIDFilter= null
set statistics time off