4 ms·
except they used sql server and sql server performance with this is awful, oracle would have been able to handle it much better
by teddyuk 7y ago
except they used sql server and sql server performance with this is awful, oracle would have been able to handle it much better
- tfehring 7y agoIt’s much better now since SQL Server 2017 added a new string split function. But I actually had to do basically the same thing in an earlier version of SQL Server (in my case, it was because I was interacting with a legacy application that spits out pipe-delimited strings) and the string parsing increased the execution time by several orders of magnitude.