For the empty sX table (the first one) kdb hangs but for the null sX table (the second one) it works and splays the table as expected.
However if I now type
it takes more that 60s to calculate. In fact any calculation is very slow on this splay table. However the calculation on tX (the imported table) is fast. In addition if I cast everything to symbols and then splay the table, the calculations is fast.
I have been trying to replicate this error in a small piece of code without success. It seems to be specific the the table I am loading. Does anyone have any ideas or suggestions of where I am going wrong. I am completely at a loss...
Could there be special characters that are not allowed in varchar?
Is there a limit on the number of varchar columns?