BPSoftware.com

While working on a report based on the results of a complex stored procedure I  encountered what I considered to be a strange behavior.  I noticed that when the stored procedure was executed directly the results were returned in seconds and they were returned in several minutes when executed from the report.

 

After further looking into the execution I realized that the parameters in the report were “prefetched” and analyzed where they were used in the procedure. which took some time.  I made a few small changes to the procedure and had favorable results.  I declared local variables, assigned them the values that were passed to the procedure and used the local variables within the procedure for filtering the data.  The report results were returned in the same interval as executing the stored procedure directly.

If you have used the default installation of Microsoft Excel 2010 you might have noticed that the macros commands do not appear to be readily accessible.  To access Macro options from the Ribbon you must customize the ribbon to display the Developer tab.

From the menu choose: File Options Customize Ribbon and place a check adjacent to the Developer option.

I've made a few updates to the Swansea, MA Police Dispatch Log page.

• The date range for the incidents in the database is now displayed.
• The number of incidents to display on the map at one time is now adjustable. This can be adjusted based on the performance of your machine.
• The incident and date are listed in the marker list links
• The database was populated back through January 2009. 

I did receive questions as to how often the database is updated. The database is updated shortly after the Swansea Police Department Dispatch Log is update on the Swansea Police Department website.