Organizing SQL tables and named queries efficiently

[bkarabinchak.psi]

@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.

[zacharyw.larson]

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.

[zacharyw.larson]

@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.