Organizing SQL tables and named queries efficiently

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.

3 Likes

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.

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.