# NAS with built in SQl server

**URL:** <https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278>\
**Category:** Archived Topics\
**Created:** [July 27, 2015, 10:37am UTC](https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278 "2015-07-27T10:37:23Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [July 27, 2015, 10:37am UTC](https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278/1 "2015-07-27T10:37:23Z")

</div>

I was wondering if anyone had use a NAS with built in SQL server, I like the idea but can’t help feeling that there could be problems.

I’d be interested in views or experiences

---

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [July 31, 2015, 8:40am UTC](https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278/2 "2015-07-31T08:40:31Z")

</div>

To answer my own post;

I found I had a Buffalo TS3400R rack mounted unit on the shelf, so I powered it and configured it for RAID10 and setup the MySQL server, it has a useful phpMYAdmin front end and I set up a schema for Ignition using the standard MYISAM engine.

I then made a Ignition project on a PC and blasted the NAS with 1000+ historical tags every 50ms and two sets of transaction groups with 200 tags one at 100ms and one at 10ms.

So far I have 25 million lines and its not missed a beat, reading data back in to a table or chart is quick, just as I local instance.

I’m out of the office for two weeks so I’ll leave it and see what happens.

---

<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:** [July 31, 2015, 1:02pm UTC](https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278/3 "2015-07-31T13:02:21Z")

</div>

[quote=“Chris Taylor”]1000+ historical tags every 50ms and two sets of transaction groups with 200 tags one at 100ms and one at 10ms.[/quote]That’s a great test load. I’m looking forward to your later report.

---

<div class="post-metadata">

**Author:** ![Chris\_Taylor](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/chris_taylor/32/3315_2.png) [@Chris\_Taylor](https://forum.inductiveautomation.com/u/Chris_Taylor)\
**Post date:** [August 18, 2015, 10:47am UTC](https://forum.inductiveautomation.com/t/nas-with-built-in-sql-server/10278/4 "2015-08-18T10:47:52Z")

</div>

So  
Two weeks later. Over 250 million lines, tag history is good and quick but reading the 10ms tables on to an easy chart is slow for any thing bigger than an hour, but I suspect its the amount of data. I upped the number of connections allowed and it vastly improved.

All in all I’m quite pleased. I have a project coming up and I might use it with the tag history splitter and make the NAS the long term repository.