HXTT JDBC Products: MS Access JDBC, Cobol JDBC, DBF JDBC, MS Excel JDBC,CSV JDBC, Text JDBC, Corel Paradox JDBC, PDF JDBC, Word JDBC, XML JDBC

String functions in SQL with HXTT DBF	Kevin	2020-01-30 08:16:16
We're using HXTT DBF v7.0, and we've noticed a problem with using string functions in SQL statements. In particular if we use the RIGHT(), LEFT(), or SUBSTR() functions, the performance is very negatively affected, with queries taking 3 times longer or more. Is this a known issue? Is there a way to improve the timing of these queries?
Re:String functions in SQL with HXTT DBF	HXTT Support	2020-01-30 19:47:49
>RIGHT(), LEFT(), or SUBSTR() functions The latest package has quicken LEFT() and RIGHT().

Email: