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.