# Organizing SQL tables and named queries efficiently

**URL:** <https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212>\
**Category:** Ignition\
**Created:** [November 17, 2021, 9:45pm UTC](https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212 "2021-11-17T21:45:15Z")\
**Posts on this page:** 3\
**Page:** 3

<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 2, 2022, 3:11pm UTC](https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212/41 "2022-02-02T15:11:15Z")

</div>

> [@zacharyw.larson](#):
>
> will be linear growth

This is not necessarily true if your queries execution plan is two full table scans of the same table - then you will have polynomial n^2 growth. Don't assume, just check the execution plan.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [February 2, 2022, 3:23pm UTC](https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212/42 "2022-02-02T15:23:20Z")

</div>

Thanks, that makes sense.

I have only used Ignition so far.  
I haven’t used any software to look at the SQL side.

I discussed it some on the forums. I haven’t taken the step yet.

---

<div class="post-metadata">

**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\
**Post date:** [April 13, 2022, 8:26pm UTC](https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212/43 "2022-04-13T20:26:09Z")

</div>

> [@zacharyw.larson](#):
>
> I ran alter table, set the infeed/outfeed columns as bigint  
> I made tags, they work like positive counters, datatype bigint

Today I looked, and my tags that were bigints, are set as integers in the tag browser?  
I thought the tag browser had big int as an option for the datatype.  
I thought bigint and int8 were the datatypes I had used. I don't see bigint as an option now.

[Previous page](https://forum.inductiveautomation.com/t/organizing-sql-tables-and-named-queries-efficiently/53212.md?page=2)