# Partition still happening after turned off in Gateway? **URL:** \ **Category:** Ignition\ **Tags:** database, ignition81, vision\ **Created:** [October 18, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339 "2022-10-18T14:28:37Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\ **Post date:** [October 18, 2022, 2:28pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/1 "2022-10-18T14:28:37Z")
Hello all! I am setting up some trend charts that will log tag history. I turned off partitioning as we are going to be manually archiving data past a certain number of days. I noticed today when looking into SSMS that a table was automatically created. I am not sure as to why this would happen if I have turned off partitioning. I could also be overlooking something, although I believe this could be related to partitioning. Here is the log for when it was automatically created ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/a/2/a298c8dea019beef5154ddbfbbe8df30177019df.png) and here is the table in the database, which is recording new values. The old table is now not recording new values. ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/d/5d3178c8aa721454bae74c9782953116c930e29f.png) Here is the gateway settings for this database ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/6/a/6aab21d264cc11fe697e67b71b3ad7be725b1680.png) EDIT: I did see that the table would be created if the "[enable partitions](https://docs.inductiveautomation.com/display/DOC81/Ignition+Database+Table+Reference#IgnitionDatabaseTableReference-sqlth_1_data)" was unchecked. Although, I did this after enabling tag history a couple of weeks ago. It shows the new table was created today. If I need any more information, please let me know! ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [October 18, 2022, 3:58pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/2 "2022-10-18T15:58:54Z")
I'm confused, you said the old table is not recording new values. Why would it, you turned off partitioning? See this doc, [Ignition Database Table Reference - Ignition User Manual 8.1 - Ignition Documentation](https://docs.inductiveautomation.com/display/DOC81/Ignition+Database+Table+Reference#IgnitionDatabaseTableReference-sqlt_data_X_X) ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/0/309c022bd1adb6ba9077cf4cc04e1febd3d50eee.png) ---
**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\ **Post date:** [October 18, 2022, 4:07pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/3 "2022-10-18T16:07:45Z")
Poor choice of words, my mistake. I meant that I turned off partitioning about a week ago. Although today it created the new `sqlth_1_data` table. The data was originally going into the `db_owner.sqlt_data_1_2022` up until this new table was created today. I figured it would've created the `sqlth_1_data` as soon as partitioning was turned off. ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [October 18, 2022, 4:16pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/4 "2022-10-18T16:16:53Z")
Not sure on that, might want to contact support. To clarify, data was going to the old table up until today? So, if you look at the old table there was data from yesterday? ---
**Author:** ![Raymond\_Sipes](https://avatars.discourse-cdn.com/v4/letter/r/4491bb/32.png) [@Raymond\_Sipes](https://forum.inductiveautomation.com/u/Raymond_Sipes)\ **Post date:** [October 18, 2022, 4:39pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/5 "2022-10-18T16:39:43Z")
Yes, luckily, I was going through the logs and noticed it. I will contact support and see what they think. Thank you! ---
**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\ **Post date:** [October 18, 2022, 4:43pm UTC](https://forum.inductiveautomation.com/t/partition-still-happening-after-turned-off-in-gateway/65339/6 "2022-10-18T16:43:16Z")
It is my understanding that tables won't be created until they are needed, so if today was the first time data was logged then I could see it, but if data was being logged a full week after the change I have no explanation for that