# Transactional Group Records Getting Stuck In Store & Forward **URL:** \ **Category:** Ignition\ **Tags:** scripting\ **Created:** [September 17, 2025, 12:24pm UTC](https://forum.inductiveautomation.com/t/transactional-group-records-getting-stuck-in-store-forward/110708 "2025-09-17T12:24:36Z")\ **Posts on this page:** 1\ **Showing post:** 5
**Author:** ![MMaynard](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/mmaynard/32/3366_2.png) [@MMaynard](https://forum.inductiveautomation.com/u/MMaynard)\ **Post date:** [September 20, 2025, 12:35pm UTC](https://forum.inductiveautomation.com/t/transactional-group-records-getting-stuck-in-store-forward/110708/5 "2025-09-20T12:35:12Z")
200 records to SQL Server is NOT a heavy load by any means. I would script this and either do a gateway tag change script to trigger it, or schedule it with the API call and then use the bulk insert code from this thread utilizing the prepInsertQMarks specifically. I gather around 4000± tag values every 15 minutes and write the values to rows in a database that are 4 columns wide, the entire thing is done in around 8 seconds, mind you this is also gathering those data points from 15 different gateways. > [@Tag History to CSV and Back how do i fix ignition crash?](https://forum.inductiveautomation.com/t/tag-history-to-csv-and-back-how-do-i-fix-ignition-crash/75124/14): > > Insert multiple rows at once. But, as @pturmel said, it may only support a few thousand question marks. I modified your script, shown below. Start with 500 rows at a time, then raise or lower depending on how it runs. def runAction(self, event): import csv def prepInsertQmarks(numOfGroups, groupSize): ''' Generate a string of grouped question marks for prepUpdate inserts example: Generate three groups of four question marks: prepInsertQmarks(3, 4) returns (?,?,?,?),(?,?,… --- _[View the full topic](https://forum.inductiveautomation.com/t/transactional-group-records-getting-stuck-in-store-forward/110708)._