Skip to main content
Question

numeric vs float data type performance

  • April 22, 2020
  • 1 reply
  • 11 views

yossibm

Hi,
It looks like reading the same amount of data takes twice as much time using numeric(8,4) as opposed to float (using pyodbc, reading into pandas). Is it the expected behavior?
Thanks,
Yossi

1 reply

yossibm
  • Author
  • Participating Frequently
  • April 22, 2020

found a workaround: cast to float on the select query.