Re: text fields and performance for ETL

2021-11-04 Thread David G. Johnston
On Thursday, November 4, 2021, Grega Jesih wrote: > > So why would it then be published ? Because inexperienced programmers take > your statement that "it's the same performance" from a wrong perspective, > so it would be fair to note, that the remark "it's the same performance" is > meant

RE: text fields and performance for ETL

2021-11-04 Thread Grega Jesih
David, > Can you demonstrate, with actual numbers, using today's implementation, a > situation where defining a column as char(3) or varchar(3) instead of text > has a significant performance improvement? Sure I can. But first, what am I to prove ? A performance in dataflow from server A to