Description |
* Issue:
** Saving with 195+ records on the grid to Print Card List and Pin List eventually takes > 5 minutes and times out
* Requirements:
** Change Grid Select and Save to only work with Removing Records
** Add Generate Button
*** Should Be After Save button and Before Print Card List Button
*** Select All Records from Encode Card and update Encode Staging Table
** When Clicking Print Card List and Print Pin List Buttons
*** Do not save each record individually, instead do this as a mass SQL command.
*** Use Existing data in Staging Table for Printing (from Generate Button)
*** Give Error if no records in Staging Table (ie missed Generate step)
** When Clicking Encode Cards Button
*** Do not save each record individually, instead do this as a mass SQL command.
*** Use Existing Data in Staging Table for Encoding Printer Table (from Generate Button)
*** Give Error if no records in Staging Table (ie missed Generate step)
*** Only Delete Records after Encoding is completed that were part of the Generated Table
**** After Encoding is done, Continue to Delete from both Staging Table and the Base Encoding Table
* Steps to Recreate:
** When user is trying to Print Card List getting error message showing below with over 200 cards
** Run first time, it will generate the records in about 40 seconds
** Run print pin list it will generate the records in over 5 minutes and time out
*** Sometimes this happens by the 3rd/4th time.
** There are no errors showing in the console log
** Recyclng the app pool had limited help for this, as very soon thereafter it would extend beyond 5 minutes.
|