Why is it that the i-net SQL Server driver seems to be slower than other drivers in my tests?
SQL Server 2000 SP4:BigDecimal parameter send by driver will processed up to 20% slower. This happens if parameter definition send by Driver don't exactly match the column type. For example Driver sends parameter as “decimal(38,36)”, the column type is “numeric (7,0)”. It seems that the index for the numeric column won't used with SP4. With SQL Server 2005 or earlier SQL Server version such a behavior was not seen. A workaround for that problem is to cast to column type.
E.g.SELECT * FROM testnumeric WHERE a = CAST(? AS NUMERIC(7,0));
© Copyright 1996 - 2016, i-net software; All Rights