# Save information every 6 seconds in the database

**URL:** <https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013>\
**Category:** Ignition\
**Tags:** ignition80, database, vision\
**Created:** [February 10, 2022, 11:08pm UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013 "2022-02-10T23:08:30Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [February 10, 2022, 11:08pm UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013/1 "2022-02-10T23:08:30Z")

</div>

hello I have an expression tag and I need it to save the information every 6 seconds.

in my expression I have the following

`getSecond(now(1000))`

and in the tag event in value changed

I have the following

```auto
if currentValue.value != previousValue.value:
					INS = "INSERT INTO RF_HISTORY (DATE, RF_ID, NUM) VALUES (?, ?, ?)"
				
					Contador = system.tag.read("[.]contadorPorScript")
					Fecha = system.date.now()
				
					system.db.runPrepUpdate(INS,[Fecha,"Linea_Disco",Contador.value],"TOPY_MW")
				
					system.tag.write("[.]contadorPorScript",0)

```

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [February 11, 2022, 1:17am UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013/2 "2022-02-11T01:17:58Z")

</div>

The simpler solution is to turn on history with minimum time between samples of 6 seconds. Also possibly a transaction group set to a 6 second interval.

---

<div class="post-metadata">

**Author:** ![antonio.sanchez](https://avatars.discourse-cdn.com/v4/letter/a/a587f6/32.png) [@antonio.sanchez](https://forum.inductiveautomation.com/u/antonio.sanchez)\
**Post date:** [February 11, 2022, 2:00pm UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013/3 "2022-02-11T14:00:47Z")

</div>

I have not used this tool, do you have an example?

---

<div class="post-metadata">

**Author:** ![JordanCClark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/jordancclark/32/83362_2.png) [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\
**Post date:** [February 11, 2022, 2:02pm UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013/4 "2022-02-11T14:02:40Z")

</div>

`floor(getSecond(now())/6)` would help your expression change every six seconds.

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [February 11, 2022, 2:03pm UTC](https://forum.inductiveautomation.com/t/save-information-every-6-seconds-in-the-database/56013/5 "2022-02-11T14:03:39Z")

</div>

[https://inductiveuniversity.com/courses/tag-historian-in-ignition/8.0](https://inductiveuniversity.com/courses/tag-historian-in-ignition/8.0)

and

[https://inductiveuniversity.com/courses/transaction-groups-in-ignition/8.0](https://inductiveuniversity.com/courses/transaction-groups-in-ignition/8.0)

can get you started. I recommend going through the whole catalog of courses at some point.